>>>>>I am trying to connect VFP to Oracle 11g with the string SQLSTRINGCONNECT("Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myuid;Pwd=mypwd"), but always return handle -1
>>>>>
>>>>>The Oracle ODBC driver is Ok, because when I test it, it returns connection successful
>>>>>
>>>>>Am I missing something?
>>>>
>>>>http://www.connectionstrings.com/
>>>
>>>My connection string is the same than that, but does not work.
>>
>>See whether aerror() is helpful.
>
>
>aerror returns code 1526, message "ORA-12154: TNS could not resolve the connect identifier specified. But the strange is that when the I test the ODBC it is OK.
>
>Following my tnsnames
>
>SPC-SC =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.160)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = PROD)

Maybe your TNSNAMES.ORA file is missing entry?