none
Linked Server Test Connection Error RRS feed

  • General discussion

  • Hello I am using sql server 2012 on a 64 bit machine

    Whenever I try to Test Connectin over my linked server I get the following:

    OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelData" returned message "Unspecified error".
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelData".

    But when I run Sql as Administrator Test Connection over linked server works correctly and I can query the excel file linked to it.

    I am logged in from an administrator account that is a sysadmin on sql.

    I have tried the solution mentioned here

    https://visakhm.blogspot.com/2013/12/how-to-solve-microsoftaceoledb120-error.html

    But none worked.

    Microsoft access database engine 2010 -x64 was installed successfully.And my Os is Windows 10 Pro and sql version

    Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) 
    Aug 15 2017 10:23:29 
    Copyright (c) Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: )

    Any other solutions that I can try?


    Tuesday, June 11, 2019 9:19 AM

All replies