Board index » delphi » Is anybody using ADO to access FoxPro files?

Is anybody using ADO to access FoxPro files?

If so, please give some guidelines on how to setup the connection strings
and other stuff.  Thanks in advance.
--
Please respond only in the newsgroup.  I will not respond
to newsgroup messages by e-mail.
 

Re:Is anybody using ADO to access FoxPro files?


Hi,

    Here is the long way to follow to install the driver;

1- In the Window named Source of Connection select the radio button Use
Connection String
2- Click Build
3- Select the Provider Tab and select OLEDB Provider for ODBC Driver
4- Select the Connection Tab and select the radio button Use Connection
String 'again'
5- In the Windows named Select Data Source, Select the Tab named Machine
Data Source
6- Select Visual FoxPro TABLE
7- In the new Window named Configure Connection, click the radio button
Free Table Directory
8- Click Browse
9- In the new Window select the directory where your tables are
10- click Ok
11- Now you should click the button Test Connection
12- Close all the remaining windows clicking the Ok buttons

Note: The key is the point 7. All the above assume that you have MDAC 2.1
installed I never this procedure without it.

I hope this will help you

Serge Myrand
SoftDelirium Informatique

Quote
Mark Reichert wrote:
> If so, please give some guidelines on how to setup the connection strings
> and other stuff.  Thanks in advance.
> --
> Please respond only in the newsgroup.  I will not respond
> to newsgroup messages by e-mail.

Re:Is anybody using ADO to access FoxPro files?


Quote
Serge Myrand <i...@softdelirium.qc.ca> wrote in message

news:38D14D32.EC8E7F3A@softdelirium.qc.ca...

Quote
> 6- Select Visual FoxPro TABLE
> 7- In the new Window named Configure Connection, click the radio button
> Free Table Directory

> Note: The key is the point 7. All the above assume that you have MDAC 2.1
> installed I never this procedure without it.

> I hope this will help you

Only one problem: I meant plain, ordinary non-Visual FoxPro files.  The ones
with the .DBF extension.
--
Please respond only in the newsgroup.  I will not respond
to newsgroup messages by e-mail.

Re:Is anybody using ADO to access FoxPro files?


Quote

>Only one problem: I meant plain, ordinary non-Visual FoxPro files.  The ones
>with the .DBF extension.

You have to use the Visual Fox pro driver. It does work OK with the
instructions that Serge gave you. The only problem is that it is
*very* slow. Speed is somewhere between glacial and continental drift.

ibar...@ossystems.co.uk
Web: http://www.ossystems.co.uk/

Other Threads