| Author |
access Fropro tables
|
|
| eric wu 2005-08-02, 1:24 pm |
| I try to open tables of Visual Foxpro 6.0 with no problem except the ones
that have a Memo field
the error message is
Database Engine Error: Corrupt table/Index header.
( I guess it's because of the index file .CDX which can not be recognized by
dBase.)
Please advise ......ThankS!!
| |
| Ken Mayer [dBVIPS] 2005-08-02, 1:24 pm |
| eric wu wrote:
> I try to open tables of Visual Foxpro 6.0 with no problem except the ones
> that have a Memo field
> the error message is
> Database Engine Error: Corrupt table/Index header.
>
> ( I guess it's because of the index file .CDX which can not be recognized by
> dBase.)
>
> Please advise ......ThankS!!
Get the correct drivers. My understanding is that the drivers for the
BDE for FoxPro tables do not included Visual FoxPro ... it's everything
prior to that.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| eric wu 2005-08-02, 1:24 pm |
| I guess I've found the answer from the subject: FoxPro Database by Eric Logan
Thanks anyway.
I use some FoxPro version 6.5 files that can't be opened in dBase with the
native FoxPro 5.0 driver. I can open those files through a ODBC-BDE
connection. The memo fields work properly. A method for setting up the
connection is 1) In the ODBC Data Source Administrator, add an ODBC System
DSN with the 'Microsoft Visual FoxPro Driver'. 2) Configure it. The database
type probably should be 'Free Table directory'.(Unless you have set up a
FoxPro database : .DBC) The path is the directory path to the FoxPro dbfs.
3) Once ODBC is set up go to the BDE. The new ODBC database should
automatically be in the list of databases. Open it, assign a language
driver, and save changes. You should then be able to open the FoxPro tables
in dBase, via the BDE database.
Hope this helps
Eric Logan
"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message news:$$Nex34lFHA.1796@news-server...
> eric wu wrote:
>
> Get the correct drivers. My understanding is that the drivers for the
> BDE for FoxPro tables do not included Visual FoxPro ... it's everything
> prior to that.
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
| Eric Logan 2005-08-02, 8:25 pm |
| Hi Ken;
Where might one get drivers for the BDE for Visual FoxPro tables? Would
those drivers be the same as the ODBC drivers? I would like to be able to
open VFP 6 files directly in dBASE, but can only do it through ODBC.
Thanks
E. Logan
ones[color=darkred]
[color=darkred]
> "Ken Mayer [dBVIPS]" wrote ...
> Get the correct drivers. My understanding is that the drivers for the
> BDE for FoxPro tables do not included Visual FoxPro ... it's everything
> prior to that.
| |
| Ken Mayer [dBVIPS] 2005-08-02, 8:25 pm |
| Eric Logan wrote:
> Hi Ken;
> Where might one get drivers for the BDE for Visual FoxPro tables? Would
> those drivers be the same as the ODBC drivers? I would like to be able to
> open VFP 6 files directly in dBASE, but can only do it through ODBC.
Would need to be through ODBC. The BDE most likely doesn't have native
drivers (nor ever will) for Visual FoxPro tables.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| eric wu 2005-08-04, 9:25 am |
| I use the ODBC driver to access Foxpro tables successfully!
Thanks !!
"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:S32Puf7lFHA.1760@news-server...
> Eric Logan wrote:
>
> Would need to be through ODBC. The BDE most likely doesn't have native
> drivers (nor ever will) for Visual FoxPro tables.
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
| eric wu 2005-08-29, 8:25 pm |
| I open the FoxPro table successfuly
but it does not allow me to write data into the table that contains MEMO
field ...........
I did setup DBE open mode = READ/WRITE
"Eric Logan" <jelogan@pcweb.net> wrote in message
news:Rr3tsL6lFHA.1796@news-server...
> Hi Ken;
> Where might one get drivers for the BDE for Visual FoxPro tables? Would
> those drivers be the same as the ODBC drivers? I would like to be able to
> open VFP 6 files directly in dBASE, but can only do it through ODBC.
> Thanks
> E. Logan
>
> ones
>
>
>
>
| |
| Ken Mayer [dBVIPS] 2005-08-29, 8:25 pm |
| eric wu wrote:
> I open the FoxPro table successfuly
> but it does not allow me to write data into the table that contains MEMO
> field ...........
> I did setup DBE open mode = READ/WRITE
If I could have helped when you first asked about memos, I would have
said something. Unfortunately I can offer no suggestions but to see if
maybe there's an update to the ODBC driver.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Eric Logan 2005-08-31, 8:24 pm |
| Hi Eric;
I can write into VFP memo fields via dBase. The table was created in VFP
6.0.
The driver is Microsoft Visual FoxPro Driver (6.01.8629.01). The ODBC
connection is with a System DSN and Free Table Directory. In the BDE, the
language driver was set to 'WEurope' ANSI. Open mode = READ/WRITE. In dBase
the table structure of the memo field shows as longvarchar. In dBase browse
the memo text is visible without double-clicking the field.
E.L.
> "eric wu" wrote ...
> I open the FoxPro table successfuly
> but it does not allow me to write data into the table that contains MEMO
> field ...........
> I did setup DBE open mode = READ/WRITE
|
|
|
|