MySQL Server as Linked Server to MSSQL Server?

by Azam Hussai » Sat, 06 Dec 2003 03:40:15

You want to try using OPENQUERY(<Linked Server Name>,'<MySQL SQL Query>').
This allows passthrough access to you data and it works!

_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc

Top

1. MySQL -> Linked Server in MS SQL Server

Hi,

I'm trying to set up a MySQL database running on a Linux box as a Linked
server in MS SQL Server on a WIndows 2000 box, using MySQL ODBC Connector
3.51, and am having problems.

I can set up a linked server if both DB's (MySQL and MSSQL Server) are
running on a Windows2000 box, and I can use DTS in SQL Server to retrieve
data from the LInux MySQL Db using the ODBC Connector.

Any pointers to documentation, suggestions would be very welcome

Cheers

Mike Harknett

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc

2. Doom and gloom (was Re: DataTax will be out in Jan (U.S. version))

3. R: RE MySQL -> Linked Server in MS SQL Server

4. Using SMS Installer 2.0 to install a Printer Driver

5. MySQL-SQL Server Linked Server Problem

6. IC design/Poland

7. RE MySQL -> Linked Server in MS SQL Server

8. HELP, Watchguard Firebox and Content Types

9. MySQL as Linked server in MSSQL using myODBC.