In ubuntu, we use squirrel SQL client to connect to Microsoft SQL Server.
First download:
Http://sourceforge.net/projects/squirrel-sql/
Then make sure that you have installed Java and switch to the directory where the squirrel-sql-Snapshot-20130727_2001-install.jar is located for execution:
Java-jar squirrel-sql-Snapshot-20130727_2001-install.jar
Install the SDK as prompted. You can select MSSQL or MySQL. Here, select MSSQL.
After the installation is complete, download the jar package corresponding to MSSQL:
SQL Server (jtds ):
Http://sourceforge.net/projects/jtds/files/
MySQL (MySQL connector ):
Http://dev.mysql.com/downloads/connector/j/
Oracle (JDBC ):
Http://www.oracle.com/technology/global/cn/software/tech/java/sqlj_jdbc/index.html
Then copy the jtds-1.2.5.jar, ojdbc14.jar, mysql-connector-java-5.1.5-bin.jar to the lib directory under the squirrel SQL installation directory, So squirrel SQL has the connection SQL
Server, Oracle, and MySQL capabilities.
Restart squirrel in the squirrel directory:
/Usr/local/squirrel-sql-Snapshot-20130727_2001 #
/Squirrel-sql.sh
Then add an alias in the left-side aliases:
The correct connection information is similar to the following:
Double-click the connection.
Specific reference: http://www.opensoce.com/367.html