| jkollar 2005-11-15, 8:23 pm |
| Just curious, do you have compression turned on in your DSN?
If so, try turning it off. I had a similar problem and I was
able to correct this by turning compression off.
> I have a strange issue with SQL Remote Message Agent
> Version 9.0.2.3137. Both the consolidated database and
> the SQLREMOTE agent are running on the same W2K server.
> The SQLREMOTE agent will run for a few days, and then I
> get the following error:
>
> I. 08/12 14:44:08. Received message from "laptop_003"
> (0-0001170482-0001170482-0)
> E. 08/12 14:44:08. SQL statement failed: (-308) Connection
> was terminated I. 08/12 14:44:09. Execution completed
>
> In the attached log the error occurs twice over a four day
> period. Remote user laptop_003 is always the triggering
> laptop, but this was not always the case. I should
> mention that this was happening before, so I upgraded the
> database, completely rebuilt the database (25 MB, 3 remote
> users), dropped and recreated the remote users, etc.
> Also, the central DB receives a lot of messages from
> laptop_003 without choking. The database schema is
> running at other installations without issue.
>
> Any help or suggestions would be greatly appreciated.
>
> Don Clayton
>
>
>
>
> [Attachment: SQLRemoteMessages.log]
|