>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.