Jdbc driver format for MS Sql Server ?

[Former Member]

Configuring Communication Channel- need JDBC Driver format and Connection string. Database MS Sql Server 2000, port 1433, Database name: Prototype, Server Name: STPROTO.

Can someone provide sample of what goes in the string:

Jdbc Driver:

Connection:

User Name: Testing

Password: Testing

Many thanks

[Former Member · Accepted solution]

Hi William,

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

If so,

The JDBC drivers should be:

com.microsoft.jdbc.sqlserver.SQLServerDriver

And the connection should be:

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

Best regards,

Alwin

[Former Member · Accepted solution]

Just in case anyone is in the same boat as I am....

I'm using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

com.microsoft.sqlserver.jdbc.SQLServerDriver

And the URL is slightly different as well:

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

[henrique_pinto]

For the drivers:

http://developers.sun.com/product/jdbc/drivers

Regards,

Henrique.