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'
>> Stay informed about: mysql linked server