Unable to read .dbf file

Hot Topic

Help! Save me from this error cursor not saved error message!!!
MSGraph.Chart.8 control
getpict() /explorer defaults
My form runs great inside of VFP, but has errors running from the exe...
Registering a Visual FoxPro driver in SQL
BLINK
newbie question
My form runs great inside of VFP, but has errors running from the exe...
editbox programmatic change
How to access VFP popup errors?

Visual FoxPro

how to send control codes via "???" to receipt printer
Delete Printer Information from Reports
Windows Service
how to change field values?
Combobox
I am facing a strage problem in VFP 8.0 with Error()
How to select data from one table which is NOT in the other table?
MSGraph.Chart.8 control
Source is out of date
How to pass a variant value to CFRONT object (Navision) ?

Unable to read .dbf file

Folks,
I'm trying to load FoxPro data into Oracle table's using Datastage ETL
Tool.i got the zip file which contains the complete Foxpro Tables.I
able to read one .dbf file out of 100 files.when i try to read other
.dbf files through ODBC stage,its throwing this error:

SQLSTATE=01000, DBMS.CODE=1295
[DataStage][SQL Client][ODBC][DataDirect][ODBC dBase driver]Table is
read-only, it is part of a database: edutrans.dbc
I try to change the file permissons from read only to full
permissions,but its not allowing.
But atleast its not allowing me to read the file.
Any ideas..


Thanks,
Hary




Answer this question

Unable to read .dbf file

  • Sharon F. Dooley

    I am telling you to connect to the DBC. The DBC will then allow you to connect to the DBFs that are associated with it.

    Dave M.



  • MrTibs

    Here i'm not connecting to foxpro db.I got the zip file which contains all .dbf and .dbc ,etc.. files.Here I'm using dbase driver to read these .dbf files.Intersting this i cab read one .dbf file out of 100 fles.Its strange for me.i try to change the permission of .dbf file and its not allowing me to do.Is their any way to chage the .dbf file permissions or is their any solution for this error.

    QLSTATE=01000, DBMS.CODE=1295
    [DataStage][SQL Client][ODBC][DataDirect][ODBC dBase driver]Table is
    read-only, it is part of a database: edutrans.dbc



  • voss

    Are you connecting the ODBC to the edutrans.dbc or to the dbf as a free table directory

    It sounds like you are using a     free table when you should be connecting to a "Visual FoxPro Database (.dbc)" ie.. edutrans.dbc.

    Check you odbc settings.

    Dave M.

  • Unable to read .dbf file
Answer this question