I have written a VB6 application that connects to an MS Access database using the following connection string:
This works fine on the computer that has Visual Studio 6 installed on it but when I deploy this to a test machine it gives me an error when trying to connect to the database. I think it must be something to do with it not finding the provider?
Both my test and development machine are Windows 7 x64 and both have up to FrameWork 4.0
Any ideas?
Thanks
Simon
Code:
myConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myFilePath & ";"
This works fine on the computer that has Visual Studio 6 installed on it but when I deploy this to a test machine it gives me an error when trying to connect to the database. I think it must be something to do with it not finding the provider?
Both my test and development machine are Windows 7 x64 and both have up to FrameWork 4.0
Any ideas?
Thanks
Simon