[freetds] ctlib vs. dblib vs. tds

Patrick Dunnigan patrick.dunnigan at centivia.com
Fri Mar 25 10:57:04 EST 2005


Hi All,
I've been using DBD:Sybase -> freeTDS -> MSSQL 2000 for three years now. I've been porting some of the code to C recently and am basically cutting the Perl piece out.

My questions are: what are the major differences between ctlib, dblib, and using the code under src/tds?

My guess is that the ctlib and dblib use the tds libs, but haven't seen much mention of this. 

I've tried out both the ctlib and tds piece on it's own, and am considering trying out the dblib. 

Why would I pick one over the other?

Lastly, which is most likely to support 2005 use?

I'd like to use placeholders and bulkcopies and text fields. I didn't have much success with the Bulk Copies for TEXT or placeholders in ctlib. I didn't see any references to bulk in the TDS code but the placeholders worked ok (as long as it's not a text field insert). That's why I'm now considering trying out dblib, but I have concern that this lib won't be supported in the future.

Thanks,
Patrick


More information about the FreeTDS mailing list