FoxPro Server file issue
Posted: Mon May 25, 2015 8:10 am
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.
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.