469,626 Members | 1,820 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

Generating Update and Insert Commands gives Error

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
2 1021
ammoos
100 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
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.

Similar topics

16 posts views Thread by Philip Boonzaaier | last post: by
20 posts views Thread by Mark Harrison | last post: by
3 posts views Thread by Patrick.O.Ige | last post: by
5 posts views Thread by explode | last post: by
13 posts views Thread by =?Utf-8?B?VmVybm9uIFBlcHBlcnM=?= | last post: by
13 posts views Thread by Terry Olsen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.