{"id":11653,"date":"2022-09-26T23:38:01","date_gmt":"2022-09-26T14:38:01","guid":{"rendered":"https:\/\/prodskill.com\/?p=11653"},"modified":"2022-10-04T23:13:19","modified_gmt":"2022-10-04T14:13:19","slug":"excel-vba-coding-pattern-32bit-provider-connection-string","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/","title":{"rendered":"Creating 32bit Provider Connection String in 64bit OS"},"content":{"rendered":"<p>Introduces how to create a 32bit Provider Connection String on a 64bit OS.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>previous post\u00a0<a href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-get-db-query-result\/#ConnectionString_%EC%83%9D%EC%84%B1_%EB%B0%A9%EB%B2%95_1_UDL_%ED%8C%8C%EC%9D%BC_%EC%9D%B4%EC%9A%A9\">VBA Coding Pattern: Importing DB Query Results to Excel_ConnectionString Creation Method 1. UDL File<\/a> I mentioned \u201cHow to display 32bit Provider in 64bit OS\u201d during usage.<\/p>\n\n\n\n<p>If you create a connection string with a UDL file on a 64-bit OS, you can basically only create it with the installed 64-bit Provider. This article explains how to display a 32bit Provider and create a Connection String in Windows 10 64bit.<\/p>\n\n\n\n<p>Proceed in the following order.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#1_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%EB%A7%8C%EB%93%A4%EA%B8%B0\" >1. Create a shortcut to oledb32.dll<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#2_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%ED%95%AD%EB%AA%A9_%EC%9C%84%EC%B9%98_%EC%9E%85%EB%A0%A5\" >2. Enter the location of the oledb32.dll shortcut entry<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#3_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%EC%9D%B4%EB%A6%84_%EC%9E%85%EB%A0%A5\" >3. Enter oledb32.dll shortcut name<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#4_UDL_%ED%8C%8C%EC%9D%BC_%EB%A7%8C%EB%93%A4%EA%B8%B0_32bit_Provider_Connection_String_%EC%A0%80%EC%9E%A5%EC%9A%A9\" >4. Create UDL file (for saving 32bit Provider Connection String)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#5_UDL_%ED%8C%8C%EC%9D%BC%EC%9D%84_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0%EC%97%90_%EB%93%9C%EB%9E%98%EA%B7%B8_%EB%93%9C%EB%9E%8D\" >5. Drag &amp; drop UDL files to the shortcut<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#6_32bit_Provider_Connection_String_%ED%99%95%EC%9D%B8\" >6. Check the 32bit Provider Connection String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/#7_%EB%8B%A4%EB%A5%B8_%EB%B0%A9%EB%B2%95_%EC%86%8C%EA%B0%9C\" >7. Introduction of other methods<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%EB%A7%8C%EB%93%A4%EA%B8%B0\"><\/span>1. Create a shortcut to oledb32.dll<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Right-click on the Windows 10 desktop and select \u201cNew &gt; Shortcut\u201d. The \u201cCreate Shortcut\u201d screen will be displayed as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194.png\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"454\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194.png\" alt=\"Windows 10 \ubc14\ub85c \uac00\uae30 \ub9cc\ub4e4\uae30\" class=\"wp-image-11654\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194.png 614w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194-300x222.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-194-48x35.png 48w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><figcaption>Create a Windows 10 Shortcut<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%ED%95%AD%EB%AA%A9_%EC%9C%84%EC%B9%98_%EC%9E%85%EB%A0%A5\"><\/span>2. Enter the location of the oledb32.dll shortcut entry<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Copy and paste the contents below to the location of the item and click the \u201cNext\u201d button.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>C:\\Windows\\SysWOW64\\rundll32.exe \u201cC:\\Program Files (x86)\\Common Files\\System\\Ole DB\\oledb32.dll\u201d, OpenDSLFile<\/p><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_oledb32dll_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0_%EC%9D%B4%EB%A6%84_%EC%9E%85%EB%A0%A5\"><\/span>3. Enter oledb32.dll shortcut name<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enter the name of the shortcut as \u201cUDL 32bit\u201d (or whatever name you want) and click the \u201cFinish\u201d button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195.png\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"454\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195.png\" alt=\"Windows 10 \ubc14\ub85c \uac00\uae30 \uc774\ub984 \uc9c0\uc815\" class=\"wp-image-11655\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195.png 614w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195-300x222.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-195-48x35.png 48w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><figcaption>Naming Windows 10 Shortcuts<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_UDL_%ED%8C%8C%EC%9D%BC_%EB%A7%8C%EB%93%A4%EA%B8%B0_32bit_Provider_Connection_String_%EC%A0%80%EC%9E%A5%EC%9A%A9\"><\/span>4. Create UDL file (for saving 32bit Provider Connection String)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Execute \u201cClick the right mouse button &gt; New &gt; Text document\u201d on the desktop and change the file name to test.udl.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_UDL_%ED%8C%8C%EC%9D%BC%EC%9D%84_%EB%B0%94%EB%A1%9C_%EA%B0%80%EA%B8%B0%EC%97%90_%EB%93%9C%EB%9E%98%EA%B7%B8_%EB%93%9C%EB%9E%8D\"><\/span>5. Drag &amp; drop UDL files to the shortcut<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Drag &amp; drop the test.udl file to the \u201cUDL 32bit\u201d shortcut icon. The screen displayed at this time is a list of 32bit Providers.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png\"><img loading=\"lazy\" decoding=\"async\" width=\"421\" height=\"531\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png\" alt=\"32bit Provider \ubaa9\ub85d\" class=\"wp-image-11656\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png 421w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196-238x300.png 238w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196-10x12.png 10w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196-19x24.png 19w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196-29x36.png 29w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196-38x48.png 38w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/a><figcaption>32bit Provider List<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_32bit_Provider_Connection_String_%ED%99%95%EC%9D%B8\"><\/span>6. Check the 32bit Provider Connection String<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After selecting a provider and setting the connection information, click the \u201cOK\u201d button to save. If you open the test.udl file with an editor such as Notepad, you can check the ConnectionString using the 32bit Provider.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_%EB%8B%A4%EB%A5%B8_%EB%B0%A9%EB%B2%95_%EC%86%8C%EA%B0%9C\"><\/span>7. Introduction of other methods<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Microsoft is introducing another method.<\/p>\n\n\n\n<p>References: <a href=\"https:\/\/learn.microsoft.com\/ko-kr\/troubleshoot\/sql\/connect\/test-oledb-connectivity-use-udl-file#test-32-bit-providers-on-64-bit-machines\" target=\"_blank\" rel=\"noreferrer noopener\">Testing SQL Server OLE DB connectivity using UDL files \u2013 SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>Excerpts from the material above.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>To test the connection of a 32-bit provider on a 64-bit operating system, follow these steps:<\/p><p>1. <strong>command prompt<\/strong>&nbsp;32 bit by running the following command in windows&nbsp;<strong>command prompt<\/strong>&nbsp;open the<br><code>%windir%\\SysWoW64\\cmd.exe<\/code><\/p><p>2. Open the UDL file by running the following command:<br><code>c:\\temp\\test.udl<\/code><\/p><p>3. <strong>producer<\/strong>&nbsp;on tap&nbsp;<strong>Microsoft Jet 4.0 OLE DB Provider<\/strong>&nbsp;is displayed, the 32-bit dialog has successfully loaded and you can now test the connection by selecting a 32-bit provider.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Introduces how to create a 32bit Provider Connection String on a 64bit OS. Previous Post VBA Coding Pattern: Importing DB Query Results to Excel_ConnectionString Creation Method 1. I mentioned \u201cHow to display 32bit Provider in 64bit OS\u201d in the contents of using UDL file. If you create a connection string with a UDL file on a 64-bit OS, you can basically only create it with the installed 64-bit Provider. Windows 10 in this article...<\/p>","protected":false},"author":1,"featured_media":11656,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[98,101,102,104,105],"class_list":["post-11653","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-connection-string","tag-provider","tag-udl","tag-32bit","tag-64bit"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c\ub2e4. oledb32.dll \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc744 \ub9cc\ub4e4\uace0, UDL \ud30c\uc77c\uc744 \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc5d0 \ub4dc\ub798\uadf8 &amp; \ub4dc\ub78d\ud558\uc5ec \uc5f0\uacb0\uc815\ubcf4\ub97c \uc124\uc815\ud558\uace0 \uc800\uc7a5\ud558\uba74 \ub41c\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c\ub2e4. oledb32.dll \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc744 \ub9cc\ub4e4\uace0, UDL \ud30c\uc77c\uc744 \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc5d0 \ub4dc\ub798\uadf8 &amp; \ub4dc\ub78d\ud558\uc5ec \uc5f0\uacb0\uc815\ubcf4\ub97c \uc124\uc815\ud558\uace0 \uc800\uc7a5\ud558\uba74 \ub41c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-26T14:38:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:13:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png\" \/>\n\t<meta property=\"og:image:width\" content=\"421\" \/>\n\t<meta property=\"og:image:height\" content=\"531\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30\",\"datePublished\":\"2022-09-26T14:38:01+00:00\",\"dateModified\":\"2022-10-04T14:13:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/\"},\"wordCount\":116,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-196.png\",\"keywords\":[\"Connection String\",\"Provider\",\"UDL\",\"32bit\",\"64bit\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/\",\"name\":\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-196.png\",\"datePublished\":\"2022-09-26T14:38:01+00:00\",\"dateModified\":\"2022-10-04T14:13:19+00:00\",\"description\":\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c\ub2e4. oledb32.dll \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc744 \ub9cc\ub4e4\uace0, UDL \ud30c\uc77c\uc744 \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc5d0 \ub4dc\ub798\uadf8 & \ub4dc\ub78d\ud558\uc5ec \uc5f0\uacb0\uc815\ubcf4\ub97c \uc124\uc815\ud558\uace0 \uc800\uc7a5\ud558\uba74 \ub41c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-196.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-196.png\",\"width\":421,\"height\":531},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-32bit-provider-connection-string\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a 32-bit Provider Connection String on a 64-bit OS - Productivity Skill","description":"This article explains how to create a 32-bit Provider Connection String on a 64-bit OS. Simply create a shortcut icon for oledb32.dll, drag and drop the UDL file onto the shortcut icon, set the connection information, and save it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/","og_locale":"en_US","og_type":"article","og_title":"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 - \uc0dd\uc0b0\uc131 Skill","og_description":"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc18c\uac1c\ud55c\ub2e4. oledb32.dll \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc744 \ub9cc\ub4e4\uace0, UDL \ud30c\uc77c\uc744 \ubc14\ub85c \uac00\uae30 \uc544\uc774\ucf58\uc5d0 \ub4dc\ub798\uadf8 & \ub4dc\ub78d\ud558\uc5ec \uc5f0\uacb0\uc815\ubcf4\ub97c \uc124\uc815\ud558\uace0 \uc800\uc7a5\ud558\uba74 \ub41c\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-32bit-provider-connection-string\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-26T14:38:01+00:00","article_modified_time":"2022-10-04T14:13:19+00:00","og_image":[{"width":421,"height":531,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30","datePublished":"2022-09-26T14:38:01+00:00","dateModified":"2022-10-04T14:13:19+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/"},"wordCount":116,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png","keywords":["Connection String","Provider","UDL","32bit","64bit"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/","url":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/","name":"Creating a 32-bit Provider Connection String on a 64-bit OS - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png","datePublished":"2022-09-26T14:38:01+00:00","dateModified":"2022-10-04T14:13:19+00:00","description":"This article explains how to create a 32-bit Provider Connection String on a 64-bit OS. Simply create a shortcut icon for oledb32.dll, drag and drop the UDL file onto the shortcut icon, set the connection information, and save it.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-196.png","width":421,"height":531},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-32bit-provider-connection-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"64bit OS\uc5d0\uc11c 32bit Provider Connection String \ub9cc\ub4e4\uae30"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11653"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11653\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11656"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}