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>][/<database>]
Thanks in advance for your help
Last edit: PAscal 2016-10-03
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Tips / How to" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
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>][/<database>]
Thanks in advance for your help
Last edit: PAscal 2016-10-03
Yes, it works using JTDS
jdbc:jtds:sqlserver://SERVERNAME:1433/DBNAME;instance=INSTNAME
Thanks for the syntax PAscal