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
ICQ 10556 (ya), 254117