This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 84%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hello,
Welcome to Microsoft Q&A!
Can you get any relevant information from the error log or Windows log when a crash occurs?
How do you read the Sage data with linked server ? Does reading a small amount of data also cause problems?
Hi,
Is there any update on this case?
Hello Trevor,
AFAIK is Sage a british software company selling several very different ERP systems; I e.g. know Sage Office Line, which host the database on SQL Server.
But isn't Sage 50 a software utilizing a proprietary database and so proprietary data provider, right?