ASP / ADO connection to Informix
Eero Salminen
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
--
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
Howard Salter
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
sqlerrm(systables)
/testinformix.asp, line 46
--
sqlerrm(systables) sqlerrm(systables) sqlerrm(systables)
/testinformix.asp, line 46
--
-Eero
sending to informix-list
Howard Salter
Eero Salminen
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 <Howard...@penningtonseed.com> wrote in message news:<bf92pb$214$1...@terabinaries.xmission.com>...
Eero Salminen
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.s...@iobox.com (Eero Salminen) wrote in message news:<b7045286.0307...@posting.google.com>...
causalnex
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