How to use:
-
JDBC
- Import JDBC
- Change authentication mode https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-2017
- Enable tcp/ip https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-2017 https://www.habaneroconsulting.com/stories/insights/2015/tcpip-is-disabled-by-default-in-microsoft-sql-server-2014
Also need to start SQL Server Browser
A lot of examples on JDBC/Swing (some using mysql) https://www.tutorialspoint.com/jdbc/jdbc-introduction.htm https://docs.oracle.com/javase/tutorial/jdbc/basics/processingsqlstatements.html https://docs.oracle.com/javase/tutorial/jdbc/basics/jdbcswing.html http://www.cs.ubc.ca/~laks/cpsc304/Swing/jdbc_swing.html
-
Java
-
MSSQL Server Enable SQL Browser Service, VSS writer
To run server you will need to open JDBC
- Java
Compiled via Eclipse, Server must be available for client to work.