{"id":4211,"date":"2012-05-27T11:30:16","date_gmt":"2012-05-27T01:30:16","guid":{"rendered":"http:\/\/mingersoft.com\/blog\/?p=4211"},"modified":"2012-05-26T21:55:31","modified_gmt":"2012-05-26T11:55:31","slug":"64-bit-windows-and-odbc-drivers","status":"publish","type":"post","link":"https:\/\/mingersoft.com\/blog\/2012\/05\/64-bit-windows-and-odbc-drivers\/","title":{"rendered":"64-Bit Windows and ODBC Drivers"},"content":{"rendered":"<p>A slightly more technical article for today but something worth mentioning.<\/p>\n<p>At work, I am attempting to get a direct connection between MS SQL Server 2008 and an Oracle database. Some might say that such connectivity would bring about the end of the world or a hole might open in the ground and swallow me up. Anyway, this is the software configuration at the moment:<\/p>\n<ul>\n<li>the server I am using runs Windows Server 2008 R2 (64-bit),<\/li>\n<li>the database software running on the server is MS\u00a0SQL Server 2008 (also 64-bit),<\/li>\n<li>the Visual Studio development tools for building SSIS packages are 32-bit),<\/li>\n<li>the Oracle Client software is also installed (32-bit and 64-bit).<\/li>\n<\/ul>\n<p>The basic principle when connecting to databases from a given machine is that 32-bit software will require a 32-bit ODBC (<a title=\"ODBC | Wikipedia\" href=\"http:\/\/en.wikipedia.org\/wiki\/ODBC\" target=\"_blank\">Open Database Connectivity<\/a>) driver or client and 64-bit software will require a 64-bit ODBC driver or client. This is quite similar to how you need 32-bit drivers for a 32-bit operating system and 64-bit drivers for a 64-bit operating system. If these things don&#8217;t line up then you won&#8217;t get the right results.<\/p>\n<p>The other thing to keep in mind that on 64-bit Windows you can create both 32-bit and 64-bit ODBCs but, if you use the &#8220;Data Sources (ODBC)&#8221; applet in &#8220;Administrative Tools&#8221; you&#8217;ll only get to configure 64-bit ODBCs. Therefore, it&#8217;s important to know how to get to the 32-bit\u00a0&#8220;Data Sources (ODBC)&#8221; applet and the 64-bit version separately:<\/p>\n<ul>\n<li>C:\\Windows\\SysWOW64\\ODBCAD32.EXE (32-bit)<\/li>\n<li>C:\\Windows\\System32\\ODBCAD32.EXE (64-bit)<\/li>\n<\/ul>\n<p>Yes, it might be contrary to what you might initially thing but the executable in <strong>System32<\/strong> is the 64-bit version while the <strong>SysWOW64<\/strong>\u00a0copy is the 32-bit version. There&#8217;s a technical reason why this is the case but I won&#8217;t go into that here.<\/p>\n<p>It&#8217;s important to have uniformly named ODBC entries for both 32-bit and 64-bit just in case you are using a hybrid deployment process such as my situation where the database server itself is 32-bit while the development software is 32-bit.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A slightly more technical article for today but something worth mentioning. At work, I am attempting to get a direct connection between MS SQL Server 2008 and an Oracle database. Some might say that such connectivity would bring about the end of the world or a hole might open in the ground and swallow me &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/mingersoft.com\/blog\/2012\/05\/64-bit-windows-and-odbc-drivers\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":4214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[152,151,155,1374,162],"tags":[401,1918,783,1353,1919,164],"class_list":["post-4211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-operating-systems-technology","category-operating-systems","category-windows-7","category-windows-8","category-windows-server-2008-r2","tag-32-bit","tag-64-bit-odbc","tag-database","tag-oracle","tag-sql-server","tag-visual-studio","item-wrap"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/mingersoft.com\/blog\/wp-content\/uploads\/2012\/05\/SQL-Server-Logo.png?fit=247%2C267&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/4211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/comments?post=4211"}],"version-history":[{"count":0,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/4211\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/media\/4214"}],"wp:attachment":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/media?parent=4211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/categories?post=4211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/tags?post=4211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}