Bookmark Topic Watch Topic
  • New Topic

Connect FoxPro DB using JDBC ODBC Bridge - new  RSS feed

Tony Caos
Posts: 2
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,

I�m Tony. I�m trying to connect to FoxPro DB using JDBC ODBC bridge. And I�ve got a trouble with it.

I created an ODBC bridge at System DSN with:
- Database Type: Free Table directory
- Driver:
- collating sequence: machine.
- Exclusive: no checked.
- Fetch data in background: checked.

And my coding is:
try {
// load driver...

// create connection...
String url = "jdbcdbc:TestDBF";
Connection con = DriverManager.getConnection(url);

// test sql prepared statement...
String sql = "SELECT count(*) as count_result FROM USERS";
PreparedStatement stmt = con.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
int count = 0;
while( {
count = rs.getInt("count_result");

catch(Exception exc) {

It run properly if I deploy as a Java Application.
But when I deployed on Web Application using WebSphere Application Server 6.0, it throws the errors:
- java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File 'users.dbf' does not exist.

Please help me to fix this trouble. I do appreciate.


Tony Caos
Jeanne Boyarsky
author & internet detective
Posts: 37181
Eclipse IDE Java VI Editor
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!