ODBC ASP Informix CLI 2.5 (32 bits)
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues, Internationalization & Character Sets, Versions, Editions & End-of-Life
Can I use the ODBC "Informix CLI 2.5 (32)" driver with ASP pages ? I work with NT Server 4.0 Service Pack 4 and IIS I use this driver with Microsoft Access and I can access to some databases of IDS under Unix I get the next error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. /scripts/prus/p2.asp, line 17 The source asp page: ... ... <% Set RS = CreateObject("ADODB.Recordset") RS.Open "SELECT * FROM mytable", _ "DATABASE=mydatabase;UID=informix;PWD=bj4abcy3;DSN=mydsn" %> ... ... The DSN "mydsn" is for a database in a IDS 7.2 under Solaris Any suggest ? --
Luis, Usually this error means that you haven't exported all the environment variables needed on the server side, i.e., INFORMIXSERVER and INFORMIXDIR Make sure the server is started and test a connection from the Data Source manager first. Regards, Stephen In article <378F2CBE.2BC867EB@ubu.es>, Luis Miguel Martin <luismi@ubu.es> wrote: > Can I use the ODBC "Informix CLI 2.5 (32)" driver > with ASP pages ? > > I work with NT Server 4.0 Service Pack 4 and IIS > > I use this driver with Microsoft Access and I can access to some > databases > of IDS under Unix > > I get the next error: > > Microsoft OLE DB Provider for ODBC Drivers error > '80004005' [INTERSOLV][ODBC Informix > driver][Informix]Unable to load locale categories. > /scripts/prus/p2.asp, line 17 > > The source asp page: > > ... > ... > > <% > Set RS = CreateObject("ADODB.Recordset") > RS.Open "SELECT * FROM mytable", _ > "DATABASE=mydatabase;UID=informix;PWD=bj4abcy3;DSN=mydsn" > %> > > ... > ... > > The DSN "mydsn" is for a database in a IDS 7.2 under Solaris > > Any suggest ? > -- > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.