Connecting to Progress 9.1 with jdbc

Glossy

New Member
Hello !!

I'm trying to connect to a Progress v9.1 database with a jdbc driver (the one furnished by Progress). I don't use ODBC. The code I use is :

forName("com.progress.sql.jdbc.JdbcProgressDriver");
Connection con = DriverManager.getConnection("jdbc:JdbcProgress:T:localhost:20931:wqxs","Administrator","darren");

I receive an error when executing the "getConnection" :

java.sql.SQLException: [JDBC Progress Driver]: No Data

What's the problem ?

Thanks in advance for helping.
 

MurrayH

Member
This sort of thing works for me:

import java.sql.* ;
import com.progress.sql.jdbc.JdbcProgressDriver ;

public class readspeed {

Connection con ;

public readspeed( String url, String uname, String pword ) throws Exception {
Class.forName ("com.progress.sql.jdbc.JdbcProgressDriver");

con = DriverManager.getConnection ( url, uname, pword ) ;
/* con.setTransactionIsolation(con.READ_COMMITTED ) ;*/
}

public static void main( String argv[] ) throws Exception{
/*String url = argv[0] ; String uname = argv[1] ; String pword = argv[2] ;
String url = "jdbc:JdbcProgress:T:localhost:13000:sports";
String uname = "sysprogress" ; String pword = "dummy" ; */

String query = argv[0];
/* System.out.println ( query);*/
readspeed r = new readspeed( "jdbc:JdbcProgress:T:192.168.1.1:9000:testDB", "uid", "" ) ;
}
}
 
Top