Jasper Studio problem create JDBC connection (Progress 9.1E).

[stephane.jacques]

Hi,

I try to set a connection to an old Progress 9.1E Database (Stuck with this ERP).

• O/S : Windows 2008R2 X64
• Driver : DATADIRECT 4.10 32-BIT Progress SQL92
• Jasper Studio version : TIBCO Jaspersoft Studio-6.0.3.final

Here is how i try to do this:

1. Create new "Database JDBC Connection" Data adapter.
2. According to Progress KB, on the "Driver Classpath" tab I add the path to the "jdbc.jar" and "progress.jar" files.
3. On "Database Location" tab I put this information:
   1. JDBC Driver : com.progress.sql.jdbc.JdbcProgressDriver
   2. JDBC Url : jdbc:jdbcprogress:T:serverIp:portNbr:dbName,"login","password"
4. Then I click the "Test" button.

Here the error:

jdbc:jdbcprogress:T:serverIp:portNbr:dbName,"login","password"	at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:129)	at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)	at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:157)	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)Caused by: java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:serverIp:portNbr:dbName,"login","password"[/code]

Can you help resolve this? I'll have to set this connection too on the server later.

[hozawa]

This doesn't look proper.

 jdbc:jdbcprogress:T:serverIp:portNbr:dbName,"login","password"

Check the following page.

https://jdbc.postgresql.org/documentation/80/connect.html

 

[AnnMary.Thomas]

Did you add the ojdbc  jar to the DRIVER class path. In the dialog where you define the connection settings there you should find a tab to set the driver class path. Add the ojdbc jar there. This should solve your problem

[stephane.jacques]

This is not a PostGresSQL database but Progress database. Since the version 10 of this database it is called OpenEdge.

[stephane.jacques]

As I said in the point 2 of my "How to", yes I did.

[stephane.jacques]

Please?