ASP / ADO connection to Informix
Posted in 2003
Topics: Connectivity: ODBC / JDBC / .NET
Hi I have Windows 2000 server with IIS 5.0 and I'm trying to connect to external Informix database, but no dice. I keep getting the error message: -- Microsoft OLE DB Provider for ODBC Drivers error '80004005' sqlerrm(systables) /testinformix.asp, line 46 -- What bothers me, is that I _can_ connect to the db trough Infomix ODBC driver (INFORMIX 3.32 32 BIT) using other applications like WinSQL and Access just fine. Only when I try to connect using ASP, this error occurs. I've given my IIS anonuser IUSR_<machinename> full control (using regedt32) to (registry keys) HKLM\\software\\odbc\\ODBC.INI\\Informix and HKLM\\software\\Informix and also to directory c:\\Informix\\Client-SDK\\ I have also run the Informix regcopy.exe. I have tried the several ADO connection strings like: (I copied the service etc. values directly from working ODBC-settings) -- "DSN=Informix;" & _ "UID=dbselect;" & _ "DB=flexim;" & _ "HOST=flexim;" & _ "SERV=1605;" & _ "SERVER=cli_se;" & _ "PRO=sesoctcp;" & _ "PWD=pword;" -- "PROVIDER=MSDASQL;dsn=Informix;uid=dbselect;pwd=pword;database=flexim;" -- "DSN=Informix" -- "DSN='';" & _ "Driver={INFORMIX 3.32 32 BIT};" & _ "Host=flexim;" & _ "Server=cli_se;" & _ "Service=1605;" & _ "Protocol=sesoctcp;" & _ "Database=flexim;" & _ "UID=dbselect;" & _ "PWD=pword;" -- But they all give the exact same error message. Sometimes the returned errmsg has random garbage in front of the "sqlerrm(systables)" and sometimes "sqlerrm(systables)" is repeated for several times, for example: -- Microsoft OLE DB Provider for ODBC Drivers error '80004005' sqlerrm(systables) sqlerrm(systables) sqlerrm(systables) /testinformix.asp, line 46 -- I've ran out of ammo, what else could I try? What even does this mysterious error message mean? Please help or even share your ideas for solving this problem. -Eero