473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Excepton Error Message......

I am getting the following error message when the rollback statement is
called in a ODBC transaction object.
Exception Details: System.InvalidOperationException: This OdbcTransaction
has completed; it is no longer usable.
I am using propritery ODBC driver to connect to Image database running on HP
box.
There is no try and catch block for the RollBack statemnt.
Thanks for your response.
John
Nov 18 '05 #1
5 1818
..
"John Smith" <Jo************@hotmail.com> wrote in message
news:eB*************@TK2MSFTNGP11.phx.gbl...
I am getting the following error message when the rollback statement is
called in a ODBC transaction object.
Exception Details: System.InvalidOperationException: This OdbcTransaction
has completed; it is no longer usable.
I am using propritery ODBC driver to connect to Image database running on
HP
box.
There is no try and catch block for the RollBack statemnt.
Thanks for your response.
John

Nov 18 '05 #2
Show your code

"John Smith" <Jo************@hotmail.com> wrote in message
news:eB*************@TK2MSFTNGP11.phx.gbl...
I am getting the following error message when the rollback statement is
called in a ODBC transaction object.
Exception Details: System.InvalidOperationException: This OdbcTransaction
has completed; it is no longer usable.
I am using propritery ODBC driver to connect to Image database running on HP box.
There is no try and catch block for the RollBack statemnt.
Thanks for your response.
John

Nov 18 '05 #3
Here it looks like. I am sorry this may not be much helpful.

Try
Call the Insert routine.... 'Insert the data to dataset
(Image database)
myTransactionObject.Commit()

Catch ex As Exception

myTransactionObject.Rollback()

End Try
John
"Jeff Dillon" <je**@removeemergencyreporting.com> wrote in message
news:u1**************@TK2MSFTNGP15.phx.gbl...
Show your code

"John Smith" <Jo************@hotmail.com> wrote in message
news:eB*************@TK2MSFTNGP11.phx.gbl...
I am getting the following error message when the rollback statement is
called in a ODBC transaction object.
Exception Details: System.InvalidOperationException: This OdbcTransaction has completed; it is no longer usable.
I am using propritery ODBC driver to connect to Image database running
on HP
box.
There is no try and catch block for the RollBack statemnt.
Thanks for your response.
John


Nov 18 '05 #4
you are trying to rollback a transaction, that has already been rolled back
(probably die to an error). in sqlserver you can use @@trancount, to
determine if a rollback is required. check what the syntax is for your
database.

-- bruce (sqlwork.com)

"John Smith" <Jo************@hotmail.com> wrote in message
news:eB*************@TK2MSFTNGP11.phx.gbl...
| I am getting the following error message when the rollback statement is
| called in a ODBC transaction object.
| Exception Details: System.InvalidOperationException: This OdbcTransaction
| has completed; it is no longer usable.
| I am using propritery ODBC driver to connect to Image database running on
HP
| box.
| There is no try and catch block for the RollBack statemnt.
| Thanks for your response.
| John
|
|
Nov 18 '05 #5
I meant your exact code. Or more specifically, the minimum code required to
reproduce the problem.

What have you done to troubleshoot this issue? Code simplification is my
first approach.

Obviously.

Jeff

"John Smith" <Jo************@hotmail.com> wrote in message
news:#B**************@TK2MSFTNGP12.phx.gbl...
Here it looks like. I am sorry this may not be much helpful.

Try
Call the Insert routine.... 'Insert the data to dataset
(Image database)
myTransactionObject.Commit()

Catch ex As Exception

myTransactionObject.Rollback()

End Try
John
"Jeff Dillon" <je**@removeemergencyreporting.com> wrote in message
news:u1**************@TK2MSFTNGP15.phx.gbl...
Show your code

"John Smith" <Jo************@hotmail.com> wrote in message
news:eB*************@TK2MSFTNGP11.phx.gbl...
I am getting the following error message when the rollback statement is called in a ODBC transaction object.
Exception Details: System.InvalidOperationException: This OdbcTransaction has completed; it is no longer usable.
I am using propritery ODBC driver to connect to Image database running

on
HP
box.
There is no try and catch block for the RollBack statemnt.
Thanks for your response.
John



Nov 18 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: | last post by:
I am accessing the same error-containing ASP page on an ISP server using w2k IE6 but with different effect. On the first computer I get several line of HTML outputed by ASP, shown correctly by...
9
by: Mairhtin O'Feannag | last post by:
Hello, We have two machines we wish to use DPF. They are both RH ES 2.1, with DB2 8.2. I read the documentation CAREFULLY, and added the following line to my db2nodes.cfg file : 1 egret 0
6
by: Squirrel | last post by:
I have a command button on a subform to delete a record. The only statement in the subroutine is: DoCmd.RunCommand acCmdDeleteRecord The subform's recordsource is "select * from tblVisit order...
8
by: Rod | last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some reason, opening some ASP.NET applications we wrote is producing the following error message: "The Web server reported...
10
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
16
by: | last post by:
Hi all, I have a website running on beta 2.0 on server 2003 web sp1 and I keep getting the following error:- Error In:...
10
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server...
2
by: f rom | last post by:
----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.