Has anyone successfully configured a JDBC Adapter connection to a Progress database? I have installed the Progress JDBC driver and can connect to the database, execute a select statement and close the connection using services in the WmDB package (pub.db:connect, pub.db:execSQL and pub.db:close). What I’d like to do, if it’s possible, is to set up a connection using the wM JDBC adapter package, but I’m not sure what the settings should be, especially the DataSource class. I’m using IS 6.1_SP1 with the JDBC Adapter 6.0.3. The Progress database is version 9.1E. Thanks,

Tim

I got it! I peeked at the classes in the jar file and found com.progress.sql.jdbcx.datasource.JdbcProgressDataSource and it worked. Thanks,

Tim

When you move up to Progress 10, you need to use class “com.ddtek.jdbcx.openedge.OpenEdgeDataSource” with the JDBC adapter. Works

Chris

Hi Tim,

Can you please advise what all jars files have you loaded to make it work with Progress 9.
I am using the same driver but the below error persist.

zzTest.jdbcConn:ProgressConn: after 1 attempt(s). null

Hi Sunkari,
jdbc.jar or openedge.jar can be used to connect to Progress database… I haven’t worked on this. Below link has some information that might be useful for you…

[URL]http://www.progresstalk.com/showthread.php?109511-JDBC-Connection[/URL]

HTH
Senthil

Hi Senthil,

Thanks for the information.
I am using the above jar and able to connect via wMDB adapter but using JDBC adapter which i am having issue.
I used
com.progress.sql.jdbcx.datasource.JdbcProgressDataSource driver
still not able to connect.

Regards,
Srini.

Hi Srini,
Were you able to find that class file when you extract the jdbc jar in the same path ?

If you can find, keep the file under IntegrationServer/lib/jars and restart the server once…

If you cannot find, then you will have to look for a different class file that can be used to connect…

Regards
Senthil

Hi Senthil,

I can find the classes in jdbc.jar and i already did the same as mentioned by you,still it doesnt work.

Regards,
Srini.