Re: Oracle Gateway + Sybase Anyware

• Original Message ----- From: "Harri Kaukovuo" <harri.kaukovuo4_at_nic.fi> Newsgroups: comp.databases.oracle.misc Sent: Saturday, November 16, 2002 10:59 AM Subject: Re: Oracle Gateway + Sybase Anyware

> Looking at:
> http://otn.oracle.com/products/gateways/pdf/sybase816.pdf

I've read this document but i have not found any references to versions compatibility.

> looks like Sybase 12.5 is not supported with 8.1.6 Transparent Gateway.
> This might be the reason for your problems?

Maybe. We are going to migrate on 8th version of Sybase (12.5 is version of the
client). Perhaps it will help. BTW, the same error I get when I tried to use Gateway under HP-UX.

>
> The question mark in the SQL statement points to the bind parameter passed
> to the SQL, not the actual "?" value.

Well, but can I fix it. Are there exist any useful parameters be able to help me on the sybase side ?

>
> -- Harri
>
> "Evgeny Filippenkov" <filippenkov_at_svitonline.com> wrote in
> news:aqv9hb$e80$1_at_news.kiev.sovam.com:
>
> > Hello !
> > I have installed Oracle Transparent Gateway for Sybase ver. 8.1.6
> > under W2K, configured it and connected to Sybase Anyware 12.5. Gateway
> > works fine. I can read data from Sybase and perform remote transaction
> > but when I tried to commit _distributed_ transaction I received next
> > error : SQL> commit;
> > commit
> > *
> > ERROR at line 1:
> > ORA-02053: transaction 7.135.2649 committed, some remote DBs may be
> > in-doubt ORA-28500: connection from ORACLE to a non-Oracle system
> > returned this message:
> > [Transparent gateway for SYBASE]tm_recover-forget commitconfirm:
> > cannot delete
> > CC record(nvDeleteCCRecord) rc=-2224 tdp=: anyware
> > ORA-02063: preceding 2 lines from ANYNI
> > --
> > The transaction was commited on the both databases, but gateway didn't
> > delete line from table RECOVER.HS_TRANSACTON_LOG on Sybase side. User
> > RECOVER was created, table HS_TRANSACTON_LOG was created and
> > privileges were granted too. I've found following lines in gateway's
> > trace file : (0) DELETE FROM RECOVER.HS_TRANSACTION_LOG WHERE
> > (0) (RECOVER.HS_TRANSACTION_LOG.GLOBAL_TRAN_ID = ?)
> > --
> > I guess the problem is because in where clause plased "?" instead of
> > real transaction ID.
> > Does anybody know how to resolve this problem ?
> > Thanks in advance.
> >
> >
> >
>
>
>
> --
> -----------------------------------------------------------------------
> Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4
>
>
Received on Sun Nov 17 2002 - 23:09:08 CST