ADO in ASP with Informix 3.32 ODBC Driver
Posted in 2000
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
Hi I'm trying to connect to our Informix box (DEC Unix) from an IIS4 ASP page. I've got the Informix Client-SDK v2.5 tc2 installed on the IIS server (Informix 3.32 32 bit ODBC driver) On the IIS server, the ODBC driver is installed & configured OK: When configuring a system DSN, the database list gets populated OK & the "Apply & Test" button confirms that the connection works. I've got INFORMIXDIR & PATH set appropriately & Setnet32 has all the required connection info. However, when trying to connect to the database from the ASP page I either get: 1. with ConnectionString = DSN=mydsn;UID=mylogin;PWD=mypwd Microsoft OLE DB Provider for ODBC Drivers error '80004005' Specified driver could not be loaded due to system error 127 (INFORMIX 3.32 32 BIT). OR 2. with ConnectionString = Provider=MSDASQL; Driver={Informix 3.32 32 BIT};....etc Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified It seems that my problem is ASP & Informix ODBC specific but I just can't get it working. (Page works fine if I alter it to connect to a SQL Server DB) Please help! Thanks in advance Rob Stubbs Sent via Deja.com http://www.deja.com/ Before you buy.