JDBC Driver for Progress Database

[Former Member]

Hi experts,

We need to connect our SAP PI 7.0 which is running on Windows 2003 Server x64 bit Standard/Enterprise Edition SP1 to a progress database 9.1D version on Unix. The problems are

1. What JDBC driver should I use?

2. We tried to copy progress JDBC driver jar files from the progress database installation directory into my windows machine and tried to run it, it fails to run. It gives the following error

Error during database connection to the database URL 'jdbc:JdbcProgress:T:156.5.31.65:inodbc2' 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:inodbc2''

3. Does anyone know what connection architecture should I use to run under such environment?

Thanks

Charu

[former_member556603]

Hi,

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar

Reward Points If it is Useful..

[Former Member]

Hi Satya,

My requirement is to connect to Progress Database and not SQL server.

Kind Regards,

Charu

[GabrielSagaya]

The URL for 9.1D or E is

jdbc:jdbcprogress:T:156.5.31.65:2501:inodbc2

driver class is com.progress.sql.jdbc.JdbcProgressDriver

be sure to add these to your class path jdbc.jar, messages.jar, progress.jar in your Visual Admin

please add the port no in url

/thread/5254890 [original link is broken]

http://www.progresstalk.com/archive/index.php?t-73684.html

[Former Member]

Hi Selvam,

Many Thanks and sorry for responding back so late. It took a long time to get messages.jar file. We added all the files you suggested and also checked the URL and driver.

But we still get the same problem. We are able to connect to the progress database using a standalone java system. but not through PI.

Have you ever connected to progress database through PI? I am not sure if PI supports progress database.

Kind Regards,

Charu

[Former Member]

Hi,

This may help you

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

Regards

Seshagiri