Hi all,

Is there a known issue with running VFP9 on a Windows 2003 64-bit server and connecting to an Oracle database using the 64-bit Oracle 10.2.0.1 ODBC driver ? The Oracle database itself is also 64-bit.

* This works on a Windows 2003 32-bit server using 32-bit Oracle 10.2.0.1 ODBC driver.
CONNECTIONSTRING= "DRIVER=Oracle in OraClient10g_home1;UID=myuser;PWD=mypwd;SERVER=oraserver;DBQ=oraserver;"
open datatabase oradb
create connection 'test' connstring (connectionstring)
?sqlconnect('test') && returns > 0

* This does not work on a Windows 2003 64-bit server using 64-bit Oracle 10.2.0.1 ODBC driver.
CONNECTIONSTRING= "DRIVER=Oracle in OraDb10g_home1;UID=myuser;PWD=mypwd;SERVER=oraserver;DBQ=oraserver;"
open datatabase oradb
create connection 'test' connstring (connectionstring)
?sqlconnect('test') && returns <= 0