MS SQL Server ODBC - MySQL Linked Server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MySQL Linked Server

Curtis

2006-03-16, 8:23 pm

I am trying to linka MySQL database to SQL 2005, but I am not sure what I
need to do.

I have set up a DSN using the MySQL driver. I get lost when I try and create
the linked server in SQL 2005. Can someone please outline the steps to create
the linked server. Should the MySQL driver show up as a provider in SQL 2005?

Sue Hoegemeier

2006-03-17, 3:23 am

Select the Microsoft OLE DB Provider for ODBC Drivers. Form
there, enter the DSN name for the Data source.

-Sue

On Thu, 16 Mar 2006 17:07:27 -0800, Curtis
<Curtis@discussions.microsoft.com> wrote:

>I am trying to linka MySQL database to SQL 2005, but I am not sure what I
>need to do.
>
>I have set up a DSN using the MySQL driver. I get lost when I try and create
>the linked server in SQL 2005. Can someone please outline the steps to create
>the linked server. Should the MySQL driver show up as a provider in SQL 2005?

Sponsored Links