topic how to resolve failed to connect to database an underlying database error occurred class not registered in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620160#M35028 <HTML><HEAD></HEAD><BODY><P>I am trying to add an excel table to my map. &nbsp;I get the message "Failed to connect to database. An underlying database error occurred. Class not registered"</P><P>What do I need to do to resolve this error?</P></BODY></HTML> Wed, 01 Mar 2017 18:54:58 GMT JuanitaOwens 2017-03-01T18:54:58Z how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620160#M35028 <HTML><HEAD></HEAD><BODY><P>I am trying to add an excel table to my map. &nbsp;I get the message "Failed to connect to database. An underlying database error occurred. Class not registered"</P><P>What do I need to do to resolve this error?</P></BODY></HTML> Wed, 01 Mar 2017 18:54:58 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620160#M35028 JuanitaOwens 2017-03-01T18:54:58Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620161#M35029 <HTML><HEAD></HEAD><BODY><P>Take a look at this article:&nbsp;<A class="link-titled" href="http://support.esri.com/Technical-Article/000012103" title="http://support.esri.com/Technical-Article/000012103">Error: Failed to connect to database. An underlying database error occurred. Class not registered</A>&nbsp;</P><P></P><P><A href="https://community.esri.com/groups/technical-support?sr=search&amp;searchId=dd3ef642-c507-4fb1-8c2a-e68a4b5b8e6f&amp;searchIndex=0">https://community.esri.com/groups/technical-support?sr=search&amp;searchId=dd3ef642-c507-4fb1-8c2a-e68a4b5b8e6f&amp;searchIndex=0</A></P></BODY></HTML> Wed, 01 Mar 2017 18:59:32 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620161#M35029 George_Thompson 2017-03-01T18:59:32Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620162#M35030 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P></P><P>It worked.</P><P></P><P></P><P>Juanita Owens</P><P>Administrative Committee for Pistachios</P><P>California Pistachio Research Board</P><P>4938 East Yale Avenue, Suite 102</P><P>Fresno, California 93727</P><P>Office: 559-255-6480, Ext. 101</P><P>Fax: 559 255 6485</P><P>E-Mail: juanitao@acpistachios.org&lt;mailto:juanitao@acpistachios.org&gt;</P></BODY></HTML> Wed, 01 Mar 2017 19:06:25 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620162#M35030 JuanitaOwens 2017-03-01T19:06:25Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620163#M35031 <HTML><HEAD></HEAD><BODY><P>Please mark this as correct to help other users when they are searching for this same issue! Thanks!</P></BODY></HTML> Wed, 01 Mar 2017 19:21:07 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620163#M35031 George_Thompson 2017-03-01T19:21:07Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620164#M35032 <HTML><HEAD></HEAD><BODY><P>I had the same problem and it worked. Although the driver is supposed to work with 2007 Microsoft Office systems, it solves&nbsp;the problem even if you have Microsoft Office 2016</P></BODY></HTML> Wed, 13 Jun 2018 13:54:32 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620164#M35032 NIRPCNIRPC 2018-06-13T13:54:32Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620165#M35033 <HTML><HEAD></HEAD><BODY><P>The page appears to have moved or been dropped for "<A class="" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fsupport.esri.com%2FTechnical-Article%2F000012103" rel="nofollow" target="_blank">Error: Failed to connect to database. An underlying database error occurred. Class not registered</A>".&nbsp; Does anybody have the new location?</P></BODY></HTML> Fri, 15 Feb 2019 19:36:40 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620165#M35033 RobertHarmon 2019-02-15T19:36:40Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620166#M35034 <HTML><HEAD></HEAD><BODY><P>Hi Robert,</P><P></P><P>The previous article does appear to have been removed. If you are receiving this error it may be an indication that the machine being used does not have Microsoft Office installed and will require a driver so that ArcGIS Desktop can view the files.&nbsp;</P><P></P><P>Please attempt to download the 32-bit Microsoft Access Database Engine 2010 Redistributable Driver</P><P><A class="link-titled" href="https://www.microsoft.com/en-us/download/details.aspx?id=13255" title="https://www.microsoft.com/en-us/download/details.aspx?id=13255">Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center</A>&nbsp;</P><P></P><P></P><P>*The 2007 Office System Driver which was previously the solution has been deprecated by Microsoft and is no longer available for download.</P></BODY></HTML> Tue, 19 Feb 2019 18:14:11 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620166#M35034 Jared_Motuz 2019-02-19T18:14:11Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620167#M35035 <HTML><HEAD></HEAD><BODY><P>Hi Jared,</P><P></P><P>My instance of MS Office was recently upgraded from MS Office 2010 (32-bit) to 2013 (64-bit).&nbsp; I can open .mdb and .xls files in Catalog, but I get the "Failed to connect..." error when I attempt to open. xlsx files.</P><P>I'll try the link above and let you know how it goes.</P><P></P><P>Bob</P></BODY></HTML> Wed, 20 Feb 2019 23:05:21 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620167#M35035 RobertHarmon 2019-02-20T23:05:21Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620168#M35036 <HTML><HEAD></HEAD><BODY><P>Jared,</P><P></P><P>I just tried to install the 32-bit MS Access db engine 2010 driver and I got an error that I already had 64-bit Office installed.&nbsp; I installed the 64-bit driver and still get the original "Failed to connect..." error when trying to open a .xlsx file.</P><P></P><P>Any ideas?</P><P></P><P>Bob</P></BODY></HTML> Wed, 20 Feb 2019 23:18:22 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620168#M35036 RobertHarmon 2019-02-20T23:18:22Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620169#M35037 <HTML><HEAD></HEAD><BODY><P>If there are conflicts with the 2010 driver then I would ask that you attempt to install the 32-bit MS Access db&nbsp;engine 2016 found at the following location:</P><P></P><P><A class="link-titled" href="https://www.microsoft.com/en-us/download/details.aspx?id=54920" title="https://www.microsoft.com/en-us/download/details.aspx?id=54920">Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center</A>&nbsp;</P><P></P><P>If problems still persist, I would recommend to reach out to Esri Tech Support to look further into this issue.</P></BODY></HTML> Thu, 21 Feb 2019 13:28:18 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620169#M35037 Jared_Motuz 2019-02-21T13:28:18Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620170#M35038 <HTML><HEAD></HEAD><BODY><P>I downloaded the 32-bit 2016 MS Access db engine and tried to install it.&nbsp; I got the same error that I did with the 32-bit 2010 Access db engine attempted install (screen capture inserted below).</P><P></P><P>I'll contact tech support.</P><P></P><P>Bob</P><P><IMG alt="Access 2016 32-bit db engine installation error" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/437867_access2016_32bit_install_error.PNG" /></P></BODY></HTML> Thu, 21 Feb 2019 17:40:04 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620170#M35038 RobertHarmon 2019-02-21T17:40:04Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620171#M35039 <HTML><HEAD></HEAD><BODY><P>As everyone else in this thread has already discovered the Microsoft Access Database Engine 2007 redistributable worked for me, too.&nbsp; It's available from the CNET site at <A class="link-titled" href="https://download.cnet.com/2007-Office-System-Driver-Data-Connectivity-Components/3000-10254_4-75452798.html" title="https://download.cnet.com/2007-Office-System-Driver-Data-Connectivity-Components/3000-10254_4-75452798.html">2007 Office System Driver: Data Connectivity Components - Free download and software reviews - CNET Download.com</A> .</P><P></P><P>Bob</P></BODY></HTML> Fri, 22 Feb 2019 22:27:32 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620171#M35039 RobertHarmon 2019-02-22T22:27:32Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620172#M35040 <HTML><HEAD></HEAD><BODY><P>Thanks, Bob!! Just upgraded my computer; neither the 2010 or 2016 redistributable worked for me, and I was having trouble finding the 2007 driver. But, thanks to your link I am now up and running again.</P></BODY></HTML> Wed, 08 May 2019 15:53:16 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/620172#M35040 CathiBalch1 2019-05-08T15:53:16Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1210461#M44227 <P>Yes, Thanks Bob!&nbsp; I just also downloaded the 2007 version and it worked like a charm, after attempting the newer versions that would not work due to me having 64 bit Microsfot Office products installed already.</P> Wed, 07 Sep 2022 17:12:27 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1210461#M44227 RhondaParrish 2022-09-07T17:12:27Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1260442#M44431 <P>Link is dead.</P> Wed, 22 Feb 2023 13:28:07 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1260442#M44431 Scott_Russell 2023-02-22T13:28:07Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1282088#M44534 <P>Unbelievable - still need this in 2023! Thanks for the link; the link worked and the driver worked as well.</P> Mon, 24 Apr 2023 20:27:14 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1282088#M44534 LaurieWilliams 2023-04-24T20:27:14Z Re: how to resolve failed to connect to database an underlying database error occurred class not registered https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1327261#M44702 <P>I get the same as Robert, what was the solution in the end?</P> Mon, 11 Sep 2023 13:28:45 GMT https://community.esri.com/t5/data-management-questions/how-to-resolve-failed-to-connect-to-database-an/m-p/1327261#M44702 PhilipAugustyn 2023-09-11T13:28:45Z