All geek questions in one place

Can I use mysql to connect to SQL Server?

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

+2
source share
2 answers

No, you cannot use MySQL to connect to MSSQL.

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

You can also use ODBC or JDBC , but for this you will need to install the appropriate driver.

+3
source

You can try SQuirreL SQL Client. It is written in Java, so it should work on both Linux and Mac, and it can connect to a SQL server and basically to any database server with a JDBC driver.

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

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

+1
source

Source: https://habr.com/ru/post/1208790/

More articles:


All Articles