In a web application of VS.Net 2005 I am able to insert records in both the database SQL 2000 & 2005
In a windows application of VS.Net 2005 I am able to insert record in SQl 2000but I am not able to insert record in SQL 2005 Express Edition.
Please help Me I tried very Much but not succeded yet.
Thanks in Advance
HTH, Jens Suessmeyer.
Is there no error message, but no row in the table. If this is the case try turning off implicit transactions.
To see what options are in effect from your client app run select @@options
To turn off implicit transactions you can do that through your api (preferred if you are using Multiple Active Result Sets)
or through the following T-SQL
SET IMPLICIT_TRANSACTIONS OFF
hi there,
commonly it is a permisssion problem
try allowing your server to accept
remote connection.
regards,
To answer your question will require one of two things:
1. Extra sensory perception, or ESP.
2. More information about what the error you are getting. Not to mention if the web app is using the same code, or different code and if it is using the same SQL Server 2005.
My guess is that if the web app is using a default instance of 2005, you might not be connecting the express edition correctly, like perhaps not passing the instance name in the connect string since express always uses a instance.
Thanks all,
Actually i have created a desktop application in c#.net 2005 and SQL Server 2005 by using a datagridview i am displaying all the data which i phisycally entered in that table but when i tried it through the code then it shows that evry thing is fine not any error message and shows successfully inserted and also displyes in datagridview.
When i stops the application and opens the db it does not show the record which i entered.
When i again start the application this time it also does not show the records which i entered.
But this all scenerio works fine with SQL Server 2000, it displays records in application as well as in database.
My guess is that your application is using some sort of transaction that it automatically starts but that is not getting closed. Or you are working on a disconnected set (couldn't tell that without profiler, and that isn't included in Express. Where these settings are sounds more like a programming issue than a T-SQL problem.
I would probably suggest you take this to the C#/.NET forums. I can move the thread if you want.