Problem with Progress DB at sender side

[Former Member]

Hello,

We are facing some problem when we are trying to connect to Progress DB using JDBC adapter at sender side.

The error is,

" Accessing database connection 'jdbc:jdbcprogress:T:156.5.31.65:2545:/mfgprodev/devbadb/devsche/i_apoext' failed: 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' "

We have checked all the possibilities like,

In Visual Admin we checked all the services like,

ClassLoader Viewer , JDBC Connector , Log Configurator etc for all the required libraries...

They all are present. basically for Progress DB the required jars are like,

messages.jar , progress.jar, jdbc.jar.

All of them are present in the all the services in side Visual Admin.

I even checked in the JDBC connector by running the query on the Progress DB. It was working properly.

So now i left with no options to check the options. Cna you please help me in solving this issue as we are running out of time.

Thanks,

Soorya

[Former Member]

Hi surya venkat,

It seems you are not installed Progress DB Driver properly into XI server.

correct your Driver URL like this.

jdbc:oracle:thin:@<hostname>:<port>:<SID>

// @machineName:port:SID

To download drivers for Oracle DB,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

If you want to install Oracle 9i,. OJDBC14.jar should be used. 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...

Regards,

Ramesh.

[Former Member]

Hello Ramesh,

I am not using Oracle but im using Progress DB.. i Will give the URL and driver name,

Driver : com.progress.sql.jdbc.JdbcProgressDriver

URL : jdbc:jdbcprogress:T:156.5.31.65:2545:/mfgprodev/devbadb/devsche/i_apoext

So please check for Progress DB but not for oracle

Thanks ,

Soorya