stephane.jacques Posted March 31, 2015 Share Posted March 31, 2015 Hi,I try to set a connection to an old Progress 9.1E Database (Stuck with this ERP).O/S : Windows 2008R2 X64Driver : DATADIRECT 4.10 32-BIT Progress SQL92Jasper Studio version : TIBCO Jaspersoft Studio-6.0.3.finalHere is how i try to do this:Create new "Database JDBC Connection" Data adapter.According to Progress KB, on the "Driver Classpath" tab I add the path to the "jdbc.jar" and "progress.jar" files.On "Database Location" tab I put this information:JDBC Driver : com.progress.sql.jdbc.JdbcProgressDriverJDBC Url : jdbc:jdbcprogress:T:serverIp:portNbr:dbName,"login","password"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. Link to comment Share on other sites More sharing options...
hozawa Posted April 1, 2015 Share Posted April 1, 2015 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 Link to comment Share on other sites More sharing options...
AnnMary.Thomas Posted April 1, 2015 Share Posted April 1, 2015 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 Link to comment Share on other sites More sharing options...
stephane.jacques Posted April 1, 2015 Author Share Posted April 1, 2015 This is not a PostGresSQL database but Progress database. Since the version 10 of this database it is called OpenEdge. Link to comment Share on other sites More sharing options...
stephane.jacques Posted April 1, 2015 Author Share Posted April 1, 2015 As I said in the point 2 of my "How to", yes I did. Link to comment Share on other sites More sharing options...
stephane.jacques Posted April 14, 2015 Author Share Posted April 14, 2015 Please? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now