[2k8] SQL Server 2008에 Oracle 10g 연결하기

2010. 10. 6. 11:27

/********************************************************************************************
-- Title : [2k8] SQL Server 2008에 Oracle 10g 연결하기
-- Reference : wipscorp.com 정명훈K, oracle.com
-- Key word : 연결된 서버 linked server 이기종DB 공급자 provider 오라클 연결 오라클연결
********************************************************************************************/

1. SQL Server 머신에 Oracle Client 설치(64bit, 32bit 구분)

Client(x64)
http://www.oracle.com/technetwork/database/10201winx64soft-090882.html
--> 102010_win64_x64_client.zip 선택

Client(x86)
http://www.oracle.com/technetwork/database/10201winsoft-095341.html
--> 10201_client_win32.zip 선택

2. Oracle Client 설치 후 ODAC(오라클 공급자) 설치(64bit, 32bit 구분)

ODAC(x64)
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html?msgid=3-2161760054
--> ODAC10203x64.zip 선택

ODAC(x86)
http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
--> ODAC1020221.exe 선택