{"id":279,"date":"2018-12-08T00:57:37","date_gmt":"2018-12-08T00:57:37","guid":{"rendered":"https:\/\/ninedotconnectssandbox.com\/blog\/?p=279"},"modified":"2020-08-28T22:13:39","modified_gmt":"2020-08-28T22:13:39","slug":"dealing-with-odbc-32-64-bit-database-compatibility-issues-in-altium-designer","status":"publish","type":"post","link":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/2018\/12\/08\/dealing-with-odbc-32-64-bit-database-compatibility-issues-in-altium-designer\/","title":{"rendered":"Dealing with ODBC 32\/64-bit Database Compatibility Issues in Altium Designer"},"content":{"rendered":"

\"\"<\/p>\n

With the 64-bit Altium Designer Version 18 release, there may be some compatibility issues that arise when installing a database library. Though this document focuses on Microsoft Access, the same concept is true for any type of database.<\/p>\n

<\/p>\n

Like printers, databases have drivers, known as ODBC drivers \u2013 Open DataBase Connectivity<\/em>.\u00a0 The purpose of these drivers is to provide an outside software tool access to the information in a database.\u00a0 Companies that sell databases also provide these drivers, usually free of charge.<\/p>\n

It is not required to upgrade a database and the database accessing software to 64 bits.\u00a0 However, the software reading the database must have an OBDC driver based on its 32 or 64-bit coding.\u00a0 For example, Altium Designer version 18 requires a 64-bit ODBC driver, even if the database itself is only 32-bit.<\/p>\n

For MS Office products, the ODBC driver for MS Access is installed during Office installation.\u00a0 Though Windows 10 is a 64-bit operating system, the non-professional versions of MS Office are currently 32-bit.\u00a0 Note that even those versions of Office that are available in 64-bit will install the 32-bit by default; you have to specify the 64-bit version during setup and installation.<\/p>\n

To determine which driver(s) have been installed on your computer in Windows 10, open the ODBC dialog.\u00a0 This can be accessed by typing \u201cODBC\u201d in the operating system’s search prompt.\u00a0 The dialog will show the driver and its status for 32\/64 bits.\u00a0 Note that there is both an ODBC 32 and ODBC 64 Data Source Administrator dialog box; however, either one will show the status of the driver:<\/p>\n

\"\"<\/p>\n

For MS Access, if 64 bits is not listed in the ODBC, it will need to be installed.<\/p>\n

Altium has issued a procedure for the 64-bit MS Access installation.\u00a0 The title:<\/p>\n

Using Database Libraries with 32-bit and 64-bit Altium Design Software on the same Computer<\/em><\/p>\n

The link is available by clicking here.<\/a><\/p>\n

Notes:<\/p>\n

    \n
  1. There are several options provided. Option 2 – Install the 64-bit Microsoft Access Database Engine (2010), alongside your existing install of 32-bit Microsoft Office,<\/em> is the recommended procedure.\u00a0 This procedure also contains a link for downloading the driver 64-bit Microsoft Access Database Engine (2010)<\/em>.\u00a0 When clicking on the link, select the language for downloading.\u00a0 On the next page, select AcessDatabaseEngine_X64.exe.\u00a0 If prompted, save the file.\u00a0 Do not run it.\u00a0 Follow the instructions provided by Altium.<\/li>\n
  2. In Option 2, a modification will be needed for the registry. It is recommended that the name be changed rather than deleted.\u00a0 This is a precaution in the event other software suites using the database are impacted by this change.<\/li>\n
  3. This procedure should be performed under the supervision of the company\u2019s IT group (if available.)<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    With the 64-bit Altium Designer Version 18 release, there may be some compatibility issues that arise when installing a database library. Though this document focuses on Microsoft Access, the same concept is true for any type of database.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[63,64,30,11,19,65,68,66,61,67,62],"class_list":["post-279","post","type-post","status-publish","format-standard","hentry","category-back9","tag-32-bit","tag-64-bit","tag-altium","tag-altium-designer","tag-database","tag-microsoft","tag-ms-access","tag-ms-office","tag-odbc","tag-odbc-driver","tag-open-data-base-connectivity"],"_links":{"self":[{"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":6,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/279\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ninedotconnectssandbox.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}