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
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