* 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