SQL ServerµÄÁ´½Ó·þÎñÆ÷¼¼ÊõС½á

Ò»¡¢Ê¹Óà Microsoft OLE DB Provider For ODBC Á´½ÓMySQL
°²×°MySQLµÄODBCÇý¶¯MyODBC
1¡¢ÎªMySQL½¨Á¢Ò»¸öODBCϵͳÊý¾ÝÔ´£¬ÀýÈ磺ѡÔñÊý¾Ý¿âΪtest ,Êý¾ÝÔ´Ãû³ÆΪ
myDSN
2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC sp_addlinkedserver  @server = 'MySQLTest', @srvproduct='MySQL',
@provider = 'MSDASQL', @datasrc = 'myDSN'
GO
EXEC sp_addlinkedsrvlogin 
@rmtsrvname='MySqlTest',@useself='false',@locallogin='sa',@rmtuser='mys
qlµÄÓû§Ãû',@rmtpassword='mysqlµÄÃÜÂë'
3¡¢²éѯÊý¾Ý
SELECT * from OPENQUERY (MySQLTest ,'select * from ±í' )
ÏÂÃæÕâ¸ö²»ÐУº
SELECT * from OPENQUERY (MySQLTest ,'±í' )
×¢Ò⣺²»ÄÜÖ±½ÓÓÃselect * from Á´½Ó·þÎñÆ÷Ãû.Êý¾Ý¿âÃû.Óû§Ãû.±í(»òÊÓͼ)
ËIJ¿·ÖÃû³Æ²éѯÊý¾Ý£¬¿ÉÄÜÊǸöBug.
¶þ¡¢Ê¹Óà Microsoft OLE DB Provider For ORACLE Á´½ÓORACLE
1¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
sp_addlinkedserver '±ðÃû', 'Oracle', 'MSDAORA', '·þÎñÃû'
GO
EXEC sp_addlinkedsrvlogin  @rmtsrvname='±ðÃû
',@useself='false',@locallogin='sa',@rmtuser='oracle̞
',@rmtpassword='ÃÜÂë'
2¡¢²éѯÊý¾Ý
SELECT * from ±ðÃû..Óû§Ãû.±í(ÊÓͼ)
×¢Ò⣺ËIJ¿·ÖÃû³ÆÈ«²¿Óôóд
3¡¢Ö´Ðд洢¹ý³Ì
ʹÓÃOPENQUERY:
SELECT *
from OPENQUERY(±ðÃû, 'exec Óû§Ãû.´æ´¢¹ý³ÌÃû')
Èý¡¢ÉèÖÃÁ´½Ó·þÎñÆ÷ÒÔ·ÃÎʸñʽ»¯Îı¾Îļþ
ÓÃÓÚ Jet µÄ Microsoft OLE DB Ìṩ³ÌÐò¿ÉÓÃÓÚ·ÃÎʲ¢²éѯÎı¾Îļþ¡£
ÈôÒªÖ±½Ó´´½¨·ÃÎÊÎı¾ÎļþµÄÁ´½Ó·þÎñÆ÷¶ø²»½«ÎļþÁ´½ÓΪ Access .mdb ÎļþÖÐ
µÄ±í£¬ÇëÖ´ÐÐ sp_addlinkedserver£¬ÈçÏÂÀýËùʾ¡£
Ìṩ³ÌÐòÊÇ Microsoft.Jet.OLEDB.4.0£¬Ìṩ³ÌÐò×Ö·û´®Îª"Text"¡£Êý¾ÝÔ´ÊÇ°ü
º¬Îı¾ÎļþµÄĿ¼µÄÍêÕû·¾¶Ãû³Æ¡£schema.ini Îļþ£¨ÃèÊöÎı¾ÎļþµÄ½á¹¹£©±Ø
ÐëÓë´ËÎı¾Îļþ´æÔÚÓÚÏàͬµÄĿ¼ÖС£Óйش´½¨ schema.ini ÎļþµÄ¸ü¶àÐÅÏ¢£¬
Çë²Î¼û Jet Êý¾Ý¿âÒýÇæÎĵµ¡£
--Create a linked server.
EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
    'Microsoft.Jet.OLEDB.4.0',
    'c:\data\distqry',
    NULL,
    'Text'
GO
--Set up login mappings.
EXEC sp_addlinkedsrvlogin txtsrv, FALSE, NULL, Admin, NULL
GO
--List the tables in the linked server.
EXEC sp_tables_ex txtsrv
GO
--Query one of th