ORA-02041: client database did not begin a transaction

From: skyloon <skyloon_at_gmail.com>
Date: 10 Jan 2007 19:29:37 -0800
Message-ID: <1168486177.415572.96490@i39g2000hsf.googlegroups.com>

currently im using VB connect to oracle 8i and 9i, it's a data purging program which purge data from 8i to 9i.

for example,
db.Open for oracle 8i, and when i execute insert statement into oracle 9i from 8i, it gives me this error message: ORA-02041: client database did not begin a transaction

but when i tried db.Open for oracle 9i, it won't give any error, it executes successfully.

the query is very simple,
Insert Into FwdBook_Hbl_at_Oracle9(COMPANYCODE,BRANCHCODE,JOBNO,HOUSEBLNO) (SELECT
FwdBook_Hbl.COMPANYCODE,FwdBook_Hbl.BRANCHCODE,FwdBook_Hbl.JOBNO,FwdBook_Hbl.HOUSEBLNO FROM FwdBook_Hbl_at_Oracle8)

i already created database link for these 2 servers. when i run this query in sql*plus, no problem at all. ODBC > Disable Microsoft Transaction Server (tick or untick also won't help)

Am i need to do any setting for oracle 8i?

Thanks... Received on Wed Jan 10 2007 - 21:29:37 CST