{"id":560,"date":"2014-09-18T17:24:18","date_gmt":"2014-09-18T22:24:18","guid":{"rendered":"http:\/\/www.terrcon.com\/dynamics-gp-support\/?p=560"},"modified":"2018-01-11T17:40:48","modified_gmt":"2018-01-11T22:40:48","slug":"dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn","status":"publish","type":"post","link":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/","title":{"rendered":"Dynamics GP missing DSN – 32 bit vs 64 bit ODBC \/ DSN"},"content":{"rendered":"

If you’re reading this article, you’ve probably just installed Dynamics GP (32 bit program) on a 64 bit computer.<\/p>\n

These days most new PCs & servers use 64 bits instead of the older 32 bit standard. To maintain compatibility, a 64 bit version of Windows has both 32 bit and 64 bit versions of the ODBC drivers installed. Since Dynamic GP is a 32 bit program, it needs to use the 32 bit version of ODBC when you setup it’s DSN.<\/strong> The same is true for other 32 bit applications.<\/p>\n

If you are on a 64 bit computer and add a DSN – by default you are adding a 64 bit DSN. This won’t work with Dynamics GP since it is a 32 bit program. In fact, Dynamics GP won’t recognize a 64 bit DSN at all. If you added the DSN & see it in the list of DSNs, but Dynamics GP does not show the DSN – this article is for you.<\/p>\n

Here’s what to do:
\nOpen Windows Explorer, browse to & double-click on:
\nc:\\windows\\syswow64\\odbcad32.exe
\nThis opens up the 32 bit ODBC settings – just add the System DSN as usual.\u00a0<\/strong>
\nYou might want to make a shortcut on the desktop for future use.<\/p>\n

The lines above assume that windows is installed on the C: drive. If this is not your scenario, you can use this universal syntax to open the 32 bit ODBC settings from the command line:
\n%windir%\\syswow64\\odbcad32.exe<\/strong>
\nThis will open the 32 bit ODBC settings from a 64 bit computer. Open up a command prompt & type it in, or click on Start \/ Run & type it, or click Start & type it into the ‘search programs and files’ box. By using the %windir% variable this will always work regardless of where Windows is installed.<\/p>\n

This is a classic example of Microsoft’s Byzantine ‘logic’. We know there’s both 32 bit & 64 bit versions of the ODBC config tool, yet they are both named odbcad32.exe – it gets better. The 32 bit version is stored in the syswow64 folder while the 64 bit version is stored in the system32 folder. Simply put: This is backwards.<\/p>\n

Here’s the official Microsoft article on\u00a0How to tell if you’re running 32 bit or 64 bit Windows<\/a><\/p>\n

Definitions: ODBC = Open DataBase Connectivity \/ DSN = Data Source Name<\/p>\n

Keywords: login logon log dsn odbc missing not there gone doesn’t see<\/p>\n","protected":false},"excerpt":{"rendered":"

If you’re reading this article, you’ve probably just installed Dynamics GP (32 bit program) on a 64 bit computer. These days most new PCs & servers use 64 bits instead of the older 32 bit standard. To maintain compatibility, a 64 bit version of Windows has both 32 bit and 64 bit versions of the … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[1,17],"tags":[18,19],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-dynamicsgphelp","category-dynamics-gp-tech-tips","tag-gp-tech-tips","tag-sql-tech-tip"],"yoast_head":"\nDynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN\" \/>\n<meta property=\"og:description\" content=\"If you’re reading this article, you’ve probably just installed Dynamics GP (32 bit program) on a 64 bit computer. These days most new PCs & servers use 64 bits instead of the older 32 bit standard. To maintain compatibility, a 64 bit version of Windows has both 32 bit and 64 bit versions of the ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamics GP Support Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-18T22:24:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-11T22:40:48+00:00\" \/>\n<meta name=\"author\" content=\"Terrapin Consulting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Terrapin Consulting\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/\",\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/\",\"name\":\"Dynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN\",\"isPartOf\":{\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website\"},\"datePublished\":\"2014-09-18T22:24:18+00:00\",\"dateModified\":\"2018-01-11T22:40:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website\",\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/\",\"name\":\"Dynamics GP Support Blog\",\"description\":\"Call 888-368-6670 for Great Plains Help\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f\",\"name\":\"Terrapin Consulting\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g\",\"caption\":\"Terrapin Consulting\"},\"sameAs\":[\"http:\/\/www.terrcon.com\"],\"url\":\"https:\/\/www.terrcon.com\/dynamics-gp-support\/author\/Randy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN","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:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/","og_locale":"en_US","og_type":"article","og_title":"Dynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN","og_description":"If you’re reading this article, you’ve probably just installed Dynamics GP (32 bit program) on a 64 bit computer. These days most new PCs & servers use 64 bits instead of the older 32 bit standard. To maintain compatibility, a 64 bit version of Windows has both 32 bit and 64 bit versions of the ... Read more","og_url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/","og_site_name":"Dynamics GP Support Blog","article_published_time":"2014-09-18T22:24:18+00:00","article_modified_time":"2018-01-11T22:40:48+00:00","author":"Terrapin Consulting","twitter_misc":{"Written by":"Terrapin Consulting","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/","url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/","name":"Dynamics GP missing DSN - 32 bit vs 64 bit ODBC \/ DSN","isPartOf":{"@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website"},"datePublished":"2014-09-18T22:24:18+00:00","dateModified":"2018-01-11T22:40:48+00:00","author":{"@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.terrcon.com\/dynamics-gp-support\/2014\/09\/dynamics-gp-missing-dsn-32-bit-vs-64-bit-odbc-dsn\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#website","url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/","name":"Dynamics GP Support Blog","description":"Call 888-368-6670 for Great Plains Help","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.terrcon.com\/dynamics-gp-support\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/02c72c40ab08bc1e4ef8f30ff1e5504f","name":"Terrapin Consulting","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.terrcon.com\/dynamics-gp-support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9bda9f99c132dcddf11f9040c1c0828174e109d12fac8808d2d9ba8636806d5e?s=96&d=mm&r=g","caption":"Terrapin Consulting"},"sameAs":["http:\/\/www.terrcon.com"],"url":"https:\/\/www.terrcon.com\/dynamics-gp-support\/author\/Randy\/"}]}},"_links":{"self":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/comments?post=560"}],"version-history":[{"count":2,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":562,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/posts\/560\/revisions\/562"}],"wp:attachment":[{"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/media?parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/categories?post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.terrcon.com\/dynamics-gp-support\/wp-json\/wp\/v2\/tags?post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}