By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

ADO Connection.Open fails

P: n/a
The statement that begins with o.open in the procedure below raises
either a "Type Mismatch" error or a "Method ~ of Connection object
failed" error on SOME workstations. Does anyone have a clue as to
what might be wrong? Could the Jet OLEDB driver be at fault here?

Any help would be appreciated.

Dan Fisherman

Private Sub Command1_Click()
Dim o As ADODB.Connection

On Error GoTo ProcError
Set o = New ADODB.Connection
o.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program
Files\MacPac\Personal\ci.mdb"
Exit Sub
ProcError:
MsgBox Err.Number & ": " & Err.Description, "AGG CI Test"
Exit Sub
End Sub
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Make sure the other stations have equal or newer MDAC's.

On your development computer, check the version of ADO that you referenced
and make sure that the clients are running that version or greater. ADO is
backward compatible, no guarantee that it is forward compatible.

Check http://www.microsoft.com/data for the latest Microsoft data access
components.
"Daniel Fisherman" <df********@optonline.net> wrote in message
news:a9**************************@posting.google.c om...
The statement that begins with o.open in the procedure below raises
either a "Type Mismatch" error or a "Method ~ of Connection object
failed" error on SOME workstations. Does anyone have a clue as to
what might be wrong? Could the Jet OLEDB driver be at fault here?

Any help would be appreciated.

Dan Fisherman

Private Sub Command1_Click()
Dim o As ADODB.Connection

On Error GoTo ProcError
Set o = New ADODB.Connection
o.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program
Files\MacPac\Personal\ci.mdb"
Exit Sub
ProcError:
MsgBox Err.Number & ": " & Err.Description, "AGG CI Test"
Exit Sub
End Sub

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.