Error to connect Progress from Java

External Since: Mar 22, 2006 Posts: 2

Hi All,

I am a new in Progress Database. I tried to connect to Progress
database from Java.
Below is my part of code:

public void connect (){

try {
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");
con = DriverManager.getConnection
("jdbc:JdbcProgress:T:tech01:2000:AffDB");
} catch (Exception e) {
e.printStackTrace();
}
}

I got an error when try to connect. The error is below:

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

I used Eclipse as java editor and have added progress.jar and JDBC.jar
as libraries.
Is there anyone can help me?

Thanks,

Nick.

External Since: Apr 05, 2006 Posts: 2

You need to have in PATH the directory $DLC/java

JDBC needs 2 .dll files inside that directory if I remember ....