RE: Need help with Informix and ADO

Posted in 1999

Schaeflein, Paul — Fri, 23 Jul 1999 13:50:03 -0500 — source: Informix-list mailing list archive (1991-1998)

You need to add "ODBC;" in front of your connect string. Search in Deja News -- I've answered this question in much more detail before and those details are not handy at the moment. -----Original Message----- From: Letscho [mailto:markus.letschka@kstp.at] Sent: Friday, July 23, 1999 12:00 PM To: informix-list@iiug.org Subject: Need help with Informix and ADO Hi! I need to get an ODBC-Connection to an IDS (Informix CLI 2.5) via ADO. According to some examples from the MSDN I tried the following code: Dim rst As New ADODB.Recordset rst.Open "SELECT * FROM test", "DSN=somedsn;UID=max;PWD=anypwd;" Do Until rst.EOF Debug.Print rst("anyfield") rst.MoveNext Loop rst.Close At execution I get the following error Message: "Runtime Error 3706: ADO could not find the specified OLE DB Provider." The ODBC-source is installed correctly (I can access using DAO). Why does it not work with ADO? Thanks, Letscho