SQL Server Performance Forum – Threads Archive

Linking a Server

MSSQL 2000 sp3a — to a remote–> mysql 4.0.20-standard The ports are open and a DSN has been created between the two using the native mysql drivers, I’ve tried the following without success: (usually when I click ‘tables’ under the linked server name, Ent. manager becomes non-responsive:
sp_addlinkedserver ‘mysqlDB1’, ‘MySQLDBNAME’, ‘MSDASQL’, NULL, NULL, ‘DSN_dev_mysql’ sp_addlinkedserver ‘mysqlDB3’, ‘MySQL’, ‘MSDASQL’, Null, Null, ‘Driver={MySQL ODBC 3.51 Driver}’ sp_addlinkedserver @server = ‘192.168.2.100’
, @srvproduct = ‘MSDASQL’
, @provider = ‘MSDASQL’
, @datasrc = ‘dev_mysql’
, @location = ‘192.168.2.100’
, @provstr = ‘Driver={MySQL ODBC 3.51 Driver}’
, @catalog = ‘database_mssql’
It’s to setup replication

---

Any Log or Event Viewr error?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

No event messages, but I think I fixed it by changing ‘Driver={MySQL ODBC 3.51 Driver}’
to
‘Driver= {MySQL ODBC 3.51 Driver}’ {note the space beside the = sign}

---

Kindly do not duplicate the threads and for further discussion, followhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7257 thread. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>