Menu ▾ ▴

connecting to Microsoft SQL Server

Tips / How to
Anonymous
2016-10-03
2018-09-11
  • Comment has been marked as spam. 
    Undo

    View and moderate all "Tips / How to" comments posted by this user

    Mark all as spam, and block user from posting to "Discussion"

    Anonymous

    Anonymous - 2016-10-03

    Hello,
    When trying to connect to MS SQL Server
    with file: sqljdbc42.jar
    driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
    url: jdbc:microsoft:sqlserver://host\instance:1433;DatabaseName=db

    I get error
    E:\SQLeo>java -jar SQLeoVQB.jar
    SystemLookAndFeel: com.sun.java.swing.plaf.windows.WindowsLookAndFeel
    SQLeoUsingLookAndFeel: [The Java(tm) Look and Feel - javax.swing.plaf.metal.Meta
    lLookAndFeel]
    version: 2016.08.rc1+
    Loading resources...
    Loading window...
    HTTP status: 200
    Server version:2016.08.rc1
    Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
    at com.sqleo.environment.ctrl.explorer.ViewSearchResult.getHandlerKey(ViewSearchResult.java:48)
    at com.sqleo.environment.ctrl.explorer.AbstractViewObjects.getConnection(AbstractViewObjects.java:116)
    at com.sqleo.environment.ctrl.explorer.ViewSearchResult.listTables(ViewSearchResult.java:122)
    at com.sqleo.environment.ctrl.explorer.ViewSearchResult.list(ViewSearchResult.java:88)
    at com.sqleo.environment.ctrl.explorer.SideSearchCriteria.actionPerformed(SideSearchCriteria.java:225)

    Should I use http://jtds.sourceforge.net/
    with url syntax : jdbc:jtds:sqlserver://<server>[:<port>]</port>[/<database>]</database></server>

    Thanks in advance for your help

     

    Last edit: PAscal 2016-10-03

    • PAscal

      PAscal - 2016-10-04

      Yes, it works using JTDS
      jdbc:jtds:sqlserver://SERVERNAME:1433/DBNAME;instance=INSTNAME

       

  • Anonymous

    Anonymous - 2018-09-11

    Thanks for the syntax PAscal

     

Anonymous
Anonymous

Add attachments
Cancel