sqlserver2008连接oracle11g【点击查看详情】
sqlserver2008连接oracle11g:Use sp_add link ed server procedure to create the link ed server , specifying MSDAORA as provider_name , and the SQL *Net alias name for the Oracle database instance as data_ source . sp_add link ed server @ server = 'ORASRV' , @ sr