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