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

  • I have this code:
    insert into OPENROWSET('Microsoft.Ace.OLEDB.12.0',
    'Excel 12.0;Database=D:\Data\testing.xlsx;',
    'SELECT * FROM [SheetName$]') select * from sample..fams

    and I get the following error:
    OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)" 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 "(null)".

    The steps I have taken so far in trying to resolve this error:
    1). Uninstalled Microsoft Oiffce as I realised I had a 32 bit Access, reinstalled it so everything I have now is 64 bit.
    2). I ran this piece of code
    sp_configure 'show advanced options', 1
    RECONFIGURE
    sp_configure 'Ad Hoc Distributed Queries', 1
    RECONFIGURE

    3). I also ran this piece of code too:
    EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1  
    EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

    Does anyone know why I am getting the error still?

  • Answer removed due to inappropriate reply from the OP

  • ffs, I did google!
    stop responding back each time saying "did google them".
    if you got nothing decent to say, I rather you don't respond!!!!

  • mp88_3 - Tuesday, February 26, 2019 2:19 PM

    ffs, I did google!
    stop responding back each time saying "did google them".
    if you got nothing decent to say, I rather you don't respond!!!!

    you got your decent replies, both here and on your previous thread. If you choose to ignore them it is your problem.
    the issues I mentioned here cover 99% of the possible issues. Should you have another issue them maybe someone else here will be willing to help you.

  • mp88_3 - Tuesday, February 26, 2019 2:47 PM

    No one posted the solution to my last thread.I figured it out myself by changing the drive from “C†to “Dâ€.I don’t see anyone on this forum telling me to do that, so no, it is not decent!!!In fact, I left that thread with a question asking why changing the drive works to which people have chosen to ignore, not me!!!And the suggestions you have given in this thread to my original question are useless as trying each of them has not helped to solve my problem.In fact, since joining this forum I haven’t actually had anyone post the correct solution to my problems, instead I have wasted my time arguing with idiots like you.

    my answer here removed.

    As for the other thread the answer to your issue was given, by myself and the others posting there. Its permissions all the way. But as there are multiple levels of permissions you could not figure it out. That does not invalidate the fact that it was what you were told.

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

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