mxODBC problems

[m.haberfeld]

Alrighty, here's the deal, I'm writing an application server in Python that
makes use of the mxODBC module.  I've used this module many times before and
am certain of it's stability so I think the problem must be in the SQL
server settings.

I wrote a threaded application that checks the server every 30 seconds for
entries into a table that would have been inserted by a user from a web
page.  If there is a new entry, the program pulls the entry, opens a
connection to another DB, updates a few tables,  closes the connection and
continues on its merry way.

There is, apparently, no errors in the script programming as the server will
run through about 6 minutes worth of cycles before giving the error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.

I figure it has something to do with either the multiple connections maxing
out the network buffer, or the connections not being closed properly.
However, I don't know of a way to monitor this to check it or any way to
test/fix it.  I tried changing  the network packet size to no avail.  I was
even able to lessen the amount of connections needed by the application in
half, but nothing seemed to work.

Dropping the number of connections didn't even increase the average amount
of time the application would run before an Access Denied message.  I'm all
out of ideas.

Any thoughts or suggestions would be quite appreciated.

Best regards,

Jeremy Reed