DBF->ODBC->Oracle: ORA-02041

From: Konstantin Shurek <shurek_at_asu.ntu-kpi.kiev.ua>
Date: Tue, 29 Jan 2002 14:13:16 +0200
Message-ID: <a363j8$2n6$1@igloo.uran.net.ua>

How to transfer data from .DBF-tables to Oracle ? Server=Oracle 9.0.1.1.1 on Win2000Server SP2 client=ODBC-application (Visual Foxpro 6.0 SP5)

ODBC driver 9.00.12.00 (31.10.2001)

I use Oracle heterogeneous service.
In SQL*Plus Worksheet put command: select * from table_at_hsodbc All work fine.

In VFP put command: sqlexec(hconn,'select * from table_at_hsodbc','table') ORA-02041 client database did not begin a transaction (Cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.
Action: If the cause is the former, check that any commit is not followed by an update)
I try:
- in VFP ODBC Connection String write 'MTS=F'
  (MTS=Microsoft Transaction Server Support: T=Disabled,F=Enabled)   ora-02041
- in VFP ODBC Connection String write 'DistribTX=0' or 'DistribTX=F'
  ora-02041
- server.registry.HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OLEDB\DistribTX=0
  ora-02041
- client.registry.HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OLEDB\DistribTX=0
  ora-02041

I try Microsoft ODBC driver for Oracle - it work OK, but I can not use it because this driver don't support LOB-objects.

Is this bug ?

Konstantin Shurek Received on Tue Jan 29 2002 - 06:13:16 CST