[Pdns-dev] OpenDBX Backend with FreeTDS - Error: Attempt to initiate a new Adaptive Server operation with results pending

[Norbert Sendetzky]

Hi Sam

> [OpendbxBackend] execStmt: Unable to execute query - Attempt to initiate
> a new Adaptive Server operation with results pending, Success
>
> Database module reported condition which prevented lookup (Error: DB
> statement failed) sending out servfail

The FreeTDS libsybdb (and the original library from Sybase) which the 
OpenDBX mssql backend is build on is not 100% thread-safe. This might be 
the cause of your errors

I think you have the following options:

Try the OpenDBX "sybase" backend even if you are using a MS SQL server. 
The underlying protocol is the same and the FreeTDS libct is thread-safe.

Try the OpenDBX "odbc" backend. It also uses FreeTDS but might yield 
better results.

The hard way is to try to debug what's happening and if it's not a 
thread issue, we can fix it.


Norbert