ASP, ODBC and Informix on NT
Posted in 1997
Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing
Good Day. I'm writing an application that will extract data from an Informix Database using a web interface. The application is using ASP (Active Server Pages) and ODBC to connect to Informix 7.22 on NT. The ODBC driver is the Informix CLI driver (from Intersolve). The entire code is below .... with the corresponding error message. I've used the same DSN with an access database to test the connectivity and it works fine. Seems like a web specific thing. (The "user" connecting via the web server is "informix" so I don't believe that it's a security thing.) Appreciate any suggestions! Thanks! CODE: Set Conn = Server.CreateObject("ADODB.Connection") Conn.ConnectionString = "dsn=INFXCLI; database=biz_mktg; uid=informix; password=informix;" Conn.Open("INFXCLI") (<=== Error occures here) Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "tbl1", Conn, 3, 3 vResponse = rs.Fields("uid") Response.Write vResponse ERROR: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Specified driver could not be loaded due to system error 126 (INFORMIX-CLI 2.5 (32 bit)). /asp/a.asp, line 4