Sage 50 Linked Server causing SQL to crash

• tpsharp

  SSC Veteran

  Points: 221

  More actions

  May 5, 2021 at 4:43 pm

  #3879704

  Hi,

  I have created a linked server to a Sage ODBC connection, and whilst it does start to read in data from Sage, it crashes the whole of SQL Server after about 1,000 records.

  I have followed the recommendations MSDASQL enabling LevelZeroOnly and disabling AllowInProcess, but SQL server still crashes when querying the Sage 5o data.

  Has anyone seen this issue before, and found a way to overcome this?

  Many thanks,

  Trevor

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 6, 2021 at 5:10 pm

  #3880224

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.