cancel
Showing results for 
Search instead for 
Did you mean: 

Choosing DBF driver for JDBC adapter

Former Member
0 Kudos

Hi, all.

We need to choose drivers to deploy on J2EE server for JDBC adapter to connect to DBF files.

Can anyone give me recommendations on choosing the driver?

Have you got experience with using suggested driver in productive?

Regards,

Vadim Kalabin

Accepted Solutions (0)

Answers (1)

Answers (1)

GabrielSagaya
Active Contributor
0 Kudos

1. Find Microsoft FoxPro VFP Driver for DBF. Install it

2. It is impossible to configure this driver through ODBC config but it can be done by ..

3. Create OLEDB UDS. Make the connecting string "DRIVER=Microsoft FoxPro VFP Driver (*.dbf); Exclusive=No;SourceType=DBF;SourceDB="+ Path to the directory of file"

4. After it put any configuration data you would like, remember after pressing the button “Finish” you can not change at all anything because of error

Former Member
0 Kudos

We are on Solaris OS. We don't want use ODBC driver as 1 more step in chain from DBF to JDBC, it means we don't want to use JDBC-ODBC bridge.

We think of using direct JDBC driver. There are some products of this type in the market, but we unsure of choosing reliable one we could use in productive.