Jan Haeussler
Newbie
Points: 2
More actions
May 9, 2006 at 3:37 pm
#68516
Hello!
Is it possible to link from a mssql-server to a mysql-table?
Steve
SSCommitted
Points: 1844
May 10, 2006 at 3:36 am
#636944
If you have an ODBC connection configured to access your mySql instance, then you could access that connection through Sql Server.
May 10, 2006 at 5:57 am
#636966
yep! I've found this syntax: sp_addlinkedserver ‘mysqlDB’, ’MySQL’, ’MSDASQL’, Null, Null, ‘Driver= {MySQL ODBC 3.51 Driver}
thx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply