Hi ... we have the following setup.
Windows Server 2003
MSSQL 2000 with last service pack
What I am going to describe to you works for about a month and then stops working. This happened on a completely different server and we assumed something had corrupted on that server so we moved it to a different box and it has now happened again ... please help.
We have a job that runs every 30 minutes to pull in some data from a Progress database. We are using the Merant 3.70 32-BIT Progress driver in System DSN. When it works the job takes about 1 minute to complete.
However the following very simple query (normally takes a second) will now not complete and will sit not executing infinitely:
WHERE Field2= 1
If I look in Process Info then I have something that details:
wait time - keeps increasing with every refresh as you would expect if it has hung
wait type - OLEDB
Wait resource - My_LINKED_SERVER
Any ideas why this would work fine for a month (or so) and then not work? I have started / stopped services and rebooted but to no avail. If I do a test connection in my System DSN then that works without any issues. Nothing that I am aware has changed on the server and for this to have happened twice it is very odd. Please help!