5

I am using mysql command line tool downloaded from http://dev.mysql.com/doc/refman/5.5/en/mysql.html - I have enabled remote connect to SQL Server but I can't connect to it using this. I am just wondering if it's because mysql client isn't compatible with SQL Server? If it's not, is there any client I can use on OS X or ubuntu?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
0xSina
  • 20,973
  • 34
  • 136
  • 253
  • A common purpose is to access mssql using mysql client without having to duel boot or have Microsoft Windows in a virtual environment... – TamusJRoyce Nov 17 '15 at 05:04

2 Answers2

4

No, you cannot use MySQL to connect to MSSQL.

You have to use clients that were specifically created to understand MSSQL protocol. One of the most popular solutions for this on Linux is FreeTDS.

Also, you can use ODBC or JDBC drivers provided by Microsoft.

mvp
  • 111,019
  • 13
  • 122
  • 148
1

You could try the SQuirreL SQL Client. It's written in Java, so it should run on both Linux and Mac, and it can connect to SQL server and basically any database server that has a JDBC driver.

http://squirrel-sql.sourceforge.net/

You may need to download the JDBC driver separately from Microsoft.

Jan
  • 2,498
  • 1
  • 15
  • 6