October 1, 2010 at 4:35 am
Trying to import from an excel template into Sql server 2008 (trying 2003, 2007 and 2010 versions). This has been working fine, but recently got the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider reported an unexpected catastrophic failure.
Subsequent attempts just give an sql timeout error.
Any ideas for resolution?
Thanks
October 1, 2010 at 12:42 pm
Sometimes I find that by going to linked servers in SSMS and setting the provider (I believe this would be the Jet provider) in and out of process sometimes "resets" things.
October 3, 2010 at 11:00 pm
Setting the "Allow in Process" property of the linked server should fix the issue. Please refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 4, 2010 at 10:05 am
Thank you for your help, I have tried this but it still just hangs.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply