informix 7.3.1 and ASP connectivity

[anandraman]

Hi,

I have an IDS version 7.3.1 installed on Solaris and i was able to connect to it from my Windows 2000 Desktop using the INTERSOLV 3.11 Driver.ILogin worked fine..Also my VB client was able to connect to the Database successfully. But when i try the same from ASP,I get an Error :- "Specified driver could not be loaded due to system error 126 (INTERSOLV 3.11 32-BIT INFORMIX 9)."

The connection string used was :-

Set cnn = server.createobject("ADODB.Connection&quot
cnn.Open "filedsn=informixfiledsn.dsn;username=informix;password=informix"

Please let me know if you faced this error and any means to rectify the same. If there is any settings in IIS to connect to Informix , please let me know.

Thanks,
Anand

 

[anandraman]

It worked after I added the PATH variable to the Informix Dir in the IIS Server machine. Inspite of having changed the registry settings to accept all users have the INFORMIXDIR ..one has to edit the PATH variable from My Computer - > Properties - > Advanced - > Environment Variables and make sure he has the path to INFORMIX set..Reboot the machine and then it should work for Good.

Good luck ...

-Anand

 

[Guest_imported]

Microsoft article Q166441 didn't work for me but this did.

Thanks

 

[OnonZero]

Hi all..

I have a problem with connecting informix server.
i use informix 2.80 32 BIT driver.
My connectition string is like that
mconn.open "fileDsn=baanforweb.dsn;" & _
"Host=192.168.20.1;" & _
"Server=myserver;" & _
"Service=myserv;" & _
"Protocol=olsoctcp;" & _
"Database=mydata;" & _
"UID=myself;" & _
"PWD=pasword;"

and it gives this error

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.

i ve use all kinda connection. There is no problem while connecting from an other app. Like delphi access.

Only when i use asp...

Pls help me as soon as possible