Re: Connection String for MS SQL

[Buck <kc2hiz@xxxxxxxxx>]

On 5/5/2011 8:41 AM, Larenzo Alexander wrote:

> 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. 

When I downloaded the MS SQL Server JDBC driver
(http://msdn.microsoft.com/en-us/sqlserver/aa937724) I put it in a
directory by itself.  Mostly because I'm no Java guru and had no idea
what I was doing.  My class location in the Data Perspective looks like
this: C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.2\enu\sqljdbc.jar

Be sure to use a Microsoft driver that's compatible with your SQL Server
version.  I'd look at the properties for your working trusted SQL server
software and make sure to use the same driver in WDSC.
  --buck