Error when changing DataSet from Access to SQL

Gregory Greenman 0 Reputation points
2024-06-29T17:52:56.2233333+00:00

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.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 questions
0 comments No comments
{count} votes