access visual dbase 7 from vfp

"Mark Kirchner" <markkirchner@lvcm.com> wrote:
>Anyone know of an odbc driver to access dbase 7 files from vfp? or vb? or
>even sql server? Or of any way to access dbase 7 files without visual dbase
7?
>

From a press release:

As part of this alliance, a promotional copy of the Advantage 32-bit ODBC
Driver will ship with the recently released Visual dBASE 7.5.

See URL
http://www.extendedsystems.com/ESI/Company+Info/News+-+Events/PressDetail.htm?newsID=20000315

This problem is frustrating to me because it seemed so simple on the
surface. I have a client with a POS using dbase 7 files. All they want me to
do is write a basic interface so they can update their inventory from
electronic product lists supplied by their manufacturers. My platform of
choice is VFP. I can actually odbc into the dbase files using the native
microsoft dbase odbc driver, but it is not consistent, and I cannot update
the dbase files. Sometimes the views I create will open, sometimes they
error out. But never have I been able to update one. When you try to open
the dbase 7 file directly with a use command, it just says not a table.

The advantage server sounds like I would have to recreate/import the tables
into their server format and that's not what I want to do. I could be wrong
but that what it seemed like.

I simply want to read and write dbase 7 files.

"Carl Warner" <Carl@VFUG.Org> wrote in message
news:3e1d7dfc$1@tnews.web.dev-archive.com...
>
> "Mark Kirchner" <markkirchner@lvcm.com> wrote:
> >Anyone know of an odbc driver to access dbase 7 files from vfp? or vb? or
> >even sql server? Or of any way to access dbase 7 files without visual
dbase
> >7?
> >Thanks in advance.
> >
> >
>
> I wish I knew more about the business state of how well
> dBase is doing. I never hear of it anymore, but I know
> it's still around.
>
> ==Carl
>

"Mark Kirchner" <markkirchner@lvcm.com> wrote:
>
>I simply want to read and write dbase 7 files.
>

At the dBase site, it appears that an ODBC driver ships with
dBase 7.5 and for royalty-free use. I know you are working
or trying to work against dBase 7. But, maybe the developer
using that is moving to 7.5 or knows something about whether
or not the ODBC driver shipped with version 7.

Just a thought.

==Carl
Carl Warner
VFUG Officer, http://vfug.org:8080/

dbase technical support emailed back the following:

No, we do not sell ODBC drivers and I do not know of any that will allow you
to connect to dBASE 7 files.

"Carl J. Warner" <Carl@VFUG.Org> wrote in message
news:3e1dbc9b$1@tnews.web.dev-archive.com...
>
> "Mark Kirchner" <markkirchner@lvcm.com> wrote:
> >
> >I simply want to read and write dbase 7 files.
> >
>
> At the dBase site, it appears that an ODBC driver ships with
> dBase 7.5 and for royalty-free use. I know you are working
> or trying to work against dBase 7. But, maybe the developer
> using that is moving to 7.5 or knows something about whether
> or not the ODBC driver shipped with version 7.
>
> Just a thought.
>
>
> ==Carl
> Carl Warner
> VFUG Officer, http://vfug.org:8080/
>

Mark - had the same problem recently - take a look at
www.dbf2002.com - it won't get u there directly - but it will help.

mondo regards [Bill]
"Mark Kirchner" <markkirchner@lvcm.com> wrote in message
news:3e1d14ab$1@tnews.web.dev-archive.com...
> Anyone know of an odbc driver to access dbase 7 files from vfp? or vb? or
> even sql server? Or of any way to access dbase 7 files without visual
dbase
> 7?
> Thanks in advance.
>
>

Thanks. I'll give it a try.

"William Sanders" <wsanders009.bob@ev1.net> wrote in message
news:3e1eecef$1@tnews.web.dev-archive.com...
> Mark - ah - sorry - forgot one part - download the dbfviewer 200 from
> www.dbf2002.com
>
> mondo regards [Bill]
> "Mark Kirchner" <markkirchner@lvcm.com> wrote in message
> news:3e1d14ab$1@tnews.web.dev-archive.com...
> > Anyone know of an odbc driver to access dbase 7 files from vfp? or vb?
or
> > even sql server? Or of any way to access dbase 7 files without visual
> dbase
> > 7?
> > Thanks in advance.
> >
> >
>
>