{"id":4831,"date":"2023-04-17T14:21:33","date_gmt":"2023-04-17T05:21:33","guid":{"rendered":"http:\/\/oracledba.zapto.org\/wordpress\/?p=4831"},"modified":"2023-04-17T14:21:33","modified_gmt":"2023-04-17T05:21:33","slug":"excel-%ec%97%90%ec%84%9c-odbc-%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%98%ec%97%ac-oracle-%ec%97%90-%ec%97%b0%ea%b2%b0-%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4831","title":{"rendered":"Excel \uc5d0\uc11c ODBC \ub97c \uc774\uc6a9\ud558\uc5ec Oracle \uc5d0 \uc5f0\uacb0 \ud558\uae30"},"content":{"rendered":"

Microsoft Excel \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c ODBC Data Source\ub97c \uc774\uc6a9\ud558\uc5ec Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\ubd80\ud130 Excel Sheet \ub85c \uac00\uc838\uc624\uae30 \uc704\ud55c \uc124\uc815<\/span><\/strong><\/p>\n

\uc2dc\uc791 > \ubaa8\ub4e0 \ud504\ub85c\uadf8\ub7a8 > Oracle 10g Home > \uad6c\uc131 \ubc0f \uc774\uc804 \ud234 > Microsoft ODBC \uad00\ub9ac\uc790<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c \ub9e8 \uc67c\ucabd\uc5d0 \uc704\uce58\ud55c [\uc0ac\uc6a9\uc790 DSN] \ud0ed\uc744 \uc120\ud0dd\ud558\uace0 \uc6b0\uce21\uc758 [\ucd94\uac00] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n

<\/span><\/p>\n

 <\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c \uc2a4\ud06c\ub864 \ub2e4\uc6b4\ud558\uc5ec [Oracle in OraDb10g_home2] \ud56d\ubaa9\uc744 \uc120\ud0dd\ud558\uace0 [\ub9c8\uce68]\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c Data Source Name, Description\ud56d\ubaa9\uc5d0 \uc784\uc758\ub85c \uc785\ub825\ud558\uace0 TNS Service Name\ud56d\ubaa9\uc740 \ub9ac\uc2a4\ud2b8\uc5d0\uc11c \uc120\ud0dd\ud55c\ub2e4(tnsnames.ora\ud30c\uc77c\uc5d0 \ub4f1\ub85d\ub41c \uc774\ub984\uc774 \ub098\ud0c0\ub098\uba74 \uc120\ud0dd\ud558\uba74 \ub41c\ub2e4). \uc811\uc18d\ud558\uace0\uc790 \ud558\ub294 \uc0ac\uc6a9\uc790 ID\ub97c \uc785\ub825\ud558\uace0 [Test Connection] \uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

\uc704\uc758 [TNS Service Name] \ud56d\ubaa9\uc5d0 \ub9ac\uc2a4\ud2b8\uc5d0 \ub4f1\ub85d\ub418\uc5b4 \uc788\ub294 \uc774\ub984\uc740 tnsnames.ora \ud30c\uc77c\uc5d0 \ub4f1\ub85d\ub41c \uc11c\ube44\uc2a4 \uc774\ub984\ub4e4\uc774\ub2e4. [ORCL<\/span><\/strong>] \uc774 \ub9ac\uc2a4\ud2b8\uc5d0 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 \uc774\uc720\ub294 tnsnames.ora \ud30c\uc77c\uc774 \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ub41c \uc0c1\ud0dc\uc774\uae30 \ub54c\ubb38\uc774\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\n

ORCL<\/span><\/strong>\u00a0=
\n(DESCRIPTION =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
\n(CONNECT_DATA =
\n(SERVER = DEDICATED)
\n(SERVICE_NAME = orcl)
\n)
\n)<\/p>\n

EXTPROC_CONNECTION_DATA =
\n(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
\n)
\n(CONNECT_DATA =
\n(SID = PLSExtProc)
\n)
\n)<\/p>\n<\/div>\n

\uc5f0\uacb0 \ud14c\uc2a4\ud2b8\ub97c \uc2e4\ud589\ud558\uba74 [Password] \ud56d\ubaa9\uc5d0 \uc0ac\uc6a9\uc790 \uc554\ud638\ub97c \uc785\ub825\ud558\uace0 [OK] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uacfc \uac19\uc774 \uc811\uc18d \ud14c\uc2a4\ud2b8\uc5d0\uc11c \uc131\uacf5\ud558\uba74 \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub09c\ub2e4 [\ud655\uc778]\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c [OK] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c \ubcf4\ub294 \ubc14\uc640 \uac19\uc774 \uc704\uc5d0\uc11c \uc124\uc815\ud55c \ub370\uc774\ud130\uc18c\uc2a4\uac00 [\uc0ac\uc6a9\uc790 DSN] \uc5d0 \ub4f1\ub85d\ub41c \uac83\uc744 \ud655\uc778\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\uc5d1\uc140\uc744 \uc2e4\ud589\ud558\uace0 \uc704\uc5d0\uc11c \uc124\uc815\ud55c \ub370\uc774\ud130\uc18c\uc2a4\ub97c \uc774\uc6a9\ud558\uc5ec \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud574 \ubcf8\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

[\ub370\uc774\ud130] \ud0ed\uc744 \uc120\ud0dd\ud558\uace0 \ud234\ubc14\uc5d0\uc11c [\uae30\ud0c0\uc6d0\ubcf8] \uc744 \uc120\ud0dd\ud558\uace0 [\ub370\uc774\ud130 \uc5f0\uacb0 \ub9c8\ubc95\uc0ac] \ub97c \uc120\ud0dd\ud558\uace0 [ODBC DSN] \uc744 \uc120\ud0dd\ud55c \ud6c4 [\ub2e4\uc74c] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\uc55e\uc5d0\uc11c \uc124\uc815\ud574 \ub193\uc740 \ub370\uc774\ud130\uc18c\uc2a4\uc778 [DSN_Oracle10g]\ub97c \uc120\ud0dd\ud558\uace0 [\ub2e4\uc74c] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c [Password] \ud56d\ubaa9\uc5d0 \uc0ac\uc6a9\uc790 \uc554\ud638\ub97c \uc785\ub825\ud558\uace0 [OK] \ub97c \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\uac00\uc838\uc624\uace0\uc790\ud558\ub294 \ud14c\uc774\ube14\uc744 \uc120\ud0dd\ud558\uace0 [\ub2e4\uc74c] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c [\ub9c8\uce68] \ubc84\ud2bc\uc744 \ub204\ub978\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c [\ud45c] \ub97c \uc120\ud0dd\ud558\uace0 [\ud655\uc778] \ubc84\ud2bc\uc744 \ub204\ub978\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\ub2e4\uc74c \ucc3d\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc554\ud638\ub97c \uc785\ub825\ud558\uace0 [OK] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n

<\/p>\n

\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911\uc5d0 \uac00\uc838\uc628 EMP \ud14c\uc774\ube14\uc758 \uc804\uccb4 \ub0b4\uc6a9\uc774 \uc5d1\uc140\uc2dc\ud2b8\uc5d0 \ub098\ud0c0\ub09c \uac83\uc744 \ud655\uc778\ud55c\ub2e4.
\n<\/span><\/p>\n

\"\uc0ac\uc6a9\uc790<\/div>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c ODBC Data Source\ub97c \uc774\uc6a9\ud558\uc5ec Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\ubd80\ud130 Excel Sheet \ub85c \uac00\uc838\uc624\uae30 \uc704\ud55c \uc124\uc815 \uc2dc\uc791 > \ubaa8\ub4e0 \ud504\ub85c\uadf8\ub7a8 > Oracle 10g Home > \uad6c\uc131 \ubc0f \uc774\uc804 \ud234 > Microsoft ODBC \uad00\ub9ac\uc790 \ub2e4\uc74c \ucc3d\uc5d0\uc11c \ub9e8 \uc67c\ucabd\uc5d0 \uc704\uce58\ud55c [\uc0ac\uc6a9\uc790 DSN] \ud0ed\uc744 \uc120\ud0dd\ud558\uace0 \uc6b0\uce21\uc758 [\ucd94\uac00] \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.   \ub2e4\uc74c \ucc3d\uc5d0\uc11c \uc2a4\ud06c\ub864 \ub2e4\uc6b4\ud558\uc5ec [Oracle in OraDb10g_home2] \ud56d\ubaa9\uc744 \uc120\ud0dd\ud558\uace0 […]<\/p>\n","protected":false},"author":1,"featured_media":2879,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[1437,1436,1438],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tip2.jpg?fit=400%2C400","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4831"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4831"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4831\/revisions"}],"predecessor-version":[{"id":4832,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4831\/revisions\/4832"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2879"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4831"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}