Jdbc Connection

[Former Member]

Hi All,

Could you please tell me the following parameters for JDBC adapter:

Connection String:

Driver string:

for SQL database server.

Regards,

Ashish

[Former Member · Accepted solution]

>>Connection String:

com.microsoft.jdbc.sqlserver.SQLServerDriver

>>Driver string:

jdbc:microsoft:sqlserver://<DB-b_server>:<port>;DatabaseName=<dbname>

Port by default is 1433.

Regards,

Jai Shankar

[bhavesh_kantilal]

Ashish,

It depends on the drivers installed.

If you deployed the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar).

the driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL: jdbc:sqlserver://host:1433;DatabaseName=name

Regards

Bhavesh

[Former Member]

Hi ,

The JDBC drivers should be:

com.microsoft.jdbc.sqlserver.SQLServerDriver

And the connection should be:

jdbc:microsoft:sqlserver://STPROTO:1433;DatabaseName=Prot

where STPROTO is db server name and prot is db name.

Sekhar