Did you try to create a fieldtypevisualfoxpro.xml file and put "visualfoxpro" in field-type-name ?
Jacques From: "Bruno Busco" <[EMAIL PROTECTED]>
I am working on Win XP, i have the FoxPro database and have installed the Visual FoxPro odbc driver. I can access the FoxPro database from Access so i know that the odbc driver works well. Now i am trying to configure ofbiz to access the FoxPro database with the following: <datasource name="odbcfoxpro" helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" field-type-name="mysql" check-on-start="true" add-missing-on-start="true" check-indices-on-start="true" use-foreign-keys="false" use-foreign-key-indices="true" join-style="ansi-no-parenthesis" alias-view-columns="false" always-use-constraint-keyword="true"> <inline-jdbc jdbc-driver="sun.jdbc.odbc.JdbcOdbcDriver" jdbc-uri="jdbc:odbc:Arca2000Pro" jdbc-username="" jdbc-password="" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> --> </datasource> but I get a lot of 2008-03-15 15:27:57,625 (main) [ DatabaseUtil.java:1288:ERROR] Error getting column info for column. Error was:java.sql.SQLException: Column not found Can anybody please suggest a solution? Could it be becouse of the field-type-name="mysql" (but in this case how can i get a Visual FoxPro fieldtype file?) Thank you - Bruno 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:Hi, i need to make my ofbiz box retrieve products information from a legacy FoxPro database. The data should be done on a regular basis (lets say every night of once a week) so it is not just a one time data import. Googling around i have found this http://lists.ofbiz.org/pipermail/users/2005-May/007836.html Is out there any more updated how-to or documentation i could start from? Many thanks for you suggestions! Bruno
