在SqlServer下增加MySql的链接服务器

要在SqlServer上服务器上这装MySql的ODBC驱动，我下载的是mysql-connector-odbc-winx64.zip，安装后在ODBC中有了DRIVER={MySQL ODBC 5.3 ANSI Driver}（{MySQL ODBC 5.3 Unicode Driver}）

-- 查询已有的链接服务器
exec sp_linkedservers;

--删除链接服务器 
exec sp_dropserver 'MySQL_TestDB' , 'droplogins'

-- 脚本方式
EXEC sp_addlinkedserver 
    @server = 'MySQL_TestDB', 
    @srvproduct='MySQL',
    @provider = 'MSDASQL', 
    @provstr = 'Driver={MySQL ODBC 5.3 ANSI Driver};
    Server=localhost;
    Database=zkeco_db;
    User=root;
    Password=1234;
    Option=3;'
GO 
EXEC sp_addlinkedsrvlogin 
    @rmtsrvname='MySqlTest',
    @useself='false',
    @rmtuser='root',
    @rmtpassword='123456';
GO

EXEC sp_addlinkedserver  
     @server = 'MySQLTest', 
     @srvproduct='zkeco_db', 
     @provider = 'MSDASQL',
     @provstr = 'DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=127.0.0.1;DATABASE=zkeco_db;UID=root;Password=;PORT=17770;',
      @datasrc = NULL
 GO 
 EXEC sp_addlinkedsrvlogin  
     @rmtsrvname='MySqlTest',
     @useself='false',
     @locallogin='sa',
     @rmtuser='root',
     @rmtpassword='' 
     
GO 

SELECT * FROM OPENQUERY (MySQL_TestDB,'select * from userinfo')

INSERT OPENQUERY (MySQL_TestDB, 'SELECT id,parentid,level,title FROM monolithpro_cate') VALUES ('','0','0','zhangzongqi');

UPDATE OPENQUERY (MySQL_TestDB, 'SELECT parentid,level,title FROM monolithpro_cate WHERE id = 320') SET parentid = '2',LEVEL=3, title=title+'pct';

DELETE OPENQUERY (MySQL_TestDB, 'SELECT id FROM monolithpro_cate WHERE id = 316');