Clever Geek Handbook

Installing driver for Squirrel sql client on linux to connect to MS sql server

I am trying to connect to MS SQL database from linux. I can connect to Microsoft SQL Server Management Studio on windows besides. I am trying to use squirrel sql client. I'm not sure which driver I need to use and how to install it.

+3


source to share


1 answer


You want to get the JDBC driver from Microsoft and add it to the Squirrel classpath.

  • Download the driver from http://www.microsoft.com/en-us/download/details.aspx?id=11774
  • Get .tar.gz to preview version 4.0 or 4.1.
  • Expand the .tar.gz file on your Linux system.
  • Open Squirrel SQL
  • Click on the Drivers tab in the upper left corner and find the entry for Microsoft MSSQL Server JDBC Driver
  • Double-click an entry to open the settings for it.
  • Click the "Additional Class Path" button
  • Click the Add button and select the sqljdbc4.jar or sqljdbc41.jar extracted above.
  • In the Class Name field, enter com.microsoft.sqlserver.jdbc.SQLServerDriver

Edit: Adding Sample JDBC URL - The JDBC URL syntax for the Microsoft driver is explained here .



General form of connection url

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
+5


source






More articles:


All Articles