Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Microsoft.ACE.OLEDB.12.0

Author  Topic 

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-11-27 : 14:32:19
Hi all,
I installed the Microsoft.ACE.OLEDB.12.0 driver on my production sql machine
Do I need to restart the sql service. Is there a way without restarting the service. I do not want to put the site down.

another question:
I followed the same steps I did on my development machine but on the production (Both machines are exactly the same)

I am getting the following error on production message:Error: OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Althu I gave the sqlaccount permission to that folder
It is working fine on my development machine.

sarah
   

- Advertisement -