dbTalk Databases Forums  

Setting Transaction for GetSchema-Method

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Setting Transaction for GetSchema-Method in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Kehl
 
Posts: n/a

Default Setting Transaction for GetSchema-Method - 04-26-2006 , 01:57 PM






Hello.

I use ASA.NET-Provider 2.0. Now, there is the Method GetSchema(). When I use
this and the Connection is in a current Transaction, I get an
InvalidOperationException with the fallowing text (translated from german to
english):

Remark action presupposes that the instruction has a transaction object, if
the connection, which was assigned to the instruction, takes place in a
current local transaction. The characteristic ' Transaction ' of the
instruction was not initialized.

I haven't found any way to set the Transaction for the Command which will be
used from the GetSchema-Method.

Does someone have an idea?

Thanks
Thomas



Reply With Quote
  #2  
Old   
Nick Elson
 
Posts: n/a

Default Re: Setting Transaction for GetSchema-Method - 05-02-2006 , 11:37 AM






I suspect something was lost in that translation or problem statement.

A .SLN that shows the problem might be the succinct way to state the
issue.

Are you saying you have issued a BeginTransaction already?
[before the call to the GetSchema() method?
and that by not doing the BeginTransaction it is not a problem?]

- - - -

I see a bug queue posting for this description. For that a .sln would
be a requirement.

"Thomas Kehl" <t.kehl (at) heeb.com> wrote

Quote:
Hello.

I use ASA.NET-Provider 2.0. Now, there is the Method GetSchema(). When I
use this and the Connection is in a current Transaction, I get an
InvalidOperationException with the fallowing text (translated from german
to english):

Remark action presupposes that the instruction has a transaction object,
if the connection, which was assigned to the instruction, takes place in a
current local transaction. The characteristic ' Transaction ' of the
instruction was not initialized.

I haven't found any way to set the Transaction for the Command which will
be used from the GetSchema-Method.

Does someone have an idea?

Thanks
Thomas




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.