JDBC Driver & Connection string for SQL 2008

[Former Member]

Hello Friends,

JDBC Driver for SQL 2008 is deploy on XI server.

Now I want to configure sendor JDBC adaptor.

For this, I need JDBC Driver & Connection string?

From where I get JDBC Driver & Connection, which I have to be entered in Sendor JDBC adaptor comm. channel.

Regards,

Narendra Goyal

[Shabarish_Nair · Accepted solution]

you get these details from the driver info;

ex.

in case of oracle;

JDBC Driver - oracle.jdbc.OracleDriver

Connection - jdbc:oracle:thin:@<IP>:<PORT>:<SID>

[Former Member]

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

Connection:

jdbc:sqlserver://<IP of SQL Server>;user=<username of SQL Server>;password=<Password>;databaseName=<Database Name>

[franz_hiltscher]

Hi,

take a look here -> [Note 939811 - MSS: JDBC DataSources in the SAP Java Application Server|https://websmp230.sap-ag.de/sap(bD1kZSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=965908]

Detailed Information on MSDN -> [Building a Connection URL|http://msdn.microsoft.com/en-us/library/ms378428.aspx]

Kind Regards

Franz

Edited by: Franz Hiltscher on Jun 21, 2010 12:48 PM