|
|
[ÀϹÝ] ¿À¶óŬ¿¡¼ MS SQL Server 2000 Á¢¼Ó¹æ¹ýÀÔ´Ï´Ù. |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:5509 |
|
|
MS SQL¿¡¼ µ¥ÀÌŸ¸¦ select ÇÏ´Â ¹æ¹ýÀº
HSODBC·Î ÇÏ´Â ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù.
¿À¶óŬ¿¡¼ MS SQL Server 2000 Á¢¼Ó¹æ¹ýÀÔ´Ï´Ù.
1. mdacÀÌ ¼³Ä¡µÇ¾î ÀÖÁö ¾ÊÀ¸¸é ¼³Ä¡ÇÕ´Ï´Ù. Win2000ÀÌ»óÀÌ¸é º° »ó°ü¾ø½À´Ï´Ù.
2. oracle ¼³Ä¡ ¿Ï·á ( µðºñ »ý¼ºÈÄ ) system user, sys user
3. sqlplus system À¯Á® Á¢¼ÓÈÄ C:\oracle\ora920\rdbms\admin\caths.sql ½ºÅ©¸³Æ® ½ÇÇà
È®Àιæ¹ý ( desc SYS.HS_FDS_CLASS À» ½ÇÇàÇÕ´Ï´Ù. °á°ú°¡ ³ª¿À¸é ok )
4. Á¢¼ÓÇÒ ODBC Data Source ¸¦ »ý¼º MS SQL ¼³Á¤
5. C:\oracle\ora920\network\admin\tnsnames.ora ÆÄÀÏ ¾È¿¡
HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = creatorxp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = hsodbc)
)
(HS=)
)
¸¦ Ãß°¡ÇÕ´Ï´Ù. ´Ù¸¥ ¼¹ö¿¡ Á¢¼ÓÇÏ´Â ³»¿ëÀ» ³Ö´Â °Í°ú °°½À´Ï´Ù.
6. C:\oracle\ora920\network\admin\listener.ora ÆÄÀÏ ¾È¿¡
(SID_DESC =
(ORACLE_HOME = C:\oracle\ora920)
(SID_NAME = hsodbc)
(PROGRAM = hsodbc)
)
¸¦ Ãß°¡ÇÕ´Ï´Ù. ±×¸®°í
7. ¸®½º³Ê Àç±âµ¿ ÇÕ´Ï´Ù.
lsnrctl stop
lsnrctl start
8. C:\oracle\ora920\hs\admin\inithsodbc.ora ¿¡ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù.
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = ymdtd
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set =
9. sqlplus Á¢¼ÓÈÄ Database link¸¦ »ý¼ºÇÕ´Ï´Ù.
(1) localÀ϶§
create database link hsodbc using 'hsodbc';
(2) remote À϶§
- Æнº¿öµå°¡ ÀÖÀ» ¶§¸¸( Àû±Ø ±ÇÀåÇÕ´Ï´Ù. )
create database link hsodbc
connect to sa identified by sa
using 'hsodbc':
- Æнº¿öµå°¡ ¾øÀ» ¶§( ¿À¶óŬ ¹®¼¿¡´Â ÀÌ·¸°Ô ÇÏ¸é µÈ´Ù°í ÇÏ´øµ¥ °³»Ô.. Àß ¾ÈµË´Ï´Ù. ÀÌ°Ç ÀÏ´Ü º¸·ù )
create database link hsodbc
connect to sa identified by ""
using 'hsodbc':
10. Å×½ºÆ®
select * from sysfiles@hsodbc;
(¿¡·¯Ã³¸®)
¸¸¾à¿¡ ¾Æ·¡¿Í °°Àº ¿¡·¯°¡ ¹ß»ýÇÑ´Ù¸é
"ORA-02085: µ¥ÀÌÅͺ£À̽º ¸µÅ© hsodbc.WORLD°¡ hsodbc.WORLD¿¡ ¿¬°áµË´Ï´Ù."
init.oraÆÄÀÏ¿¡¼ global_names Parameter¸¦ false·Î ÇÏ°í shutdown. startup ÇØÁÖ¼¼¿ä.
ÀÌ»óÀÔ´Ï´Ù.
½Ã·ÕÀÌ
http://freeboard.wawa.to
sironge@empal.com
|
|
|
|
|
|