locked
SSMA: Error 80040154 on Windows 7 - 64 bits RRS feed

  • Question

  • I am getting the following error message when adding a new database to SSMA:

    "Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. Please run SSMA in 32-bit (or 64-bit) mode or consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502. An error occurred while loading database content."

    I am running Windows 7 64bits, Office 2010 32 bits. I have installed the SQL Server Native Client x64.

    Note that I migrated this database before using a 32bits machine. I can use the access front end on my new 64bits machine (ie: I can connect to Azure).
    Is there a 64bits version of SSMA I can donwload?

    Any help would be much appreciated. Thank you!

    Thursday, September 9, 2010 7:20 AM

Answers

  • SSMA installs 32-bit and 64-bit binaries on a 64-bit platform. If you have Access 32-bit installed, you can use SSMA 32-bit binary (shortcut available in Programs menu) and SSMA should work fine. SSMA 32-bit requires DAO 32bit libraries and SSMA 64-bit requires 64-bit DAP libraries.

    Keshav Ramarao

    SQL Server Migration Assistant Team

    • Marked as answer by jthierry Tuesday, September 28, 2010 12:38 AM
    Monday, September 27, 2010 10:33 PM

All replies

  • Just managed to make it work by following the procedure described here (http://www.databasemigrate.com/Discussions/tabid/56/forumid/3/postid/6/scope/posts/Default.aspx) and making some changes to suit SSMA for Access.

    Isn't there a simpler way to use SSMA for Access on a x64 OS!?!

    Thursday, September 9, 2010 9:30 AM
  • Hi,

    I tested SSMS with my Windows 7 64bit machine and it works. According to the error message you posted, this should be a 64bit provider issue. You need to install AccessDatabaseEngine_2010_X64, however your Office is 32, you can only install AccessDatabaseEngine_2010_x86. So I’m afraid you have to install Office 2010 64bit, and then ensure you have installed AccessDatabaseEngine_2010_X64:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

     

    Thanks,

    Raymond


    Raymond Li - MSFT
    Monday, September 13, 2010 11:26 AM
  • Hi Raymond.

     

    Since I could make it work by using corflags.exe without changing my config. (Windows 7 64bits + Office 32bits ), would it be possible to bypass the use of corflags in a future vesion of SSMA?

    More and more systems are sold with WIndows 7 64bits + Office 32bits around here and I would not be surprised if more Access users encounter this problem in the future when migrating to Azure.

    Just my two cents worth

     

    Thierry

    Saturday, September 18, 2010 4:38 AM
  • SSMA installs 32-bit and 64-bit binaries on a 64-bit platform. If you have Access 32-bit installed, you can use SSMA 32-bit binary (shortcut available in Programs menu) and SSMA should work fine. SSMA 32-bit requires DAO 32bit libraries and SSMA 64-bit requires 64-bit DAP libraries.

    Keshav Ramarao

    SQL Server Migration Assistant Team

    • Marked as answer by jthierry Tuesday, September 28, 2010 12:38 AM
    Monday, September 27, 2010 10:33 PM
  • Thank you Keshav. I always used the shortcut on my desktop without realizing that there was a link to both versions of SSMA (32/64) in the Start Menu!.
    Tuesday, September 28, 2010 12:38 AM
  • Hi Keshav,

    I have a laptop running Windows 10 (64 Bit) with Office Pro 2013 (32 Bit) installed and whichever version of SSMA (64 or 32 Bit) results with same error.

    Many Thanks, Paul

    Thursday, May 5, 2016 5:55 PM
  • I have the exact same problem. I cannot import my access database to Azure SQL using either the 32 or 64 bit versions of the tool. Both version throw the same error.

    Thursday, October 27, 2016 6:58 PM
  • i've wrote about the 32 / 64 bit problematic on ssma for access and found a simple solution

    http://www.insidesql.org/blogs/klausobd/2017/10/08/sql-server-migration-assistant-fuer

    the English part is at the end of the german one.

    mfg Klaus


    Klaus Oberdalhoff Germany

    Monday, October 30, 2017 4:43 PM