SQL Server creates dblink for the Oracle database and queries use

1. Create dblink for Oracle databases in SQL Server as you would for Oracle databases

Security is also defined (seemingly no need to follow the access string only need to fill in one)

Direct query error, need to change registry add option

key 1 , rename the newly added item to "OraOLEDB.Oracle" which is sql2008r2sp2 example 2. for "OraOLEDB.Oracle "This key adds a DWORD Value and changes the name to" AllowInProcess "3. Change the value of "allowinprocess" to "00000001"

Then use the query command

SELECT * FROM OPENQUERY (ZHAOBSH,'SELECT * from zwkmzd2007')

Query SQL Server Another way of writing is always a problem unclear why

SQL Server creates dblink for the Oracle database and queries using