[Pdns-users] Could not execute query

[Richard Mason]

Hi Folks/Michel,

One assumes it must be a syntax issue?

>> I think I've solved the problem.  It seems that unless you run through
all of the screens of the Sql Server ODBC wizard, not all of the options
(not even defaults) are stored as part of the ODBC connection.  When I added
the ODBC data source in the first place, I merely entered the details on the
first screen of the wizard and hit 'Test Connection' followed by 'Finish'.
I've just been through all the screens as I thought it may have something to
do with the transformation options (e.g. "Use ANSI quoted identifiers"),
didn't actually change any of the options, but hey presto its now working.

>> God bless Microsoft wizards :P  Might be worth a mention in the release
notes/documentation?

Regards,

Richard Mason

Ultimate Conn-X-tion
Tel/Fax : +44 (0)1206 522799
Web : www.ulticonn.co.uk