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.c om>...
> 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=pw ord;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