Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Schaeflein, Paul — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.