• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

JDBC driver for SQL Server 2005

One of my users has a Mac and is trying to connect to a database on our Windows 2003 server with SQL Server 2005.  He says he needs to use a JDBC driver vs. an ODBC driver.  How can I tell if I already have a JDBC driver installed, and, if I don't have one, where and how do I install the JDBC driver.  In other words, do I just download it to a folder or do I need to download it and the run something.
Thanks, JoMar
0
JoMar
Asked:
JoMar
  • 9
  • 7
  • 2
2 Solutions
 
CEHJCommented:
You might try

http://sourceforge.net/projects/jtds/

As for knowing if you have one already, that's tricky. You might try
 
locate -r '\.jar$' | grep -i 'sql'

Open in new window

0
 
JoMarAuthor Commented:
I looked at the link to download the driver.  Do you know what folder I should put it in and how to install it?  
0
 
CEHJCommented:
With any luck there will be one jar in the zip. Doesn't matter where you put it as long as it's in your classpath
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JoMarAuthor Commented:
I'm sorry for my ignorance but I have never dealt with installing drivers.  What is a jar file, what do you do with it, and what is a classpath?  Again, sorry for my ignorance.
0
 
objectsCommented:
M$ provides a driver for accessing SQL server, you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en

0
 
objectsCommented:
after you have unpacked the download as described in the download page.
copy the files with the .jar extension to your /Library/Java/Extensions/ directory

0
 
JoMarAuthor Commented:
objects - I downloaded the file from the link you provided and put it under Program Files/Microsoft SQL 2005 JDBC Driver directory, which I created during the download.  I see the .jar file but I don't know wherre the /Library/Java/Extensions/ directory is.  Do I need to create it?  If so, what should the full path be?
Thank you
0
 
objectsCommented:
> but I don't know wherre the /Library/Java/Extensions/ directory is.
> what should the full path be?

that is the full path :)

0
 
JoMarAuthor Commented:
In that case, I assume I have to create it under C:?
0
 
objectsCommented:
you need to install it on the users mac, not on the server :)

0
 
objectsCommented:
jdbc drivers are required on the client. So sounds like you need to let your user know what I've just told you :)

0
 
JoMarAuthor Commented:
oh ok - does the whole download need to be done on the Mac instead of the server?
0
 
objectsCommented:
not necessarily, they just need the jars

0
 
JoMarAuthor Commented:
I sent the .jar file to the user and I will see if that works.  Thanks for the help and I will let you know what happens.
0
 
objectsCommented:
no worries :) they can contact me if they have any problems or questions.

0
 
JoMarAuthor Commented:
As a clarification, the user is trying to connect an application called Matlab installed on a Mac to a SQL Server 2005 database.  Do you know if he needs the JDBC driver or will an ODBC driver work.  He downloaded a driver from ActualTechnologies and can set up an ODBC connection into the database from his Mac.  Do you know if this connection will work for Matlab too?
0
 
JoMarAuthor Commented:
objects - the user called Matlab and discovered he did need the .jar file and was able to set it up using that file.  Do you know what kind of access I need to give the user in SQL Logins and under the database itself as user to allow him to access the SQL database?
Thanks
0
 
JoMarAuthor Commented:
Thank you both for your help.  I was able to set a login to the database that the user was able to use so he is now connected.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 9
  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now