aspose file tools*
The moose likes JDBC and the fly likes Connect FoxPro DB using JDBC ODBC Bridge - new Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Connect FoxPro DB using JDBC ODBC Bridge - new

Tony Caos
Greenhorn

Joined: Jun 28, 2006
Posts: 2
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...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

// 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(rs.next()) {
count = rs.getInt("count_result");
System.out.println(count);
}

rs.close();
stmt.close();
con.close();
}
catch(Exception exc) {
exc.printStackTrace();
}

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.

Regards,


Tony Caos
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29241
    
139

Closing accidental duplicate thread


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connect FoxPro DB using JDBC ODBC Bridge - new
 
Similar Threads
Connect FoxPro DB using JDBC ODBC Bridge
JDBC:ODBC bridge for remote access
connecting to Webtrends reporting DB using JDBC-ODBC
Need Suggestion
can I change JDBC Driver ?