[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