Thanks for the reply as usual Sergey.

Does this mean that I have to install the 32-bit Windows ODBC Manager and the 32-bit Oracle ODBC driver?

>VFP can only use 32-bit ODBC drivers. For 32-bit applications under 64-bit Windows there's ODBC Data Source Administrator for the 32-bit ODBC drivers %systemdrive%\Windows\SysWoW64\\odbcad32.exe (usually C:\WINDOWS\SysWOW64\odbcad32.exe).
>
>>
>>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
>>