Re: Connection String for MS SQL

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