Cannot open dbf file without dbc file

[Sunil]

Hi All,

Hope you guys can help me out. I have export of dbf files without dbc file
included. I am using vb.net to read count of records in these dbf files.
Since the .dbc file is not included, the code is failing with "Cannot open
file xxx.dbc". I am using the below connection string
"provider=VFPOLEDB.1; SourceType=dbf; data source=c:\temp\;"

Is there a way to read the files without the database file (dbc).

Thanks in advance.

Sunil

[swdev2]

Hiya Sunil -
thats not an 'export' - you just have a copy. Suggest you ask for an export,
in free table mode, of the tables in question. You can also attempt your
own repair with the dbf2002 tool - at http://www.dbf2002.com/


IF YOU are allowed to munge the data files - you can strip out the dbc
reference.
Of Course - It'd be quite easy to do that in interactive mode IN VFP, if you
have VFP.
Still got your Visual Studio 6 Enterprise Edition CD Sets floating around
somewhere?
Dig out CD 1, and install the beastie.

then - in the command window -
key in
use tablename

then a window will pop up, asking you to either locate the dbc OR to detach
the reference.
Enjoy!

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

Post by Sunil
Hi All,
Hope you guys can help me out. I have export of dbf files without dbc file
included. I am using vb.net to read count of records in these dbf files.
Since the .dbc file is not included, the code is failing with "Cannot open
file xxx.dbc". I am using the below connection string
"provider=VFPOLEDB.1; SourceType=dbf; data source=c:\temp\;"
Is there a way to read the files without the database file (dbc).
Thanks in advance.
Sunil

[Sunil]

Hi Bob,

Thanks for your reply, but it does not solve the problem. I know, I could
double click on the file and free the table. But I would be getting regular
exports of these files and cannot double click on each of these files to
free the tables. Therefore I want to know if there is any way
programmatically to free these tables from dbc. I only need to read the data
from these files and do not need the dbc. I am developing a vb.net console
application to read these files.

Thanks,

Sunil

[Paul]

check out the FREE TABLE command

Post by Sunil
Hi All,
Hope you guys can help me out. I have export of dbf files without dbc file
included. I am using vb.net to read count of records in these dbf files.
Since the .dbc file is not included, the code is failing with "Cannot open
file xxx.dbc". I am using the below connection string
"provider=VFPOLEDB.1; SourceType=dbf; data source=c:\temp\;"
Is there a way to read the files without the database file (dbc).
Thanks in advance.
Sunil