• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Logging to msql stops with odbc error

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Logging to msql stops with odbc error Page: [1]
Login
Message << Older Topic   Newer Topic >>
Logging to msql stops with odbc error - 2.Jun.2005 7:45:00 AM   
rgransbury

 

Posts: 11
Joined: 11.Jun.2001
From: Altoona PA USA
Status: offline
I have my isa server 2004 sp1 logging to a sql database on a separate server.
At random times logging to this sql server will fail with the error message below in the event logs. This will then cause firewall service to stop and have to be restarted.

Note: datasource, table, and username have been removed.

The ISA Server Web filter failed to log information to ODBC Data Source <>, Table: <>, under User Name []. The ODBC Error description is: [State=01004][Error=0][Microsoft][ODBC SQL Server Driver]Fractional truncation [State=01000][Error=10054][Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()). [State=08S01][Error=11][Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. .

Thank You!
Post #: 1
RE: Logging to msql stops with odbc error - 2.Jun.2005 10:05:00 AM   
KyleKartan

 

Posts: 59
Joined: 21.Oct.2003
From: New Hampshire
Status: offline
I was having the exact same issue logging to an MS SQL2000 server. I never did find out the issue that was causing it, but it did seem to be random.

(in reply to rgransbury)
Post #: 2
RE: Logging to msql stops with odbc error - 22.Nov.2005 5:16:14 PM   
dasmail2000

 

Posts: 10
Joined: 27.Sep.2003
Status: offline
One option is to not have the service stop if logging fails.

This is not a perfect solution but an option -

Under monitoring/alerts select Configure Alerts Defnitions.
Then select "log failures" and choose edit.

On that page deselect the "stop selected service".

(in reply to KyleKartan)
Post #: 3

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Logging to msql stops with odbc error Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts