Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: Where to get JDBC driver for SQL Server 2000?

    I have SQL server installed on a XP box. I need to access it from other machines using Java code. Where can I download a JDBC driver?
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd suggest Microsoft's JDBC Driver, but I'm a lazy bum that way!

    -PatP

  3. #3
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thanks.
    I got the driver.
    When I connect I got this error:

    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'name'. Reason: Not associated with a trusted SQL Server connectionn.

    How to associate a user with a trusted SQL Server connectionn?
    I am using SQL server 2000 developer Edition.

    Thanks

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My guess would be that there is a problem with your login credentials (in your connect string). Check out KB #313100 for more details.

    -PatP

  5. #5
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thank Patp.
    Now I have it working.

  6. #6
    Join Date
    May 2004
    Posts
    14
    In terms of availability, Microsoft's JDBC driver and FreeTDS are free and easily downloaded. FreeTDS is quite young and buggy, however, and I've heard of performance issues with Microsoft's offering. We tried itand found it not quite to the task.

    For our apps, we use the i-net OPTA or MERLIA drivers, they're fast but a little pricey....
    http://www.inetsoftware.de/English/p...verview/ms.htm

  7. #7
    Join Date
    Sep 2003
    Posts
    364
    jTDS is another opensource JDBC type 4 driver. We're started using it several months ago and have been pleasantly surprised with the performance and results.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •