{"id":1415,"date":"2004-06-02T12:01:13","date_gmt":"2004-06-02T12:01:13","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1415"},"modified":"2004-06-02T12:01:13","modified_gmt":"2004-06-02T12:01:13","slug":"%eb%a7%81%ed%81%ac%eb%93%9c%ec%84%9c%eb%b2%84-%ec%82%ac%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1415","title":{"rendered":"\ub9c1\ud06c\ub4dc\uc11c\ubc84 \uc0ac\uc6a9\ud558\uae30"},"content":{"rendered":"

\uc608\uc804\uc5d0 openrowset \ud568\uc218\ub97c \uc774\uc6a9\ud55c \ubd84\uc0b0\ud658\uacbd\uc5d0\uc11c\uc758 \ucffc\ub9ac\ub97c \uc598\uae30\ud588\uc5c8\ub294\ub370.
\n\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc774\uc6a9\ud558\uba74 \uc880\ub354 \uac04\ub2e8\ud558\uac8c \ucffc\ub9ac\ubb38\uc744 \uc4f8\uc218\uc788\ub2e4.<\/p>\n

\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 EM(\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uba54\ub2c8\uc800)\uc758 security\uc758 linkedserver\uc5d0\uc11c \uc0c8\ub85c\uc6b4 \uc11c\ubc84\ub97c \ub4f1\ub85d\ud574\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n

\ubb3c\ub860 \uba3c\uc800 dsn\uc73c\ub85c \ub4f1\ub85d\ub418\uc5b4\uc788\uace0..
\n\uac19\uc740 \uc791\uc5c5\uadf8\ub8f9\uc758 \uc11c\ubc84\ub77c\uba74 \uc11c\ubc84\uc774\ub984\uacfc sql\ub85c\uadf8\uc778\uc544\uc774\ub514, \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc54c\uba74\ub41c\ub2e4.
\n\uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74.
\n\uc0c8\ub85c\uc740 \ub9c1\ud06c\ub4dc\uc11c\ubc84 \ucd94\uac00\ud55c\ud6c4
\ngeneral\ud0ed\uc5d0\uc11c other data source\uc5d0\uc11c olddb odbc\ud0c0\uc785\uc744 \uc120\ud0dd\ud558\uace0
\ndata source\uc640 provider string\uc5d0 \uc801\uc815\uac12\uc744 \ub123\uc5b4\uc8fc\uba74 \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \ub4f1\ub85d\ud560 \uc218 \uc788\ub2e4.<\/p>\n

server options\uc5d0\uc11c\ub294 data access, rpc, rpc out \uc5d0 \uccb4\ud06c\ud574\uc8fc\uc790.
\nrpc \ub294 \uac04\ub2e8\ud788 \ub9ac\ubaa8\ud2b8 \ud504\ub85c\uc2dc\uc800\ub97c \ucf5c\ud55c\ub2e4 \ubaa8 \uadf8\ub7f0 \ub73b\uc774\ub2e4 ^^<\/p>\n

\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \ub4f1\ub85d\ud558\uace0 \ub098\uba74 \uac04\ub2e8\ud558\uac8c \ubd84\uc0b0\uc9c8\uc758\uac00 \uac00\ub2a5\ud574\uc9c4\ub2e4.
\n\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c hantoma_pubs\ub77c\uace0 \ud588\uc744\ub54c<\/p>\n

select * from hantoma_pubs.pubs.dbo.sales<\/p>\n

\uc5b4\ub5a4\uac00 \uac04\ub2e8\ud558\uc9c0 \uc54a\uc740\uac00..?<\/p>\n

\ub610\ud55c openquery\ub77c\ub294 \ud568\uc218\ub97c \uc774\uc6a9\ud558\uba74 \ub9ac\ubaa8\ud2b8\uc11c\ubc84\uc5d0\uc11c \ubaa8\ub4e0\ucc98\ub9ac\ub97c \ud55c\ud6c4
\n\ub85c\uceec\uc5d0 \uac12\ub9cc \ubc1b\uc544\uc624\uac8c \ud560\uc218\ub3c4 \uc788\ub2e4.<\/p>\n

select * from openquery(hantoma_pubs,’select * from pubs.dbo.sales’)<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc608\uc804\uc5d0 openrowset \ud568\uc218\ub97c \uc774\uc6a9\ud55c \ubd84\uc0b0\ud658\uacbd\uc5d0\uc11c\uc758 \ucffc\ub9ac\ub97c \uc598\uae30\ud588\uc5c8\ub294\ub370. \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc774\uc6a9\ud558\uba74 \uc880\ub354 \uac04\ub2e8\ud558\uac8c \ucffc\ub9ac\ubb38\uc744 \uc4f8\uc218\uc788\ub2e4. \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 EM(\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uba54\ub2c8\uc800)\uc758 security\uc758 linkedserver\uc5d0\uc11c \uc0c8\ub85c\uc6b4 \uc11c\ubc84\ub97c \ub4f1\ub85d\ud574\uc8fc\uba74 \ub41c\ub2e4. \ubb3c\ub860 \uba3c\uc800 dsn\uc73c\ub85c \ub4f1\ub85d\ub418\uc5b4\uc788\uace0.. \uac19\uc740 \uc791\uc5c5\uadf8\ub8f9\uc758 \uc11c\ubc84\ub77c\uba74 \uc11c\ubc84\uc774\ub984\uacfc sql\ub85c\uadf8\uc778\uc544\uc774\ub514, \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc54c\uba74\ub41c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74. \uc0c8\ub85c\uc740 \ub9c1\ud06c\ub4dc\uc11c\ubc84 \ucd94\uac00\ud55c\ud6c4 general\ud0ed\uc5d0\uc11c other data source\uc5d0\uc11c olddb odbc\ud0c0\uc785\uc744 \uc120\ud0dd\ud558\uace0 data source\uc640 provider string\uc5d0 \uc801\uc815\uac12\uc744 \ub123\uc5b4\uc8fc\uba74 \ub9c1\ud06c\ub4dc … \uacc4\uc18d \uc77d\uae30 “\ub9c1\ud06c\ub4dc\uc11c\ubc84 \uc0ac\uc6a9\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1415","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1415"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}