[freetds] DBD::Sybase placeholder support
Dan Wierenga
dwierenga at valueclick.com
Wed May 14 19:58:49 EDT 2008
> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org [mailto:freetds-
> bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
> Hi Dan,
>
> OK. If you get a chance to try output parameters of type string, int,
> and
> float, I'd be very interested.
I've attached the TDSDUMP logs for stored procs that have datetime, int,
float, and varchar output params, as well as my mini-suite of tests. I
ran them against both Sql Server 2000 and SQL Server 2005, with the 0.64
codebase and the 0.82 codebase, for TDS protocol versions 4.2, 7.0, 8.0,
and 9.0.
Since there's a ton of stuff in my attachments I'll give a quick
summary:
- output params are broken for TDS 7.0 and 8.0 in both 0.64 and 0.82
- output params work for TDS 4.2 and 9.0 for the 0.64 codebase
- output params work for TDS 4.2 for the 0.82 codebase
- TDS 9.0 throw connect errors for the 0.82 codebase (ugh.. see the
do_tests.errors file)
>
>
> Thanks for your work. Would you be interested in perfecting ct-lib
vs.
> DBD::Sybase, i.e. making all the unit tests pass?
Absolutely, though I'm not exactly sure what needs to be done. I assume
you're talking about the unit tests that come with DBD::Sybase?
One thing I did notice was that in order to get DBD::Sybase to build I
had to add these lines to cspublic.h:
#define BLK_VERSION_120 CS_VERSION_100
#define BLK_VERSION_125 CS_VERSION_100
#define BLK_VERSION_150 CS_VERSION_100
I adapted the advice from posts like this et al.
http://lists.ibiblio.org/pipermail/freetds/2008q1/023098.html
I'm not enough of a C programmer to know if that's the "right" place to
fix it, but it got the job done.
-Dan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tests.tgz
Type: application/x-compressed
Size: 1201 bytes
Desc: tests.tgz
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080514/e30a8f3e/attachment-0003.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0.64_results.tgz
Type: application/x-compressed
Size: 17889 bytes
Desc: 0.64_results.tgz
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080514/e30a8f3e/attachment-0004.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0.82_results.tgz
Type: application/x-compressed
Size: 25586 bytes
Desc: 0.82_results.tgz
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080514/e30a8f3e/attachment-0005.bin
More information about the FreeTDS
mailing list