sql server connect: Is it possible to make linked server from SQL Server 2000 to MySQL -- sql server connect

Is it possible to make linked server from SQL Server 2000 to MySQL

Chen
6/5/2006 12:29:02 PM

sql server connect:

Hi All,
I need transfer data from MySQL to SQL Server 2000. Does anyone know how to
make a linked server from SQL Server 2000 (SP3 or SP4) to MySQL? If it's
possible, I need install MySQL client software in my SQL Server box. Am I
right? What kind procedures I need follow?
Regards!
-Chen

Re: Is it possible to make linked server from SQL Server 2000 to MySQL

Helmut Woess
6/6/2006 12:00:00 AM

Am Mon, 5 Jun 2006 12:29:02 -0700 schrieb Chen:

[quoted text, click to view]

http://forums.devx.com/showthread.php?t=18963

Re: Is it possible to make linked server from SQL Server 2000 to MySQL

Sue Hoegemeier
6/6/2006 9:50:46 AM

Install the MySQL drivers on the SQL Server box. You can
download them from:
http://dev.mysql.com/downloads/
The follow the steps you can find in books online under
sp_addlinkedserver.

-Sue

On Mon, 5 Jun 2006 12:29:02 -0700, Chen
[quoted text, click to view]

Re: Is it possible to make linked server from SQL Server 2000 to M

Chen
6/9/2006 11:24:02 AM

Hi Sue,

Thank you very much. It worked fine; but what if our SQL Server 2000 upgrade
to SQL Server 2005 (with 64 bits). It will happy soon. I down loaded the
mysql-connector-odbc-3.51.12-win32 from mysql.com. Do you know they also have
mysql odbc drive suitable for windows 64 bits?

Thanks again.
-Chen

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.