Ask the Expert

Accessing tables in the MySQL database from the SQL 7 database

I have a MySQL Database and a separate SQL 7 database. I need to be able to access the tables in the MySQL database from Stored Procedures in the SQL 7 database. I have drivers so I can create a system DNS for the MySQL server if needed.

    Requires Free Membership to View

    Login

To do this, you'd need to make sure you have an OLEDB provider for MySQL. You can then set up a "linked server" in SQL Server 7. Once this is done, you can access a remote MySQL table by using multipart names eg: MySQLServerAlias.MySQLDatabaseName..MySQLTableName.

This was first published in January 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top