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

• mp88_3

  SSC Veteran

  Points: 256

  More actions

  February 26, 2019 at 12:40 pm

  #382820

  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?

• frederico_fonseca

  SSCoach

  Points: 16216

  More actions

  February 26, 2019 at 2:14 pm

  #2023016

  Answer removed due to inappropriate reply from the OP

• mp88_3

  SSC Veteran

  Points: 256

  More actions

  February 26, 2019 at 2:19 pm

  #2023019

  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!!!!

• frederico_fonseca

  SSCoach

  Points: 16216

  More actions

  February 26, 2019 at 2:31 pm

  #2023021

  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.

• frederico_fonseca

  SSCoach

  Points: 16216

  More actions

  February 26, 2019 at 2:52 pm

  #2023024

  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.