ASP/IIS connect to Informix
Posted in 2004
We have Windoes 2000 server with IIS 5.1 and using ASP programs to connect the Informix database IDS 9.4 in IBM AIX machine. But we keep getting such error messages: Micorsoft OLE DB Provider for ODBC DRivers (0x80004005) [Informix][Informix ODBC Driver]General error. /where/the/AP/is/program.asp, line 76 line 76 of the ASP is as follows where try to do open task: 75 set conn=Server.CreateObject("Adodb.Connection") 76 conn.open "dsn=DSN;uid=UID;pwd=PWD;database=DATABASE" We have tried the Informix Client SDK 2.5 and 2.7, both get the same error. What confused us is when such error happens, we get OK status by using Informix ODBC Apply & Test Connection and DBPing is ok. At the same time, ASP still works fine to connect to SQL Server. Only ASP program fail! Thanks for any comment!