May 28, 2003 at 12:13 pm
I'm trying to connect to MySQL to move some data from SQL2000 to MySQL. I need to do this nightly so a wanted to write a script to execute every night. I setup a linked server (portal), and I can click on tables and see all the tables on the MySQL server. My problem is accessing the server via TSQL. I've tried portal.pn.mrhodes.nuke_users, portal..nuke_users,portal.pn..nuke_users and just about every other combination I can think of. Has anyone linked to a MySQL database successfully. I'm user MySQL ODBC 3.5.1 drivers. Anything else you need or want to know, please let me know.
May 29, 2003 at 7:36 am
Use OPENQUERY. I don't believe the MyODBC driver exposes the proper interfaces for a 4-part naming convention. As an example:
SELECT *
FROM OPENQUERY(portal, 'SELECT * FROM nuke_users')
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy