SOLVED: ASP / ADO connection to Informix

Oh yes, the problem was yet again problem with registry & permissions... What deceived me was that the machine had to be rebooted after the registry permission changes. So the steps to solve this were: 1. Assign working enviment-variables with setnet32 2. Copy these values from HK_CU\\Software\\Infomix to HKEY_USERS\\.DEFAULT\\SOFTWARE\\Informix with regcopy.exe (@ informix install dir) 3. With regedt32.exe add Full Control-permissions to IIS default users IWAM_<machine> & IUSR_<machine> (process account & anon account) to directories HK_LM\\Software\\Informix, HK_LM\\Software\\ODBC\\ODBC.INI\\Informix, HK_U\\.DEFAULT\\SOFTWARE\\Informix and informix install directory. 4. REBOOT Windows to apply these permissions (shouldn't be necessary, but did the trick for me) -Eero eero.salminen@iobox.com (Eero Salminen) wrote in message news:<b7045286.0307180336.6c43ca3@posting.google.com>... > 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