MySQL Linked Server

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 creat
e
the linked server. Should the mysql driver show up as a provider in SQL 2005
?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:
[vbcol=seagreen]
>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 creat
e
>the linked server in SQL 2005. Can someone please outline the steps to crea
te
>the linked server. Should the mysql driver show up as a provider in SQL 2005?[/vbco
l]