Problem with Progress DB while using to connect using JDBC Adapter

[Former Member]

Hi,

I am facing Problem with Progress DB while using to connect using JDBC Adapter. I am getting the following error in auditlog file like,

Error during database connection to the database URL jdbc:JdbcProgress:T:156.5.31.65:2545:/mfgprodev/devbadb

/devsche/i_apoext.db using the JDBC driver "com.progress.sql.jdbc.JdbcProgressDriver" : com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection to URL " jdbc:JdbcProgress:T:156.5.31.65:2545:/mfgprodev/devbadb

/devsche/i_apoext.db "

I tried using the following all URLs,

1. jdbc:JdbcProgress:T:156.5.31.65:2545:i_apoext.

2. jdbc:JdbcProgress:T:156.5.31.65:2545:i_apoext.db

3.

jdbc:JdbcProgress:T:156.5.31.65:2545:/mfgprodev/devbadb

/devsche/i_apoext.

4.

jdbc:JdbcProgress:T:156.5.31.65:2545:/mfgprodev/devbadb

/devsche/i_apoext.db.

Can anyone please help me out in solving this issue.

May be the cause for this is :

1) The Wrong URL format

2) CLASSPATH is not setted properly..

Can you look more into this stuff.

Thanks,

Soorya.

[GabrielSagaya]

Hi,

To access any database fromm XI, using the JDBC adapter, the corresponding drivers have to be installed on the XI server.

Just check this note 831162.

Also, check this PDF to install Drivers in XI,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

[Former Member]

Hi,

I have installed all the drivers like progress.jar for PROGRESS DB.

I want to know why i am unable to connect to progress DB with that URL and Driver Name.

Please provide correct URL format and Driver Name to use.

Thanks,

Soorya