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