Distribution Agent Error (Timeout)

I have SQL Server 2000 transactional replication databases
that timeout with errors listed below.
The databases were replication for two days without a
problem and I received the errors listed below.
Please help me resolve these errors.
Thank You,
Mike
Errors from Distribution Agent:
The process is running and is waiting for a response from
the backend connection.
{call sp_MSget_repl_commands(4, ?, 0, 7500000)}
Timeout expired
(Source: ODBC SQL Server Driver (ODBC); Error number:
S1T00)
sounds like you are replicating to Oracle? is this true?
The backend connection errors are hard to diagnose.
Enable replication logging and see if anything is going on
http://support.microsoft.com/default...b;EN-US;312292
Also change your inactivity threshhold to something large - right click on
replication monitor, select refresh rates.
If nothing is going on you should stop the agent and restart. If this fails
stop the sql agent service and restart, if this fails stop SQL Server and
restart, if this fails reboot.
If logging does reveal activity bump up your querytimeout setting to
something large - ie 1 hour and see what happens.
Exactly what are you doing that caused this to hang.
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1d0ea01c4230f$31615340$a301280a@.phx.gbl...
> I have SQL Server 2000 transactional replication databases
> that timeout with errors listed below.
> The databases were replication for two days without a
> problem and I received the errors listed below.
> Please help me resolve these errors.
> Thank You,
> Mike
>
> Errors from Distribution Agent:
> The process is running and is waiting for a response from
> the backend connection.
> {call sp_MSget_repl_commands(4, ?, 0, 7500000)}
> Timeout expired
> (Source: ODBC SQL Server Driver (ODBC); Error number:
> S1T00)