Linked Server To Progress Database Failing (SQL Server 2008)

I have a linked server to a progress database. For the past week the connection was working and I was able to use the :

SELECT * FROM OPENQUERY('LinkedServerName', 'Query')


Code in order to run basic selects from the progress tables on that database. Suddenly today however it seems that the linked servers are no longer working. I checked by ODBC Drivers that connect to the Progress Database and they all seem to connect via the test connection. However when I go to test the linked server connection using that ODBC, the test connection hoses my entire instance of SSMS. This is a weird one. This is also on a production box so rebooting is a last resort. I've also determined that the progress DB's are up and running without issue. I'm sort of an accidental DBA, and it's times like this when I get lost. Has anyone else run into a similar issue? What did you do to correct it?

Continue reading...