Re: Connectivity problems, HELP

Posted in 1998

Lee Hollingworth — Tue, 18 Aug 1998 13:18:28 +0800 — source: Informix-list mailing list archive (1991-1998)

Sjaak van Herpen wrote in message ... >I'm trying to setup an connection with an Informix SE database version >7.2. to be able to develop dynamic web pages using Active Server Pages. >The development tool I use is Microsoft Visual Interdev 1.0. >I used several ODBC connectors (like Intersolv 3.11 with Informix >Connect) and even OLE DB, but sofar without a good result. >I'm able to make a DataSource, connect to the database and see the table >layout, but as soon as metadata get's posted, all kind of strange error >messages come up like SQL_MAX_QUALIFIER_LEN etc. etc. What you seem to be up against are ODBC limitations as defined in the ODBC 3.n Standard. While Informix has one set of maximum qualifier lengths, ODBC enforces another for example: SQL_MAX_COLUMN_NAME_LEN 64 (Microsoft Access) 10 (dBASE) 64 (Microsoft Excel 5.0, 7.0, or 97) 30 (Microsoft Excel 3.0 or 4.0) 10 (Microsoft FoxPro) 25 (Paradox) 64 (Text) If you are familiar with ODBC programming, you can write a small program to get the info from your ODBC driver using the SQLGetInfo command. Lee ---------------------------------------------------------- lee@ChilliSource.com www.ChilliSource.com -- The Home of Database Design Studio