在SQLSERVER2000的2台机器之间用触发器与存储过程完成分布式
大处理并发量大的时候必须用MSDTC
不知道mysql在windows或linux如何完成并发量大的问题???
(需要特别的com类 设置?)
在一台机器 的mysql如何去访问另外一台机器的mysql???
(sqlserver2000用连接服务器,不知道mysql是否,可以)
select * from [192.168.110.18].[vad_new].[dbo].[acn_ad] 提示错误:
Connection Start Duration Result SQL Parameters
root@localhost (mysql) 2006-11-28 11:53:28 0:00:00.562 MySQL Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'[192.168.110.18].[vad_new].[dbo].[acn_ad]\' at line 1 select * from [192.168.110.18].[vad_new].[dbo].[acn_ad]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'@192.168.110.18.vad_new.dbo.advertisement\' at line 1