Connection to MSSQL from MySQL

Question

I have a MySQL DB on Ubuntu Server. Is any possibility to establish a connection with remote MSSQL DB and use this DB in query? For example, execute in MySQL query like this:

SELECT mysql_table.field1,
       mssql_table.field2
FROM   MySQL.table_name AS mysql_table,
       MSSQL.table_name AS mssql_table
WHERE  mysql_table.id = mssql_table.id

This is wrong direction of link. Your solution describe a link MySQL in MSSQL, but I want an access to MSSQL in MySQL. Moreover this link describe actions for Windows, but I have Unix system. — user3240646, Oct 14 '14 at 12:46

score 0 · Accepted Answer · edited May 23 '17 at 12:27

0

As from the explanation here you cant use MySQL to connect to MSSQL.

You will have to use any clients.You can use FREETDS client for linux.You can also use OBDC and JDBC.

edited May 23 '17 at 12:27

Community

1
1

answered Oct 14 '14 at 12:49

Avinash Babu

6,171
3
21
26

Connection to MSSQL from MySQL

1 Answers1