none
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    Question

  • I create Link Server in Sql 2008

    EXEC sp_addlinkedserver 'ExcelShare',
       'Jet 4.0',
       'Microsoft.Jet.OLEDB.4.0',
       'c:\DistExcl.xls',
       NULL,
       'Excel 5.0'

    if Run test connection or OPENQUERY for Link server display error

    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    Sunday, October 16, 2011 2:16 PM

Answers

  • Hi Mahdy.asia,

    >>error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    You can try to use 64-bit ACE driver as Piotr Palka mentioned, please obtain the Microsoft.ACE.OLEDB.12.0 from here: 2007 Office System Driver: Data Connectivity Components

    Another option is to download a 64-bit JET driver for SQL-Server 64 bit. If you already have Office/Access 32 bit installed on your machine, you need to remove fist before installing 64-bit JET driver. Please You obtain the driver from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

    More information, please reference this thread with the same scenario as yours: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/9ccf6bd6-d377-40fe-9e3b-7a5063ff3d09

    Regards, Amber zhang
    • Proposed as answer by Stephanie Lv Monday, October 24, 2011 8:35 AM
    • Marked as answer by Stephanie Lv Wednesday, October 26, 2011 3:40 AM
    Tuesday, October 18, 2011 3:18 AM
  • Hi Mahdy.asia,

    >>error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
    If you are using 64-bit SQL Server 2008, please refer my reply above, which would be help to solve your issus.
    If you are using 32-bit SQL Server 2008, this error might be related to unregistered DLL based on the Jet 4.0 OLE DB Provider that you are using, please try to modify steps accordingly.
    To resolve this problem, register the faulty DLLs as follows:
    1. At a command prompt, change to the C:\Program Files\Common Files\System\OLE DB folder.
    2. At a command prompt, type the following command:
    regsvr32 Msjetoledb40.dll
    regsvr32 Msjet40.dll
    regsvr32 Mswstr10.dll
    regsvr32 Msjter40.dll
    regsvr32 Msjter40.dll
    3. You should receive confirmation that the DLL is registered successfully.

    The pertinent DLLs list of OLE DB provider "Microsoft.Jet.OLEDB.4.0" as below:
    C:\WINNT\System32\Msjetoledb40.dll
    C:\WINNT\System32\Msjet40.dll
    C:\WINNT\System32\Mswstr10.dll
    C:\WINNT\System32\Msjter40.dll
    C:\WINNT\System32\Msjint40.dll
    More information, please reference this KB: http://support.microsoft.com/kb/278604
    Hope it is helpful.

    Regards, Amber zhang
    • Marked as answer by Stephanie Lv Wednesday, October 26, 2011 3:40 AM
    Monday, October 24, 2011 9:19 AM

All replies