ADO in ASP with Informix 3.32 ODBC Driver
Posted in 2000
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.