[freetds] issue with prepared statement queries from a Mac OS X client to SQL Server 2005
Nick Davis
nick.davis at vidoop.com
Mon Oct 13 13:33:43 EDT 2008
Hello,
I'm using FreeTDS 0.82 on a Mac OS X Leopard machine to run some
prepared statements against our SQL Server 2005 database. The query
with the issue is:
SELECT COUNT(*) from tbl WHERE tbl_id = ?
Whenever I run the application, I receive the following error with the
query:
SQLSTATE = 420000
Native Error Code = 402
[FreeTDS][SQL Server]The data types varchar and text are incompatible in
the equal to operator.
However, tbl_id is of type VARCHAR(36) in the database, not TEXT.
I've attached a relevant section of the freetds dump file that may help
shed some light on the issue. Let me know if any other details would be
helpful.
Thanks,
Nick Davis
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: freetds.txt
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20081013/11a7a90f/attachment.txt
More information about the FreeTDS
mailing list