Re: Connection String for MS SQL

["Larenzo Alexander" <Larenzo.Alexander@xxxxxxx>]

Thanks for your help, it looks like the data perspective defaults the
correct JDBC driver class but the class location/path was blank and it
requires one. So I set it to (C:\JDBC Folder\sqljdbc.jar) one that's on
my c: drive that I previously used to copy to my IFS but not sure if
that was the correct but it attempts to connect but gives me the
message:

Connection Failed: User is not associated with a trusted SQL server
connection but I'm able to log in with this particular user id and pass
with remote desktop but not through WDSC 7 data perspective. 




-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Pete Helgren
Sent: Thursday, May 05, 2011 8:08 AM
To: Rational Developer for IBM i / Websphere Development Studio Client
forSystem i & iSeries
Subject: Re: [WDSCI-L] Connection String for MS SQL

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