Justin Patterson

My feedback

  1. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Justin Patterson supported this idea  · 
    An error occurred while saving the comment
    Justin Patterson commented  · 

    After a recent update (past two weeks), I too have had trouble importing Excel data into a MS SQL Server database. I am using a linked server. The data used to import just fine. Now, when I click "test connection" on all of my linked servers, they are failing. Here is the error message:

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    The test connection to the linked server failed.

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "<private>".
    OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "<private>" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303)

    I am using:

    SQL Server Management Studio 15.0.18118.0
    Microsoft Analysis Services Client Tools 15.0.1300.131
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.18362

    Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64) Jun 15 2019 00:26:19 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 18362: )

Feedback and Knowledge Base