Question about Computers & Internet
m developing an application using vb 2005 and MS Sql server 2005. At run time the application shows records being added but after closin the application when i view the table no updates have been made...
can u help me out..the same problem occured wid a teachers project i downloaded for reference which comes wid sql server 2005 sample download..the application(both of them) run widout error makin no permanent change in table...
Generally database updates either require a commit to have the database perform the appropriate checking and actually flag the rows as part of the database. That Commit can occur in two ways -- some databases can be setup with an auto commit or auto rollback when the database is disconnected. The first means the programmer needs to do nothing. The second means if the programmer does not commit the updates are backed out of the database. To commit is generally considered bad because if there are any data errors partial transactions and logically inconsistent contents can exist in a database. For example entering an order for merchandise requires a single header row to identify the customer and multiple items rows to indicate what was ordered. If the third item record added to an order had an error and the application did not rollback and the database auto committed and incomplete order with only two items would be saved in the database. Traditionally databases with an automatic action at shutdown are set to rollback to assure such partial information is not saved. Even with auto rollback good programs detect errors and rollback themselves and allow users to continue.
The net result of the above is the probability that if the inserts actually occurred as you believe the there was a missing commit to confirm their addition to the database. and an automated rollback kept them from being completely added to the database. Another alternative is that the insert was not error checked in the program code and it failed meaning despite the program counter claiming rows were inserted in fact they were not.
Posted on Dec 07, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
May 13, 2015 | Microsoft SQL Server 2005 Enterprise...
on Sep 07, 2010 | Computers & Internet
Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...
May 06, 2014 | Microsoft Database Software A5K-02817 SQL...
Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...
Jan 17, 2008 | Computers & Internet
Jan 09, 2008 | Microsoft Windows Vista Ultimate Edition
Oct 17, 2018 | eBay Computers & Internet
138 people viewed this question
Usually answered in minutes!