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

Thanks for the answer!

Actually, the first thing I tried was to create Systen DSN & use
"DSN=informix" as the connection string; it felt like the easiest
method. Also, I had heard that the driver has has problems with long
paths, so I installed it to c:\informix\.

BTW, i don't believe anymore that the problem is with user rights. I
changed the IIS anonymous login fron IUSR_machine to my own
username&passwd, and connection attempt gave the same errmsg.
(As I said before, I _can_ connect to db using other applications such
as WinSQL or MS Access with the same user id)

The 3.81 driver could be the solution. I just don't know if I am able
to acquire this, because this driver was provided to us by a third
party company for connecting to their informix-db.

I'll keep on trying to eliminate possible problem causes. I still
would appreciate any ideas about solving this problem. If I am able to
solve this, I'll post the problem & solution.

-Eero

Howard Salter <HowardSalter@penningtonseed.com> wrote in message news:<bf92pb$214$1@terabinaries.xmission.com>...
> 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