You have discovered that ODBC is not resilient!

Using MySQL we never use ODBC to connect - even on our LAN, of course using an MS database we don't have much choice, so we don't use MS.

We got around it in some cases by actually wrtiing a SOAP server in Perl on the DB machine and accessing that from the client side - look up SOAP::Lite

As someone else said - 'Good Luck'

jdtoronto