Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odbc
Message
 
To
11/02/2006 23:13:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Odbc
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01095631
Message ID:
01095783
Views:
56
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform