[egenix-users] OperationalError: ('08S01', 0, '[Microsoft][ODBC SQL Server Driver]Communication link failure', 4612)',)

[Jim Vickroy]

Howdy,

Could anyone offer a suggestion as to the cause of the following error:

OperationalError: ('08S01', 0, '[Microsoft][ODBC SQL Server
Driver]Communication link failure', 4612)',)

when trying to perform a table insert operation?

Some background:

	o The error is encountered by long-running processes after "some" period of
time in
		which the inserts are successfully performed.
	o Once this error occurs, for a particular process, the same error persists
until
		the process is stopped/restarted -- even though the process is coded to
get
		a fresh connection each time it tries to do an insert to this table.
	o At the same time a process is experiencing the above error, it is able to
successfully
		perform inserts and selects against other tables in a different SQL Server
datastore.

Some details:

	Microsoft Windows 2000 Server
	Microsoft SQL Server 2000 with all of the latest patches
	Python v2.3.3
	egenix-mx-base-2.0.5.win32-py2.3
	egenix-mx-commercial-2.0.6.win32-py2.3

Thanks,

-- jv