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

Sam Beechey sam at saq.net
Thu Mar 31 11:10:32 CEST 2011



Problem: ~2000 queries in ~1.3M produce the following error:


[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


Debian Squeeze               2.6.32-5-xen-amd64


gcc version 4.4.5


PowerDNS                          pdns-2.9.22


./configure --with-modules="opendbx" --with-dynmodules=""
--enable-pdns_server --prefix=/usr --sysconfdir=/etc/powerdns


I had issues compiling. However the following link and instructions
resolved this.





added line: #include <cstdio>



added line: #include <cstdio>


OpenDBX                                            opendbx-1.4.5


./configure --with-backends="mssql" --prefix=/usr --disable-utils


FreeTDS                                               0.82-7
apt-get install freetds-bin freetds-dev fakeroot debhelper docbook2x
doxygen cl-sql-odbc


There is no firewall in place or firewall rules configured on the box.


The following link (Re: Loosing Control With Bad SQL) seems to imply
that there is a problem with the OpenDBX module.




Any idea what this might be? Is a patch needed?



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-dev/attachments/20110331/e81e3497/attachment.htm>

More information about the Pdns-dev mailing list