>>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?
>
>With ODBC errors, AERROR( ) usually contains information useful for debugging. If you call it after an ODBC error, you can view the contents of the array, write the contents out to a file with STRTOFILE( ) etc.
The AERROR( ) is : "Connectivity error: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name
But it is not true, it Works if compiled or going with the ODBC interface or with TOAD...
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)