Saturday , November 23 2024

When Running Linked Server Created For Oracle, SQL Server Service Crashes. Error Code:0xc0000374

 

I have already mentioned how to create a linked server that will connect to Oracle in the article named How To Create a Linked Server To Connect To Oracle“.

This linked server can sometimes be very dangerous.

If you use sql comment comments — in oracle query in linked query and allow in process enable, sql server service crash.

If it crashes like this, you will get errors like the following screen shot.

To avoid this error, you should put your comments in the linked server query between /* */ instead of  – – or remove the comment.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *