Reading Visual FoxPro DBF Data

[briansms]

Hi, I'm currently evaluating TOS for a possible TIS subscription and we do a lot of work with Visual FoxPro databases and tables, migrating data to SQL Server, Oracle, etc. I can successfully make an ODBC connection and load the schema into the Metadata DB Connections node. All of the table schemas came in, however when trying to read the data, I get nothing but errors when trying both tDBInput and tFileInputXbase. Is there a different way DBF/Xbase tables should be handled?
- Brian

OS is Windows 2000 Pro SP 4, TOS 2.4.0RC1_r13964
tDBInput Component - Using the ODBC connection in the local repository
Opening the SQL Builder from the component properties shows all of the schema and db structure, but when trying to do a simple Select * from Equip I get:
Error Executing SQL dialog Option value changed
Trying to just use a tLogRow component to output the rows during a Trace results in the following error:
Starting job EquipToAssets at 10:36 21/05/2008.
Exception in component tDBInput_1
java.sql.SQLException: Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
connecting to socket on port 5161
connected
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at mmrca.equiptoassets_0_1.EquipToAssets.tDBInput_1Process(EquipToAssets.java:1206)
at mmrca.equiptoassets_0_1.EquipToAssets.runJobInTOS(EquipToAssets.java:2815)
at mmrca.equiptoassets_0_1.EquipToAssets.main(EquipToAssets.java:2724)
disconnected
Job EquipToAssets ended at 10:36 21/05/2008.

[_AnonymousUser]

Hi folks, I can recommend trying the repair microsoft sql server error: 824 program that automatically eliminates dbf errors. It is a good solution, if you experience any difficulties with dbx files. Hope this helps

[_AnonymousUser]

For reading dbf file (dbase III/IV/V CLIPPER 5, FOXPRO 26) there is now even a java component on talend exchange tDBFInput https://community.talend.com/t5/Archive/discussion-databases-action-on-data-quot-ignore-or-replace-q...