VFP ODBC connection

Classic Servoy
1

I am trying to create an ODBC database connection to VFP tables.

Although I set up the database Server, it has a red X against it.

The ODBC DSN name is TSM

Here are the settings:

Server Name: TSMODBC
User Name:
Password:
URL:jdbc:odbc:TSM
Driver:sun.jdbc.odbc.JdbcOdbcDriver
Catalog:
Schema:
Max Active:10
Max Idle:5
Validation Type:Exception Validation
Enabked: Ticked

Any ideas?
Cheers
David Younger

2

Are you using the JDBC to ODBC? ( Sun’s JDBC-ODBC bridge if you currently have ODBC).
Searching for JDBC drivers for visual fox pro I found: http://www.csv-jdbc.com/ and there may be others such as Easy Soft JDBC-ODBC Bridge: http://software.techrepublic.com.com/abstract.aspx?docid=208031
Hope this helps.
Tom

3

I would have thought that with all the marketing being done to the Foxpro community, there would be native VFP support out of the box.

Cheers
David