Re: Help with pass-thru queries from MS Access 97

Andy wrote in <053a541c.acde705f_at_usw-ex0101-004.remarq.com>...
>I have a few pass-thru queries that I wrote for users to run from
>Access 97. They all run fine.

>However, there is one that does not seem to want to work. It is:
>Set Transaction Use Rollback Segment rb_large
>(rb_large is a valid rollback segment in our system).

>The problem is this: after running this *statement* /-passthru query-/, I
run a normal
>update query from Access, but the query does not use rb_large, it uses
>one of the normal default rollback segments.

>When I run the same "Set" query from SQL*PLUS, followed by the same
>"Update" query, it does use rb_large...this process just doesn't seem
>to want to work from Access.

set transaction use rollback segment
is NO query, it is a statement to assign the current transaction to a specified rollback segment

when you use it, it must be the first statement in your transaction - it does only affect your current transaction - Your transaction ends whenever you issue a COMMIT or ROLLBACK statement -

>Does anyone have any ideas? I appreciate your help!!!

could it be possible, that your driver terminates the transaction after every statement ??

regards Received on Mon Jan 24 2000 - 19:42:39 CST