Error: No suitable driver. (8933) --JDBC 10.1B

[yls999]

The below is the info, did anyone meet?
ODBC have been ok. JDBC failed.
------------------
I do it on my windows pc . the server is solaris 9,
Both of them are 10.1B

C:\Progress\OpenEdge\bin>sqlexp -url jdbc:jdbcprogress:T:160.95.224.57:8913:dbin
ter -user pub -password pub

The error msg:

OpenEdge Release 10.1B03 as of Sat Nov 3 00:53:18 EDT 2007
Connecting user "pub" to URL "jdbc:jdbcprogress:T:160.95.224.57:8913:dbinter"...
(8920)
Error: No suitable driver. (8933)
See "C:\Progress\OpenEdge\bin\sqlexp.log" and "C:\Progress\OpenEdge\bin\SQLExplo
rer.exceptions" files for more information. (8950)
--------------------------------------------------
C:\Progress\OpenEdge\bin\SQLExplorer.exceptions files
====== Start exception logging == "C:\Progress\OpenEdge\bin\SQLExplorer.exceptions" opened == Fri Feb 29 19:40:22 GMT+08:00 2008 ======

**** 1 ****
Exception at Fri Feb 29 19:40:22 GMT+08:00 2008: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver
Stack Trace:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)

 

[Casper]

Is the CLASSPATH environment variable setup correclty?
form $DLC\bin\sql_env:

CLASSPATH=%DLC%\java\base.jar;%DLC%\java\openedge.jar;%DLC%\java\util.jar;%DLC%\java\prosp.jar;%CLASSPATH%

HTH,

Casper.

 

[yls999]

classpath & path :
-------------------------------------------------------------
C:\Progress\OpenEdge\bin>sql_env
CLASSPATH=C:\Progress\OpenEdge\java\base.jar;C:\Progress\OpenEdge\java\openedge.
jar;C:\Progress\OpenEdge\java\util.jar;C:\Progress\OpenEdge\java\prosp.jar;
PATH=C:\Progress\OpenEdge\jre\bin\client;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDO
WS\System32\Wbem;C:\Progress\OpenEdge
.
DONE setup the sql environment
.
-------------------------------------------------------------
I can find jdbc.jar after I install Progress9.1D,
However I cannot find jdbc.jar after I install OpenEdge 10.1B.

 

[Casper]

The JDBC driver now resides in $DLC/java/openedge.jar.
Further components are:
$DLC\java\util.jar
$DLC\java\base.jar
$DLC\java\pool.jar
$DLC\java\spy.jar


Casper

 

[yls999]

Thank Casper. The issue has been solved.

Just as you said, jdbc.jar(Progress 9.1D) has changed to openedge.jar(OpenEdge10.1B).

 

[mindus]

Hi
i am new to this progress database. I am also getting the same error. Can be any one of you please tell me where to define this class paths. My progress database is in remote place and i am developing application in my system. So i need to access the data from remote progress database. So i have to set classpath in remote database system or in my system?

Thanks
mindus