SEO

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
--

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

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