>>We are testing our app on Oracle 64 bit version 10g. I am using a dsnless connection:
>>
>>sqlstringconnect('driver={Oracle in OraGBGHome1020;server=gbg.watqatest17;uid=username;pwd=password', .T.)
>>
>>I am using the oracle driver installed by oracle.
>>The database is 'gbg' on server 'watqatest17'. The TNS is gbg.watqatest17
>>
>>I have tried creating a system DSN to test the connection and it works.
>>
>>However, the sqlstringconnect does not work. I only get a -1 returned. I am testing this using vrunfox8 (shell program for foxpro downloaded from
www.leafe.com) on the installed machine.
>>
>>From my development machine (windows xp with oracle 10g server installed) I can connect to the 64 bit oracle database, but not from the 64 bit machine itself. Even attempting to connect to other databases from the 64 bit machine fails. Does anyone have any sugggestions?
>>
>>Jason
>
>Try this connect string:
>Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
>
>Carsten
That driver is not installed on the 64 bit machine. Our oracle guy had not been able to find a 64 bit driver for "microsoft odbc for oracle".