Error when changing DataSet from Access to SQL
I have a VB program that I wrote many years ago that used an Access database. The program has a DataSet that I originally created from the Access database. Recently, I tried changing the connection string it uses to point to a MS SQL Server Express database. I had used SQL Server Migration Assistant for Access to migrate the database structure and data, so those should be the same.
Now, if I select the DataSet in the Data Sources window, right click and choose "Configure Data Source with Wizard...", I get the message: "An error occurred while retrieving the information from the database - No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21)."
If I right click on a table in the DataSet and try to preview the data, I get an error message that says "<table>.Getdata() could not be previewed.- No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21)."
If anyone can tell me how to fix this, I would greatly appreciate it.