ODBC problems

Posted in 1997

Matt Deards — 13 Nov 1997 13:15:58 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, I'm using INFORMIX CLI 2.5 on NT server 4 to connect to an AIX/Informix SE database. I'm then using MS Visual Interdev to create ASP files and VBScript to write web applications. When I run up the SQL builder it connects to the DSN and SQL queries output fine but when I try and write code to connect to the database with ASP & VBScript I cant seem to create a valid ODBC connection. Heres the error I get: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. And heres the section of ASP code: Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN=mydsn;UID=myid;PASSWORD=mypass;DB=mydb;HOST=myhost;SERV=myservice;SRVR= myserver;PRO=sesoctcp;" oConn.Execute "SELECT * FROM table WHERE field LIKE uCase(strSearch)" oConn.Close set oConn = Nothing Does anyone have a clue as to whats going wrong or does anyone know of a resource that fully explains the ODBC error message? Thanks in advance for any help, Matt. Matt.Deards@taywood.co.uk