跨服务器远程链接 sql

select * from OPENDATASOURCE('SQLOLEDB','DATA SOURCE=172.16.0.10;USER ID=sa;password=123456').pydemonewcrm.dbo.t_contract

 

mysql不适用，目前没有找到解决办法。。。求解中。。。

 

 

select * from
mysql_pconnect(''172.16.0.123'',''root'','''').crm2010.dbo.t_contract;

$ycdb=mysql_connect('172.16.0.123','root','')or die("远程数据库连接失败！".mysql_error());
print_r($ycdb);
   mysql_select_db('db_offsmplroom',$ycdb);
   mysql_query("set names gb2312",$ycdb);
   $loc=mysql_connect('localhost','root','')or die("本地数据库连接失败！".mysql_error());
   mysql_select_db('db_offsmplroom',$loc);
   mysql_query("set names gb2312",$loc);