Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC
Message
De
27/04/2000 03:25:30
 
 
À
26/04/2000 20:35:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: ODBC
Divers
Thread ID:
00363906
Message ID:
00364014
Vues:
21
You can use SQLSTRINGCONNECT()

Here is an example for oracle:
h=SQLSTRINGCONNECT("DRIVER={Microsoft ODBC for Oracle};UID=DOB;PWD=runtime;SERVER=PDML;")

I don't know the name of the driver you are using and syntax exactly but

What I do is hard code the driver part:
DRIVER={Microsoft ODBC for Oracle};

Then append the server,login and username (UID=DOB;PWD=runtime;SERVER=PDML;")
) from my login dialog and pass it to
SQLSTRINGCON()

To get the syntax correct make a new database container in foxpro and then use the "connections" and create a connection string. You can test the connection here and get the exact syntax.

HTH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform