JDBC Connection Database Pilot

[Corewin]

I am new to JBuilder.
I am having trouble connecting to my db with Database Pilot and using the db object in Design View.

When I try to use the design view with a database object and enter the connection information I get this error message:
"The driver: com.progress.sql.jdbc.JdbcProgressDriver could not be loaded. This could be a problem with the driver itself, or that the driver is not found on the classpath."
I know that the classpath has been set.

classpath=c:\pro91d\java\jdbc.jar.
I have also set it as a required library.

I can connect with the java code in the Jbuilder IDE.
String DRIVER = "com.progress.sql.jdbc.JdbcProgressDriver";
String url = "jdbc:jdbcprogress:T:testaix:testd1:d1";

Any Ideas?
Thanks

 

[cahit]

I have the same problem with SQLServer and also with MySql. When I make and run the following code it seems to work. But why it doesn't work with Database pilot. Because this is important when working on EJB entity beans to congfigure it.
<code>
package firstejb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Untitled1 {

public static void main(String args[]) {
Connection con = null;

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bean",
"root", "");

if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");

} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
}

</code>

 

[timw]

Have you told JBuilder about the drivers using the Tools->Enterprise Setup->Database Drivers panel? This allows JBuilder to add them to its system classpath on start up and DBPilot will use this too, no doubt.

Tim