Question Connection to a AccessDB don´t run on a WinXP PC

bendigo

New member
Joined
May 7, 2011
Messages
2
Programming Experience
Beginner
Hello

i have some problems with me connection string. On my computer (win7) the connection string runs, but on the other pc (winXP) i get the error:

Unable to cast COM object of type 'ADODB.ConnectionClass' to interface type 'ADODB._Connection'. This operation failed because the QueryInterface call on the COM component for the interface with IID

my code:
Dim catalog As ADOX.Catalog = New ADOX.Catalog()
Dim conn As ADODB.Connection = New ADODB.Connection()
Dim table As ADOX.Table = New ADOX.Table()
Dim column As ADOX.Column
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ".mdb;")

....

i copy the dll´s also to the other pc´
Interop.ADODB.dll and Interop.ADOX.dll

what is my fault?

greetings
pascal



 
sorry - i have the error --> i make my ADO reverence to Microsoft ActiveX Data Objects 2.8 Library but i need the Microsoft ActiveX Data Objects 2.1 Library (the client has a old access version)

nice weekend
pascal
 
Back
Top