Environment versions
Network:
Windows 2008 Server
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;
Version is 11g
>Which version of Oracle are you connecting too? Depending upon which version of Oracle you have will make a difference on which ODBC driver you want to use. Everything may look fine now - but I've had significant issues with unexpected results if you're using certain ODBC drivers with some version of Oracle . One big issue I had was getting data that was pulled from a DBLINK in oracle - one ODBC driver works whereas another one does not...plus other things like truncated character strings and such - really odd things can happen.
>
>>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
>>
>>
>>PLEASE HELP :)
>>
>>Thank you
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only