Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC connection Vs Oracle
Message
De
29/09/2015 03:59:48
 
 
À
29/09/2015 03:10:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01625162
Message ID:
01625167
Vues:
61
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform