JDBC Driver Parametes

[Former Member]

Hi

I am working on JDBC to JDBC Test scenario, What should I give in JDBC Driver and Connection parameters in the Sender and receiver Communication Channel

Sender and Receivers are MSSQL Servers.

Thanks

PR

Edited by: PR on Sep 10, 2009 5:34 PM

Edited by: PR on Sep 10, 2009 5:35 PM

[Former Member]

Thanks

PR

[agasthuri_doss]

Hey,

>Sender and Receivers are MSSQL Servers.

Did you installed MQ driver file in PI Server & Mentioned in Provider XML file,

Cheers

Agasthuri

[Former Member]

Hi PR,

First you need to have drivers based upon the version of your sql server. Please check this link for the same:

The connection parameters should be in this format:

Also for sql server there are few issues you may run into. For these please check this url:

http://sapxitutorials.blogspot.com/2009/07/problems-faced-while-connecting-to-sql.html

Regards,

---Satish