Re: ORA-02041: client database did not begin a transaction

i never use stored procedure inside my form, it's only a simple insert select statement, i don't know why there is no problem when db.open in oracle 9 and error occur in oracle 8..

Set db = New ADODB.Connection
db.Provider = "OraOLEDB.Oracle"
db.Open Oracle8, "max", "max"

db.BeginTrans

sSQL="sql statement...."

db.Execute sSQL

if return True, db.CommitTrans else db.RollbackTrans..

after db.Execute sSQL, it returns error message ORA-02041: client database did not begin a transaction

skyloon wrote:
> 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 Thu Jan 11 2007 - 19:40:10 CST