DBF->ODBC->Oracle: ORA-02041
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@hsodbc
All work fine.
In VFP put command: sqlexec(hconn,'select * from table@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