>>* 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 >>