{"id":259,"date":"2009-11-17T17:02:09","date_gmt":"2009-11-17T21:02:09","guid":{"rendered":"https:\/\/clarionsharp.com\/blog\/?p=259"},"modified":"2009-11-17T17:02:09","modified_gmt":"2009-11-17T21:02:09","slug":"32-bit-odbc-in-the-64-bit-operating-system","status":"publish","type":"post","link":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/","title":{"rendered":"32 bit ODBC in the 64-bit Operating System"},"content":{"rendered":"

Note: This blog was written by Robert Ricketts, who is a Senior Support Representative at SoftVelocity. If you have any questions, you can post them here or even email us at support AT softvelocity DOT com<\/p>\n

Now, on to the article! \ud83d\ude42<\/p>\n

There has been quite a bit of confusion about using the 32 ODBC Administrator and 32 Bit ODBC drivers in 64 bit Operating Systems so I thought I would put together some information to help when using 32 bit ODBC drivers, such as the TopSpeed ODBC driver.<\/p>\n

For 64 bit Operating Systems, there is a 64 bit and a 32 bit ODBC Source
\nAdministrator.\u00a0 Both actually have the same name (odbcad32.exe).<\/p>\n

You can launch the Admin applet from the command line (or a Shortcut) so you get the 32-bit version of the ODBC configuration tool. The command line is as follows:<\/p>\n

%WINDIR%SysWOW64odbcad32.exe<\/strong><\/p>\n

Microsoft stores the 32 bit odbcad32.exe in the syswow64 directory and the 64 bit odbcad32.exe in the system32 directory.<\/p>\n

N.B. If you just run odbcad32.exe, Windows will actually run the 64-bit version because the default system path has system32 ahead of syswow64.<\/p>\n

From: http:\/\/support.microsoft.com\/kb\/942976<\/a><\/p>\n

System DSNs are stored in the following registry subkey:
\nHKEY_LOCAL_MACHINESoftwareODBCODBC.INI<\/strong><\/p>\n

Registry redirection is enabled for this registry subkey. Therefore, system
\nDSNs for 32-bit drivers and for 64-bit drivers are separated. The 64-bit ODBC Administrator tool does not display the system DSNs that are created by the 32-bit ODBC Administrator tool or that use 32-bit drivers and visa versa.<\/p>\n

User DSNs are stored in the following registry subkey:
\nHKEY_CURRENT_USERSoftwareODBCODBC.INI<\/strong><\/p>\n

Registry redirection is not enabled for this registry subkey. Therefore, both
\nODBC Administrator tools display all user DSNs.<\/p>\n

Regarding the DotNet Framework<\/strong><\/p>\n

In order to use the TPS ODBC driver from .NET you will need to use the .NET Framework Provider for ODBC.<\/p>\n

If you see no reference to the .Net Framework Provider for ODBC, this is
\navailable as a free download from:<\/p>\n

http:\/\/www.microsoft.com\/downloads<\/a><\/p>\n

Search for “ODBC .Net Data Provider” to download and install the .Net Framework Provider for ODBC.<\/p>\n","protected":false},"excerpt":{"rendered":"

Note: This blog was written by Robert Ricketts, who is a Senior Support Representative at SoftVelocity. If you have any questions, you can post them here or even email us at support AT softvelocity DOT com Now, on to the article! \ud83d\ude42 There has been quite a bit of confusion about using the 32 ODBC … Continue reading 32 bit ODBC in the 64-bit Operating System<\/span> →<\/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,7],"tags":[],"class_list":["post-259","post","type-post","status-publish","format-standard","hentry","category-clarion-7","category-clarionsharp"],"yoast_head":"\n32 bit ODBC in the 64-bit Operating System - Clarion<\/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:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"32 bit ODBC in the 64-bit Operating System - Clarion\" \/>\n<meta property=\"og:description\" content=\"Note: This blog was written by Robert Ricketts, who is a Senior Support Representative at SoftVelocity. If you have any questions, you can post them here or even email us at support AT softvelocity DOT com Now, on to the article! \ud83d\ude42 There has been quite a bit of confusion about using the 32 ODBC … Continue reading 32 bit ODBC in the 64-bit Operating System →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Clarion\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/softvelocity\/\" \/>\n<meta property=\"article:published_time\" content=\"2009-11-17T21:02:09+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/person\\\/e48edb030dd79310b468478fa7a207fe\"},\"headline\":\"32 bit ODBC in the 64-bit Operating System\",\"datePublished\":\"2009-11-17T21:02:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/\"},\"wordCount\":356,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Clarion 7\",\"Clarion.Net\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/\",\"name\":\"32 bit ODBC in the 64-bit Operating System - Clarion\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#website\"},\"datePublished\":\"2009-11-17T21:02:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/32-bit-odbc-in-the-64-bit-operating-system\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"32 bit ODBC in the 64-bit Operating System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\",\"name\":\"Clarion\",\"description\":\"Deliver your software on time, every time\",\"publisher\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#organization\",\"name\":\"SoftVelocity\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/svlogonew57.png\",\"contentUrl\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/svlogonew57.png\",\"width\":221,\"height\":57,\"caption\":\"SoftVelocity\"},\"image\":{\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/softvelocity\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/SoftVelocity\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/#\\\/schema\\\/person\\\/e48edb030dd79310b468478fa7a207fe\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/clarionsharp.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"32 bit ODBC in the 64-bit Operating System - Clarion","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:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/","og_locale":"en_US","og_type":"article","og_title":"32 bit ODBC in the 64-bit Operating System - Clarion","og_description":"Note: This blog was written by Robert Ricketts, who is a Senior Support Representative at SoftVelocity. If you have any questions, you can post them here or even email us at support AT softvelocity DOT com Now, on to the article! \ud83d\ude42 There has been quite a bit of confusion about using the 32 ODBC … Continue reading 32 bit ODBC in the 64-bit Operating System →","og_url":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/","og_site_name":"Clarion","article_publisher":"https:\/\/www.facebook.com\/softvelocity\/","article_published_time":"2009-11-17T21:02:09+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/#article","isPartOf":{"@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/"},"author":{"name":"admin","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/person\/e48edb030dd79310b468478fa7a207fe"},"headline":"32 bit ODBC in the 64-bit Operating System","datePublished":"2009-11-17T21:02:09+00:00","mainEntityOfPage":{"@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/"},"wordCount":356,"commentCount":0,"publisher":{"@id":"https:\/\/clarionsharp.com\/blog\/#organization"},"articleSection":["Clarion 7","Clarion.Net"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/","url":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/","name":"32 bit ODBC in the 64-bit Operating System - Clarion","isPartOf":{"@id":"https:\/\/clarionsharp.com\/blog\/#website"},"datePublished":"2009-11-17T21:02:09+00:00","breadcrumb":{"@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/clarionsharp.com\/blog\/32-bit-odbc-in-the-64-bit-operating-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/clarionsharp.com\/blog\/"},{"@type":"ListItem","position":2,"name":"32 bit ODBC in the 64-bit Operating System"}]},{"@type":"WebSite","@id":"https:\/\/clarionsharp.com\/blog\/#website","url":"https:\/\/clarionsharp.com\/blog\/","name":"Clarion","description":"Deliver your software on time, every time","publisher":{"@id":"https:\/\/clarionsharp.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/clarionsharp.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/clarionsharp.com\/blog\/#organization","name":"SoftVelocity","url":"https:\/\/clarionsharp.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2019\/03\/svlogonew57.png","contentUrl":"https:\/\/clarionsharp.com\/blog\/wp-content\/uploads\/2019\/03\/svlogonew57.png","width":221,"height":57,"caption":"SoftVelocity"},"image":{"@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/softvelocity\/","https:\/\/www.youtube.com\/user\/SoftVelocity"]},{"@type":"Person","@id":"https:\/\/clarionsharp.com\/blog\/#\/schema\/person\/e48edb030dd79310b468478fa7a207fe","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a6ea5cdfc80c081e18546e1155a072952fb1ec931d2c94bb02d5c4b14bba2dc?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/clarionsharp.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":0,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarionsharp.com\/blog\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}