Re: Connection String for MS SQL

[Pete Helgren <pete@xxxxxxxxxx>]

Generally the JDBC driver documentation itself will have the class 
name.   Depending upon what version of the driver you are using it could 
be something like:

com.microsoft.sqlserver.jdbc.SQLServerDriver  Sometimes you can just 
look through the .jar itself to see what classes are there and then find 
a match.  I'd Google on Microsoft JDBC driver class name

Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com


On 5/5/2011 5:25 AM, Larenzo Alexander wrote:
> I'm trying to set up a connection to MS SQL in the data perspective. How
> do I go about figuring what to put in the 'Class Location' field?
>
>
> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Buck
> Sent: Tuesday, May 03, 2011 10:51 AM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: Re: [WDSCI-L] Connection String for MS SQL
>
> 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