Linked Server (lossing connection)

[mattyboy2000]

Hi,

I am having a strange problem. I am connecting from SQL Server to a Progress database. This works fine 90% of the time.

The problem is that the connection between the databases seems to be dropping randomly. What I want to do is try and run a query and if I get an error wait 10 seconds and try it again.

I keep getting the error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [OpenLink][ODBC][Progress Server]** No database connected. (543)]

The problem is that the @@Error value is still 0 so I cannot catch the error.

Any ideas will be greatfully recieved.

Thanks



Matt