Bruno,
As an alternative to using the FoxPro ODBC driver, you can use a
database that supports the FoxPro DBF format:
http://www.sybase.com/products/databasemanagement/advantagedatabaseserver
-Adrian
Bruno Busco wrote:
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
