Linked Server to MS SQL 2000
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?
OR
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.
Subject
Written By
Posted
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.