Question Re: Jdbc driver format for MS Sql Server ? in Technology Q&A

Jdbc driver format for MS Sql Server ?

Former Member — Wed, 16 Feb 2005 20:10:05 GMT

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

Re: Jdbc driver format for MS Sql Server ?

Former Member — Wed, 16 Feb 2005 20:51:17 GMT

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

Re: Jdbc driver format for MS Sql Server ?

Former Member — Thu, 24 Aug 2006 22:39:31 GMT

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

Re: Jdbc driver format for MS Sql Server ?

henrique_pinto — Thu, 24 Aug 2006 23:20:39 GMT

For the drivers:

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

Regards,

Henrique.