Thank you all for the support
At the end I got the correct string but don't ask me what it means :) :
Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostip)(PORT=1521))(CONNECT_DATA=(SID=test)));
Uid=username;Pwd=mypassword;
>>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/