April 9, 2007 at 10:09 am
Hi,
I am using SQL Express and attached DB from within VS.NET 2005. I've added the SQLServer database item from the VS 2k5 environment and now i cannot write or edit data inside that db file.
Namely if i execute a stored procedure from the VS ide directly it inserts data and everything seems fine.
When i try to insert some data from the app (C#) itsself it doesn't throw any exception or error but also nothing is writen into DB. Weird. really weird. I also tried to insert some simple data using insert sql statement directly without SP's and still won't work (very basic query like INSERT INTO Table (field1) VALUES ('test'))
Also if it helps the connection is established successfully.
If i chec the connection object state it returns open.
Can you please suggest something in order to resolve this strange problem?
TIA
April 10, 2007 at 8:43 am
Your problem is not user privileges but user instance it is a database you create with Express in VS currently SQL Server is not aware of it, but Microsoft provided a way for you to connect your database to Management Studio. Try the link below for details. Hope this helps.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply