RE: ASP / ADO connection to Informix

Have you created a System DSN for the connection and just used the connection string "DSN=informix"? Also, you may want to consider downloading the 3.81 driver. I had problems with the 3.32 driver. One more thing that may sound crazy, I found that if I installed the SDK (and subsequently the drivers) to the default dir (i.e. C:\\program files\\informix), it choked on the long filename, but when I changed the install dir to C:\\Informix it worked just fine. HTH, Howard -----Original Message----- From: eero.salminen@iobox.com [mailto:eero.salminen@iobox.com] Sent: Friday, July 18, 2003 6:36 AM To: informix-list@iiug.org Subject: ASP / ADO connection to Informix 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 sending to informix-list