>To All,
>
>I need to test an existing application that now runs under WinXP and connects to Oracle via Microsoft ODBC for Oracle driver.
>In the future this application will be used in Windows 7 64 bit environment
>
>Maybe somebody can bring some lights:
>1. Should I look for ODBC driver for 64 bit (based on the OS) or 32 (based on VFP)?
>2. Where can I find Microsoft ODBC for Oracle for Windows 7?
>
>Before I used smtg simple like :
>
>FUNCTION InitiateOracle
> LOCAL lcODBCDriver, lcSettings, lcPSUserID, lcPSUserPwd, lnConnectHandle
>
> DECLARE INTEGER SQLConfigDataSource IN odbccp32.DLL INTEGER, INTEGER, STRING, STRING
>
> lcConnectString = ["]+"DRIVER={Microsoft ODBC for Oracle};SERVER="SERVER NAME";UID="MYID";PWD="MYPASSWORD"
>
> lnConnectHandle = SQLSTRINGCONNECT(&lcConnectString)
>
> RETURN lnConnectHandle
>ENDFUNC
For VFP to be able to use it, it must be a 32-bit driver. Although long deprecated, that driver still seems to be available:
http://social.msdn.microsoft.com/Forums/eu/sqldataaccess/thread/fba94ec7-ed6f-4a8b-b028-1f5d62baa5edhttp://msdn.microsoft.com/en-us/library/windows/desktop/ms713590%28v=vs.85%29.aspxIf you are setting up a 32-bit ODBC driver on a 64-bit system, be sure to use the 32-bit ODBC Administrator:
http://support.microsoft.com/kb/942976A good resource for connection strings is
http://connectionstrings.com/ .
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up