Re: Connection String for MS SQL

[Buck <kc2hiz@xxxxxxxxx>]

On 5/3/2011 8:53 AM, Douglas Belcher wrote:

> I have added a plugin to WDSc called Quantum DB that allows me to execute
> SQL statements against a number of different databases, i.e. DB2, Oracle, MS
> SQL, etc.  I had these setup at a previous job but have not had the need to
> do it at my current job until now.  What I needed to do was find the jar
> file containing the jdbc driver to allow for the connection to the data base
> and then provide the connection url to communicate with it.  I found the
> driver and have not yet been able to figure out the parms on the connection
> url to successfully connect.  I appreciate the site you sent me to but it
> did not quite get me the results that I needed.  I was hoping that someone
> had the plugin and the connection url so I could see where I was going wrong
> and adapt it to my environment.

Properties->Connection
  Connection URL: jdbc:sqlserver://10.1.0.1:1433;databaseName=mydatabasename

Properties->JDBC Driver
  Driver Name: Microsoft SQL Server JDBC Driver 3.0
  Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
  Driver Version: 3.0.1301.101
  Driver Path: F:\Addons\Microsoft SQL Server JDBC Driver
3.0\sqljdbc_3.0\enu\sqljdbc.jar
  Type: Microsoft SQL Server

The JDBC driver one uses must be compatible with the database one wants
to connect to.  So if one were connecting to SQL Server 2000, one would
probably not want to use a 2010 driver.  The connexion URL has to come
from the server admin or network admin.  If the server isn't in the DNS,
one needs to use the IP address.  SQL Server is typically on port 1433
but that can be altered by the SQL Server admin.

Hope this helps.
  --buck