JDBC to SQL Server Connection Issues

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MelissaDelamater
    New Member
    • Oct 2006
    • 2

    JDBC to SQL Server Connection Issues

    I am trying to connect using a jdbc to sql server. Here is the error that I have been receiving:
    Database Driver not found (java.lang.Clas sNotFoundExcept ion: com.microsoft.j dbc.sqlserver.S LQServerDriver)

    I have tried these 2 URLs:
    jdbc:jtds:sqlse rver://syredi/EDI

    &

    jdbc:sqlserver://syredi/EDI

    Either of these have been working. Any Ideas? I am new to Java so please bare with me.
    Thanks
    Melissa
  • doelf
    New Member
    • Oct 2006
    • 9

    #2
    Originally posted by MelissaDelamate r
    I am trying to connect using a jdbc to sql server. Here is the error that I have been receiving:
    Database Driver not found (java.lang.Clas sNotFoundExcept ion: com.microsoft.j dbc.sqlserver.S LQServerDriver)

    I have tried these 2 URLs:
    jdbc:jtds:sqlse rver://syredi/EDI

    &

    jdbc:sqlserver://syredi/EDI

    Either of these have been working. Any Ideas? I am new to Java so please bare with me.
    Thanks
    Melissa
    I think the JDBC-Driver is not on the classpath (see error message). As long as you have no access to the com.microsoft.j dbc.sqlserver.S QLServerDriver class, the url is irrelevant.

    Comment

    • arivazhaganit
      New Member
      • Oct 2006
      • 9

      #3
      hi.....
      I think that you do not have JDBCSqlserver driver

      http://www.microsoft.c om/downloads/thankyou.aspx?f amilyId=86212d5 4-8488-481d-b46b-af29bb18e1e5&di splayLang=en


      visit this site to get jdbc-driver.... & install it...

      Comment

      • MelissaDelamater
        New Member
        • Oct 2006
        • 2

        #4
        I downloaded the driver and reset the connection and I am still getting the same error. I dont think that the driver is causing the errors. Thank you for your help though.

        Comment

        Working...