JDBC CC parameters for SQL Server

[Former Member]

Hi All,

Can any one let me know what would b the difference in configuration of CC for Oracle and SQL?? If its Oracle then we use Connection as jdbc:oracle:thin:@server:Port:SID and JDBC Driver : oracle.jdbc.driver.OracleDriver

What would be the Connection and Drivers if SQL DB is used?

Thanks

Rajeev

[Former Member]

Hi Rajeev,

You have to use separate drivers to connect Oracle ans SQL DB....for example, you need to install ojdbc14.jar to connect

Oracle 8i and 9i version and you need to install JDBC Driver 1.1, a Type 4 JDBC driver to connect SQL server....accordingly CC

parameters will be changed as said above..

Regds,

Pinangshuk.

[rajasekhar_reddy14]

Hi ,

There is no much difference , just below are the parameters for SQLServer

JDBCDiver : com.microsoft.sqlserver.JDBCSQLServerDriver

Connection : jdbc:sqlserver:@server:Port;DataBasenanme

just google it for confimation..

Regards,

Raj

[Former Member]

Hi,

The below JDBC parameters for SQL DB server .

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

Connection:jdbc:sqlserver://ServerName:Port;Database=XXXXXXXX;

Username:XXXXX(Ex:sa)

Pwd:XXXXXXXX

Thanks

Ravi