I'm having a strange behavior with VFP9sp2
Using VFP front end to communicate with Oracle 9i database
When creating DSN in ODBC32, connection is successfull with both ORACLE ODBC driver is 9.02 and Microsoft for Oracle 6.01.7601.19135
When compiling VFP EXE. The Application works! It connects to Oracle.
Here is the weird part....
When running the app within VFP9, the ODBC dialog appear asking for password and every time it fails to give a handle
I've tried SQLConnect() and SQLStringConnect(), same behavior with both OCBC32 drivers.
So, I'm unable to debug and every time I want to test I need to compile.
Any Clue how to resolve this odd behavior?
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)