Need Help on Sender Jdbc Parameter

[Former Member]

Dear Experts,

    I am having a JDBC to Idoc scenario , where SQL Server Version 2005 .

    I got IP address and Database Name

    JDBC driver is deployed in PI 7.0.

    The sql driver is installed under     Com.sap.aii.af.jmsproviderlib

                                                                    - sqljdbc.jar

                                                                    - sqljdbc4.jar

please let me know the exact DRIVER and Connection parameter in JDBC sender channel

   
  Regards,

Anirban
 
 
 
 
 
 
 
 
 
 

[baskar_gopalakrishnan2 · Accepted solution]

Search Scn threads for this... something as below...

driver name  -  com.microsoft.jdbc.sqlserver.SQLServerDriver

connection  =  jdbc:microsoft:sqlserver://Ip addresss:portnumber;databaseName=somename

[iaki_vila]

Hi Anibarn,

Check Charu Agarwal's blog  http://scn.sap.com/people/charu.agarwal/blog/2009/07/02/problems-faced-while-connecting-to-sql-serve... as well

Regards.