Post reply

Linked server catastrophic failure problem

  • October 1, 2010 at 4:35 am

    #224580

    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

    #1230440

    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

    #1230825

    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

    #1231102

    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