|
Home > Archive > Sybase ODBC > July 2005 > Problem with Sybase Open Client 12.5.1 ESD #7 - Sybase Adaptive Server Enterprise driver
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with Sybase Open Client 12.5.1 ESD #7 - Sybase Adaptive Server Enterprise driver
|
|
|
| Sybase Open Client 12.5.1, ESD#7
One of our VB application encountered the following error message when using
Sybase Adaptive Server Enterprise driver,
(-2147467259- [sybase][ODBC Driver] [Adaptive Server enterprise] stored
procedure 'SP' may be run only in unchained transaction mode. The 'SET
CHAINED OFF' command will cause the current session to use unchained
transaction mode.
Here is the SP's sql code,
select sched_count = count(*)
from db1..tbl1 s, db2.tbl2o
where cp = @CP
and type = 'A'
and s.col1= o.col1
and o.per = @Per
Any ideas?
Thanks
| |
|
| Hi
We need more information like the portion of vb code where this is invovled.
It sounds like there are some settings or calls that cause the problem. It
seems that the sproc was created to be used only in Chained Off mode. Then
it seems that the VB app is set to use chained mode - if that occurs then
this error will occur.
Look at your DSN - and in the advanced tab uncheck "Server Initiated
Transactions" and see if this helps.
-Paul
"liy" <li_yuping@bls.gov> wrote in message news:42e7e0d8$1@foru
ms-2-dub...
> Sybase Open Client 12.5.1, ESD#7
>
> One of our VB application encountered the following error message when
using
> Sybase Adaptive Server Enterprise driver,
>
> (-2147467259- [sybase][ODBC Driver] [Adaptive Server enterprise] stored
> procedure 'SP' may be run only in unchained transaction mode. The 'SET
> CHAINED OFF' command will cause the current session to use unchained
> transaction mode.
>
> Here is the SP's sql code,
>
> select sched_count = count(*)
> from db1..tbl1 s, db2.tbl2o
> where cp = @CP
> and type = 'A'
> and s.col1= o.col1
> and o.per = @Per
>
> Any ideas?
>
> Thanks
>
>
| |
|
| The application is working after uncheck "Server Initiated Tansactions".
Thanks for your help.
"Paul" <Paul@sybase.com> wrote in message news:42e80bbb$1@foru
ms-2-dub...
> Hi
>
> We need more information like the portion of vb code where this is
> invovled.
> It sounds like there are some settings or calls that cause the problem.
> It
> seems that the sproc was created to be used only in Chained Off mode.
> Then
> it seems that the VB app is set to use chained mode - if that occurs then
> this error will occur.
>
> Look at your DSN - and in the advanced tab uncheck "Server Initiated
> Transactions" and see if this helps.
>
> -Paul
>
>
> "liy" <li_yuping@bls.gov> wrote in message news:42e7e0d8$1@foru
ms-2-dub...
> using
>
>
|
|
|
|
|