Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odbc
Message
 
À
11/02/2006 23:13:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Odbc
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01095631
Message ID:
01095783
Vues:
75
>In fact I got a not free driver. I just need to get acess through ODBC to get data from Clarion into DBFs. Can you help me? I never did a ODBC connection before. I am kinda lost here.

OK, I'll try:
CREATE DATABASE Test
OPEN DATABASE Test
SET DATABASE TO Test
CREATE CONNNECTION Clarion
Then in Connection Designer:
Select "Connection String"
Click on New Data Source
File Data Source
Choose Clarion ODBC Driver
Type a name
Finish
Then fill all neccessary info for Clarion ODBC Driver
When finishing creation of File DSN
Click on button that has 3 points as a catpion in Connection Designer
Select the DSNN you just create
and voila you have connection string.
Then you can just copy and paste this connection string and use SQLSTRINGCONNECT() with it, or you could use this connection you just created in Test DB as well.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform