By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,130 Members | 2,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,130 IT Pros & Developers. It's quick & easy.

Generating Update and Insert Commands gives Error

P: 15
I have in project in VisualBasic .NET. This project should display,add,modify,delete the rows of the tables from SQLServer EXPRESS. For this i made a connection to the SqlServer Express through the SqlDataAdapter from the tool box. The connection wizard auto generates the code for the select command only. Code for the update, delete and insert command are not generated. "connection cannot be properly configured" is shown as error.

my System configurations:

windowsXp sp2
Visual Studio 2003 with.net framework 1.1 Sp1
I have also installed .net framework 2 redistributable as a prerequirment of sqlserver express 2005.
Previously i had msde. This problem surfaced just after the installation of the sqlserver express. i used the SqlServer managemet studio to create the tables i need.

i hope this information is clear. Thanking you in advance.

note: the advanced configuration to generate the sql commands are already selected.
Aug 7 '07 #1
Share this Question
Share on Google+
2 Replies


ammoos
100+
P: 100
I think there is some problem in your database/table configuration.. pls check that you have set the permissions to table/database for insert, delete, update…..
Aug 7 '07 #2

P: 15
I think there is some problem in your database/table configuration.. pls check that you have set the permissions to table/database for insert, delete, update…..
But it works normally if i connect to Sql 2000 instead of Sql2005 !! both servers has the same database i just upgraded the database from sql2000 to sql2005 by detaching it from sql 2000 , taking a copy of it and attaching it to aql 2005, and then i connect to it via my program , in all cases i checked the permissions they are granted i also grant the permissions to the guest and public users but the problem remain
any suggestions??
by the way i have both sql 2000 and sql 2005 installed on the same Xp desktop
Aug 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.