The change from a literal specification to a parameter marker is
called "parameter marker conversion". IIRC there is a setting in the
INI, but that query option is likely not an issue, unless perhaps the
setting has changed.
The issue might be related to the SQL Package that stores the
statement. Many people will blindly delete packages to avoid any
"weirdness" similar to what they had seen in prior release upgrades. I
would always save before any deletions, to avoid losing information to
debug\review the failure, for example if the deletions resolved the
issue. I had read once that changing the driver to stop using packages
turns off Extended Dynamic support.... but I only ever dabbled in any
client stuff, mostly only ever dealing with the server side. I would
think that the system-wide cache might replace packages for the extended
dynamic, though perhaps not.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.