Re: ODBC API problem SQLGetInfo()

Posted in 1998

Lee Hollingworth — Fri, 7 Aug 1998 17:20:45 +0800 — source: Informix-list mailing list archive (1991-1998)

>Running the ASP(Active Server Page) results in a system 126 error which >states: >ODBC ERROR : [Intersolv][ODBC Informix Driver]The qualifier 'testdbase' was >larger than SQL_MAX_QUALIFIER_LEN from SQLGetInfo(0) > >Can't find anything about this SQL_MAX_QUALIFIER_LEN parameter. It seems to >me that indeed the name testdatabase is larger than 0 Are you sure it is SQL_MAX_QUALIFIER_LEN and not SQL_MAX_QUALIFIER_NAME_LEN? The ODBC 2.0 standard defines SQL_MAX_QUALIFIER_NAME_LEN as follows: #define SQL_MAX_QUALIFIER_NAME_LEN 34 /* MAX_CATALOG_NAME_LEN */ and was renamed in ODBC 3.0 to MAX_CATALOG_NAME_LEN. In any case it would appear that the one of either, the database name, table name or columns names in the information you are trying to gather is greater that 34 characters in length? Lee --------------------------------------------------------------------- Lee Hollingworth lee@ChilliSource.com www.ChilliSource.com