SQl Server express Edition
-
Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx
Nana
Agyeman wrote:
Is SQl Server express Edition read only from an application
That woiuld make it pretty useless as a desktop database, wouldn't it?
Agyeman wrote:
Insert and Update doesn't work
The problem is most assuredly with your code. It would help if you posted a segment of the code you're using to try and update the database.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx
Nana
-
Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx
Nana
Agyeman wrote:
Is SQl Server express Edition read only from an application
No. You can read and write with it.
Agyeman wrote:
Insert and Update doesn't work
Like Dave said, problem may be in your SQL statement, go ahead and post your Insert and Update that aren't working...
-
Agyeman wrote:
Is SQl Server express Edition read only from an application
That woiuld make it pretty useless as a desktop database, wouldn't it?
Agyeman wrote:
Insert and Update doesn't work
The problem is most assuredly with your code. It would help if you posted a segment of the code you're using to try and update the database.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007Dave Kreskowiak wrote:
That would make it pretty useless as a desktop database
No kidding :laugh:
-
Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx
Nana
sql server express edition is only made ready only if that is what your users rights have been defined as. You can set up your user rights anyway you want. Normally you should control access to your tables through stored procedures. So one stored procedure to read data from the table, a different stored procedure to insert, another stored procedure to update, finally a stored procedure to delete. Ben
-
Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx
Nana
If I'm guessing right, you most probably have a buggy code that inserts/updates (or) the folder in which the database file (.mdf) is located is readonly. If your database file is located in someplace other than the default SQL Server installation path, check the folder and file permissions. This is a common issue in using the Express edition in ASP.NET for user management. So maybe you're stuck somewhere similar. SG