No connection to the remote server -- Method 1: select? *?? From? Openrowset (SQLOLEDB, server192.168.0.67; u, SELECT? *? FROM? BCM2.dbo. tbAppl) -- Method 2: select? *?? From? Openrowset (SQLOLEDB, 192.168.0.67; sa; password, SELECT? *? FROM? BCM2.dbo.
No connection to the remote server -- Method 1: select? *?? From? Openrowset ('sqlodb', 'server = 192.168.0.67; uid = sa; pwd = password', 'select? *? FROM? BCM2.dbo. tbAppl ') -- Method 2: select? *?? From? Openrowset ('sqlodb', '192. 168.0.67 '; 'sa'; 'Password', 'select? *? FROM? BCM2.dbo.
Connect to a remote server
<无>
-- Method 1: select? *?? From? Openrowset ('sqlodb', 'server = 192.168.0.67; uid = sa; pwd = password', 'select? *? FROM? BCM2.dbo. tbAppl ') -- Method 2: select? *?? From? Openrowset ('sqlodb', '192. 168.0.67 '; 'sa'; 'Password', 'select? *? FROM? BCM2.dbo. tbAppl ')?