Hi All,
I am working on reading FoxPro server (.dbf) files. FoxPro server is mounted on Datastage Unix server. Then I am able to read data through ODBC connector stage. After making an entry to .ODBC.INI file.
Issue: I am able to read some of (.DBF) file and for some (.DBF) file i am getting an error :-
"ODBC_Connector_1: ODBC function "SQLPrepare" reported: SQLSTATE = 42S22: Native Error Code = 3903: Msg = [IBM(DataDirect OEM)][ODBC dBase driver]Field not found: CLIENT_NAME
ODBC function "SQLPrepare" reported: SQLSTATE = HY000: Native Error Code = 1238: Msg = [IBM(DataDirect OEM)][ODBC dBase driver]Not a valid index file: /td/mbb/Projects/MBNA/Work/DATA/client.cdx
ODBC function "SQLPrepare" reported: SQLSTATE = 01000: Native Error Code = 1295: Msg = [IBM(DataDirect OEM)][ODBC dBase driver]Table is read-only, it is part of a database: clientinformationsystem.dbc (CC_OdbcDBStatement::dbsPrepare, file CC_OdbcDBStatement.cpp, line 353)"
Window Admin confirmed that no privilege issue is at database end.
Can any one help me in suggesting what could be issue. Why i am able to read data from Some (.DBF) file and why showing error.
Thanks & Regards.
FoxPro Server file issue
Moderators: chulett, rschirm, roy
Folks,
I'm trying to read data from FoxPro table's using Datastage ETL Tool.i coppy all files from Foxpro server to different folders over Unix bod. I am able to read 7 .dbf file out of 15 files.when i try to read other 8 .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..
![Question :?:](./images/smilies/icon_question.gif)
I'm trying to read data from FoxPro table's using Datastage ETL Tool.i coppy all files from Foxpro server to different folders over Unix bod. I am able to read 7 .dbf file out of 15 files.when i try to read other 8 .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..
![Question :?:](./images/smilies/icon_question.gif)
![Question :?:](./images/smilies/icon_question.gif)
See if this helps: connect to the dbc. If it doesn't, run more searches for your error message. Worst case involve support.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
We were able to read DBF files, by copying them to our server (UNIX) and using ODBC. We did not encounter any errors like you have described. I also think you need to contact Support, assuming your organization has a Support contract, that is what it's there for, might as well use it...
Choose a job you love, and you will never have to work a day in your life. - Confucius