Data Adapter Configuration Wizard help. Errors in the Insert, Update, and Delete SQL 2005

I had some trouble with an upgrade to SQL 2005 June so I unistalled both SQL 2005 and SQL 2000. I then re-installed SQL 2005 and the .Net framework. I am still having trouble with the INSERT, UPDATE, and DELETE statements generated in the Data Adapter Configuration Wizard of VS.NET.

Here are the steps I took the first go-around;
Installed SQL 2005 Express Edition
Installed .Net framework 2.0
Installed SQL Serice Express
Detached database from SQL 2000
Copied two Database files to SQL 2005 Folder
Preformed sp_removedbreplication in SQL Service Express
Attached the two new files in SQL Service Express
That was all successful.
In VS.NET:
Changed connection to new SQL 2005 server and the SELECT statement was created successfully but the INSERT, UPDATE, and DELETE statements, "There were errors configuring the data adapter".

Additional INFO:
When I try to generate Dataset I get this error:
retreiving the schema for sqlDataAdapter1 failed.
Invalid object name 'Customers'
(Customers is on of the tables in the database that I am trying to access.)

And when I try to debug it I get this error:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.

Let me know if I need to provide any other information. I saw a post in this section that said the "where" statement lead to an error, could this be the same thing since I do have a where statement with a vaiable that is set through a stored procedure.

Thanks
cank

Answer this question

Data Adapter Configuration Wizard help. Errors in the Insert, Update, and Delete SQL 2005

Brian McKeiver
Thanks DMan,

That sounds like it could be the source of the problem.

Mo
StevoK
When you generate the select statement, are you selecting the primary key from the table, and are you selecting across multiple tables ....If you do not select the primary key from the table or if you select across multiple tables then you must manually create your Insert, Update, and delete statements...
Data Adapter Configuration Wizard help. Errors in the Insert, Update, and Delete SQL 2005

Answer this question