- Make sure you've installed a 32-bit ODBC client, VFP requires that (even if the server is 64-bit)
- If you follow Dragan's suggestion and set up a DSN, make sure you do it using odbcad32.exe from the SysWOW64 folder (or whatever the equivalent is on Win10)
- Make sure the server is listening on the port you specify, and that firewalls on the client or server are not blocking the port or the ODBC client
>thanks but I've already tried with this link but without success :(
>
>
>>>Hi all
>>>
>>>I have no experiences with Oracle Database but I have to retrieve data from one :)
>>>
>>>I have connection pameters, and odbc driver installed on the PC where the connection seems to work, by using the windows form I mean.
>>>
>>>I'm trying to connect to the database by SQLSTRINGCONNECT trying to get a valid Handle but I can't
>>>
>>>here is what I have :
>>>
>>>
>>>Host: hostip
>>>Port: 1521
>>>Service_Name: servicename.loc
>>>
>>>User: username
>>>Pwd: mypassword
>>>
>>>anybody knows how the connection string should look ?
>>>
>>>actually i send this one
>>>
>>>Driver={Microsoft ODBC for Oracle};Port=1521;Server=hostip;Service_name=servicename.loc;Uid=username;Pwd=mypassword
>>>
>>>but i get the error : 1526 : connectivity error ..connectattr failed
>>
>>
http://www.connectionstrings.com/oracle/
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up