Board index » delphi » accessing foxpro dbf files...

accessing foxpro dbf files...


2004-01-13 07:31:11 PM
delphi100
I'm developping an application which should access a lot of foxpro dbf
tables on a file server ...
I'm thinking of 2 ways to access data :
- advantage local server
- dbexpress with an odbc driver to foxpro
the solution has to be free of charge ! (except for the delphi entreprise
software)
any body used one of these (or may be another way) ? what would be the best
choice for performance ?
Erik
 
 

Re:accessing foxpro dbf files...

On Tue, 13 Jan 2004 12:31:11 +0100, "Flatman" <XXXX@XXXXX.COM>
writes:
Quote
I'm developping an application which should access a lot of foxpro dbf
tables on a file server ...
I'm thinking of 2 ways to access data :
- advantage local server
- dbexpress with an odbc driver to foxpro

the solution has to be free of charge ! (except for the delphi entreprise
software)

any body used one of these (or may be another way) ? what would be the best
choice for performance ?

Erik

Why dont you use Firebird (open source (improved) version of Interbase
6.0)? It is licence free and is an awesome database (stable, fast,
very low maintenance, powerful) I think it is better than SQLServer on
all those grounds. Delphi has components that connect natively
(Interbase tab) so you don't need the BDE at all. I use it all the
time and find it to be rock-solid, reliable and very fast. You can
import all the FoxPro tables easily enough.
 

Re:accessing foxpro dbf files...

Well I have to use the foxpro tables as is ... Since they will still be
running old dos/foxpro programs on them ....
Thanks anyway..
Erik
"Andrew" <XXXX@XXXXX.COM>writes
Quote
On Tue, 13 Jan 2004 12:31:11 +0100, "Flatman" <XXXX@XXXXX.COM>
writes:

>I'm developping an application which should access a lot of foxpro dbf
>tables on a file server ...
>I'm thinking of 2 ways to access data :
>- advantage local server
>- dbexpress with an odbc driver to foxpro
>
>the solution has to be free of charge ! (except for the delphi entreprise
>software)
>
>any body used one of these (or may be another way) ? what would be the
best
>choice for performance ?
>
>Erik
>
Why dont you use Firebird (open source (improved) version of Interbase
6.0)? It is licence free and is an awesome database (stable, fast,
very low maintenance, powerful) I think it is better than SQLServer on
all those grounds. Delphi has components that connect natively
(Interbase tab) so you don't need the BDE at all. I use it all the
time and find it to be rock-solid, reliable and very fast. You can
import all the FoxPro tables easily enough.
 

Re:accessing foxpro dbf files...

In article <XXXX@XXXXX.COM>,
XXXX@XXXXX.COM says...
Quote
>
Why dont you use Firebird (open source (improved) version of Interbase
6.0)? It is licence free and is an awesome database (stable, fast,
very low maintenance, powerful) I think it is better than SQLServer on
all those grounds. Delphi has components that connect natively
(Interbase tab) so you don't need the BDE at all. I use it all the
time and find it to be rock-solid, reliable and very fast. You can
import all the FoxPro tables easily enough.
I installed Firebird and now need some information about how to use it
with Delphi and the Interbase components. Suggestions about where to
look/what to read, or even sample code, much appreciated.
Bill Meakin.