Which JDBC Version?

tariq mehmood 21 Reputation points
2020-12-22T05:40:50.187+00:00

Sir I have installed JAVA 15 windows 7 64bit

50363-aa.png

I want to ask what Microsoft JDBC Driver for SQLSERVER 2014 should I download.

Please

Developer technologies Transact-SQL
0 comments No comments
{count} votes

Accepted answer
  1. MelissaMa-MSFT 24,221 Reputation points
    2020-12-22T06:32:28.227+00:00

    Hi @tariq mehmood ,

    Thank you so much for posting here in Microsoft Q&A.

    As mentioned in this article, you could download your SQL Server JDBC driver at least version 4.0.

    Then you could use its versions of

    • sqljdbc.jar for Java 5, and
    • sqljdbc4.jar for Java 6

    to access SQL Server 2014.

    Since you already have JAVA 15 installed, you could consider to download the latest version of JDBC from here.

    Best regards
    Melissa


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Hot issues November--What can I do if my transaction log is full?
    Hot issues November--How to convert Profiler trace into a SQL Server table

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. tariq mehmood 21 Reputation points
    2020-12-22T07:28:27.887+00:00

    Thanks for reply

    Sir may I ask about your following 2 lines

    sqljdbc.jar for Java 5, and

    sqljdbc4.jar for Java 6

    How to check what version i have installed Java 5 or Java 6?

    Then black image that i attached in my previous post does not show Java 5 or Java 6

    Regards


  2. tariq mehmood 21 Reputation points
    2020-12-22T09:05:27.803+00:00

    Thanks for helping

    Sir I have done as you said.
    I elaborate here

    50366-1-instllaion-folder.png

    50316-2-driver.png

    50339-3-classpath.png

    50395-4-path.png

    50405-5-connection.png

    50240-6-error-message.png

    Sir what I am doing wrong, why I am facing error message
    java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

    Please


  3. tariq mehmood 21 Reputation points
    2020-12-22T10:33:20.827+00:00

    Sir I am using sqlserver 2014 under these credentials

    50451-7-sqlserver.png

    I have done everything that is told in the link

    javalangclassnotfoundexception-com.microsoft.sqlserver.jdbc.SQLServerDriver.html

    But still failed.
    Facing same error.

    Please


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.