MySQL Forums
Forum List  »  Microsoft SQL Server

Linked Server to MS SQL 2000
Posted by: Mohammad Asaf
Date: August 29, 2005 08:04AM

I am trying to set up MySQL as linked server for SQL Server 2000.
These are the steps I already have taken.
1- Installation of MyODBC 3.51 driver
2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to
'mysql' data source

Now what I need to have is a SQL commands to add it as a linked server?
What do I specify for the following fields by using Enterprise Manager
a) Provider Name
b) Data source
c) Provider string
d) Location
e) Catalog
I am using default 'root' account without any password.

exec sp_addlinkedserver
@server = 'DefaultMySQL'
, @srvproduct = 'MySQLProv'
, @provider = 'MSDASQL'
, @datasrc = 'MySQLODBC'
, @location = NULL
, @provstr = NULL
, @catalog = 'mysql'

This is the error message
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'MSDASQL' in sysservers.

Options: ReplyQuote

Written By
Linked Server to MS SQL 2000
August 29, 2005 08:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.