Oracle Database Discussions

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,HOUSEBLNO)
(SELECT FwdBook_Hbl.COMPANYCODE,FwdBook_Hbl.BRANCHCODE,FwdBook_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...