How To Add a Microsoft SQL Datasource

ameshkov's picture
Contributed by:ameshkov
Created on:August 27th, 2009
Last updated on:August 28th, 2009
Comments:0 comments Add a new comment!
Posted Thu, 08/27/2009 - 19:47 by ameshkov

1. Add MS SQL JDBC file (sqljdbc.jar) to $JBOSS_HOME/server/default/lib/ and restart StarPound.

2. In StarPound Studio it should be:

Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
URL: jdbc:sqlserver://<HOST>;DatabaseName=<DB>;InstanceName=<INSTANCE>;
Class Path: <SQL SERVER PATH>\sqldbc_1.2\enu\sqldbc.jar;

3. In Management Console it should be:

URL: jdbc:sqlserver://<HOST>;DatabaseName=<DB>;InstanceName=<INSTANCE>;
JDBC Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver