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=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
sending to informix-list

Hi, just to let you know I get sqlerrm(systables) if I get the path to
the informix database in the database name field in the driver
configuration form wrong. If this is correct, connects ok.



Don't know if that helps but maybe the error message means the driver
cannot locate the systables, and perhaps its something to do with the
database path.


--
Posted via http://dbforums.com