Re: ASP, ODBC and Informix on NT

Hi, If you have any more trouble with this particular ODBC driver why not try Easysoft's ODBC driver. Visit http://www.easysoft.com or email sales@easysoft.com for a free evaluation copy. Cheers, Guy Mark wrote: > 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