Re: Sequence and Oracle ODBC 8.01.07.00 driver problem

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Sat, 9 Feb 2002 08:08:39 -0000
Message-ID: <kJ498.7610$YA2.1486081@news11-gui.server.ntli.net>

Emiliano Antonello <e.antonello_at_giove.org> wrote in message news:4iT88.49710$3J1.1401585_at_news2.tin.it...
> I have a local oracle db server 8.1.7 and a remote oracle db server 8.1.7.
> I need to use a SEQUENCE that is into the remote database. I have created
a
> database link in a local user db that point into the user in remote db.
> Width ODBC 8.01.07 oracle driver, I execute the following sql statement in
> local db:
>
> select max_06_area_id.nextval_at_ITALIA from dual
>
> but I receive the error
>
> ORA-02041: client database did not begin a transaction
>
> If I try the statement in SQLPlus it's ok, but with ODBC it dosen't work.
> Then I supposed that it's the database link that dosen't work in ODBC. I
> have try to made a SYNONYMOUS but it dosen't work.
>
> How can I resolve this? Thanks.
>

Whenever I've received this error, it has been because MTS support was enabled in the ODBC driver. Disable it, and your query may well work. Received on Sat Feb 09 2002 - 02:08:39 CST