Hi,
I migrated SQL database (WINDOWS 2000) to ORACLE 8i running on SUN SOLARIS.
The front end was written in VB.
When i tried to connect to ORACLE database (remote) it fails, but some how it succedds after couple of failures.Again it fails. But i can connect to the database successfully by SQL PLUS with out any problems.
The error it gives when it fails is as follows.
"DB ACCESS - oracle error occured.But error message cannot be retrieved from oracle."
AND MICROSOFT VISUAL BASIC
"RunTime-error 3709
The connection cannot be used to perform this operation.It is either closed or invalid in this context"
PLEASE ADVICE ME ON THIS.
Thank You
Regards
Aruna.
Start Free Trial