Information générale
Titre:
ODBC connection Vs Oracle
Versions des environnements
Network:
Windows 2008 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement