Not able to insert record in SQL server 2005 Express Edition

Not able to insert record in SQL server 2005 Express Edition

• kawing0510

  hi there,

  commonly it is a permisssion problem

  try allowing your server to accept

  remote connection.

  regards,

  
  
  

• Capitán Cavernícola

  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.

  
  
  

• AndyPham

  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

  
  
  

• jasmine pham

  Why do you think that you are not able to insert naything. Do you get an error, or is the data after a debug sesion not persisted in your SQL Express user instance If so, make sure that during the debug of the code the database is copied to the debug directory and therefore represents another datafile than the one you are using in Visual Studio. If you gt an error please post it here, that we can have a look on it.
  
  HTH, Jens Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• CBueche

  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.

  
  
  

• Netoblivion

  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.

  
  
• Not able to insert record in SQL server 2005 Express Edition