Post reply

ON’Microsoft.ACE.OLEDB.12.0LEDB Error

  • April 10, 2013 at 4:49 am

    #276302

    Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

    I have already tried

    USE [master]

    GO

    EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1

    GO

    EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’DynamicParameters’ , 1

    GO

    n also updated registory

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.??\Providers\Microsoft.ACE.OLEDB.12.0\DisallowAdhocAccess to 0.

  • April 10, 2013 at 5:26 am

    #1605161

    your linked server, is it for an excel spreadsheet, or an access database?

    I've never gotten Access to work in Ace / 64 bit, but i've read creating a DSN, and using that is one way to fix that issue.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply