ORA-02041:Client database did not begin a transaction.
Hi I've created a dblink from a istance X to istance oracle Y, and it's ok.
I've created a view in X for take my interested rows from more tables into istance Y and it's ok.
I've created a statement SQL in the instance X joined with my view but in the SQLPlus
and Toad work fine, but when lunch this statement from my application appear this error:
ORA-02041:Client database did not begin a transaction.
my application it's LabSystem Lims - Sample Manager and it's application for laboratory analisys automation.
it work with language VGL. But the problem are Windows ODBC for me !
In fact with SQLplus the statement work fine, while in application based wiht odbc connection don't work...
i've a client Oracle9i and my odbc are 9.02.00.
Istance running in 8i, i've tried also connect via odbc 8.1.7 but the result it's the same...
OS platform it's Sun Solaris.
Regards
thanks in advance
Alberto Frosi