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@Oracle9(COMPANYCODE,BRANCHCODE,JOBNO,H OUSEBLNO)
(SELECT
FwdBook_Hbl.COMPANYCODE,FwdBook_Hbl.BRANCHCODE,Fwd Book_Hbl.JOBNO,FwdBook_Hbl.HOUSEBLNO
FROM FwdBook_Hbl@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...