Transaction Management with SQLServer
-
Hello, I have an problem with my project. The project is written by C#, $ used SQLServer 2005 DB. I also use Web service & Seasar to retrieve A database. And on webservice side, I have to refer to another package that is built to DLL. That package retrieve B database. My problem is when I retrieve B database and update data via dll's function. if it is success, I update A database. But A database cannot update because some error that i cannot control. How can I rollback the data that was updated in B database?
-
Hello, I have an problem with my project. The project is written by C#, $ used SQLServer 2005 DB. I also use Web service & Seasar to retrieve A database. And on webservice side, I have to refer to another package that is built to DLL. That package retrieve B database. My problem is when I retrieve B database and update data via dll's function. if it is success, I update A database. But A database cannot update because some error that i cannot control. How can I rollback the data that was updated in B database?
How muchwood would a woodchuck chuck if a woodchuck could chuck wood you might wonder? As much as it could, that's the answer! Just ask any beaver!
-
Hello, I have an problem with my project. The project is written by C#, $ used SQLServer 2005 DB. I also use Web service & Seasar to retrieve A database. And on webservice side, I have to refer to another package that is built to DLL. That package retrieve B database. My problem is when I retrieve B database and update data via dll's function. if it is success, I update A database. But A database cannot update because some error that i cannot control. How can I rollback the data that was updated in B database?
By asking in the correct forum.
-
Hello, I have an problem with my project. The project is written by C#, $ used SQLServer 2005 DB. I also use Web service & Seasar to retrieve A database. And on webservice side, I have to refer to another package that is built to DLL. That package retrieve B database. My problem is when I retrieve B database and update data via dll's function. if it is success, I update A database. But A database cannot update because some error that i cannot control. How can I rollback the data that was updated in B database?
-
Hello, I have an problem with my project. The project is written by C#, $ used SQLServer 2005 DB. I also use Web service & Seasar to retrieve A database. And on webservice side, I have to refer to another package that is built to DLL. That package retrieve B database. My problem is when I retrieve B database and update data via dll's function. if it is success, I update A database. But A database cannot update because some error that i cannot control. How can I rollback the data that was updated in B database?
You should really be asking this in the SQL forum, not the Lounge. Top of the Lounge says: The Lounge is a place where you can discuss anything that takes your fancy. If you just want to laze about and discuss things that don't quite fit elsewhere, then this is the place. Posting Guideline: The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. Do not post programming questions (use the programming forums for that) and please don't post ads. Your question doesn't fit here, but in the SQL forum :rolleyes:
-
You should really be asking this in the SQL forum, not the Lounge. Top of the Lounge says: The Lounge is a place where you can discuss anything that takes your fancy. If you just want to laze about and discuss things that don't quite fit elsewhere, then this is the place. Posting Guideline: The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. Do not post programming questions (use the programming forums for that) and please don't post ads. Your question doesn't fit here, but in the SQL forum :rolleyes: