ASP VBScript ADODB.Connection for Informix

[sabev]

This is my first shot at ASP. I have some VB experiance.

I am trying to create a connection to an Informix database with VBScript.

The error appears to be in my ODBC driver information. How should this be entered? Should I be using some other type of connection object?

CODE -

Set conShark = Server.CreateObject("ADODB.Connection&quot
conShark.Open "Provider=INTERSOLV 3.01 32-BIT INFORMIX; Data Source=breck20; Database=test", "", ""

ERROR -
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/asp/test1.asp, line 21

The driver works fine for other applications.

Thanks for any help

 

[sabev]

Well, I used a data link file to get the correct connect string. Now I get a different error.

CODE -
Set conShark = Server.CreateObject("ADODB.Connection&quot
conShark.Open "Provider=MSDASQL.1;Persist Security Info=False;User ID=test;Data Source=Informix7;Mode=Read"

ERROR-
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 5 (INTERSOLV 3.01 32-BIT INFORMIX).

 

[JPvS]

hey sabey!!!
i was searching for the same error and saw ur message on it..Can you please get back on how u solved it?????
Pls lemme ASAP ..its urgent
Thanks
Deepa.

 

[sabev]

Hi Deepa,

Turned out I needed to update some .dlls.

Do a search on MDAC on Microsofts site. These are data access componantes. Seems to update the OLE DB .dll or something. Anyway, I downloaded and instatlled and it fixed me up.

http://www.microsoft.com/data/download.htm

Good luck.