[asterisk-users] ODBC connection does not reconnect after network interruption

[Noah Engelberth]

I've got an Asterisk 10.1.2 server using res_odbc to make a connection to a MSSQL server on a different machine for a timeclock extension we have running.  The connection works just fine until Asterisk's network path to the MSSQL server gets disrupted (for whatever reason), and then all future attempts to contact the MSSQL server cause the timeclock call to hang, until Asterisk is completely restarted.  Trying to module unload/load res_odbc.so crashes Asterisk.  I've been using the following config, and tried with preconnect both on and off:

[timeclock]
enabled => yes
dsn => timeclock
username => notauser
password => stealme
pooling => no
limit => 1
pre-connect => no

Any suggestions on where to try digging in to this?

Thank you,

Noah Engelberth
MetaLINK Technologies

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120320/6b88ef2e/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: AVG Certification.txt
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120320/6b88ef2e/attachment.txt>