[freetds] ct_dynamic()/ct_param() support

ZIGLIO Frediano Frediano.Ziglio at vodafone.com
Mon Oct 13 19:03:44 EDT 2003


> 
> On Sun, 2003-10-12 at 22:07, James K. Lowden wrote:
> > On Sun, 12 Oct 2003 23:33:35 -0400, "Mark J. Lilback" 
> > <mark at lilback.com>
> > wrote:
> > > At 10:20 AM -0700 10/12/03, Michael Peppler wrote:
> > > >Thanks - I looked at the code a little, and it *appears* 
> that RPCs 
> > > >are supported. After two small patches (one to support 
> CS_NULLTERM 
> > > >as the datalen parameter) I got the code to "work" - but 
> it crashes 
> > > >the MSSQL 2k server that I've got running here (the 
> server crashes 
> > > >*hard*!).
> > > 
> > > I spent a good bit of time trying to get this to work, but the
> > > problem is that TDS 7 does not support sending 
> parameters, but TDS 5 
> > > does.
> > > 
> > 
> > TDS 5.0 supports parameters in the protocol with TDS_DYNAMIC & Co.  
> > TDS 7.0 goes a completely different route, using extended stored 
> > procedures e.g. sp_executesql.
> 
> Ugh!
> 
> OK - I see. I think I'll leave this as it is for now, and add 
> some functionality to DBD::Sybase (and a possibly upcoming 
> DBD::FreeTDS) to enable functionality depending on the 
> version of FreeTDS that it is linked with.
> 
> Michael

FreeTDS support already sp_prepare/sp_execute/sp_unprepare calls (using
tds_submit_prepare, tds_submit_execute, tds_submit_unprepare). We have
some problem with Sybase and blob fields. ct_dynamic is planned for
0.62... I think you just want prepare/execute/unprepare type, not
cursors and others (I readed a bit ct_dynamic documentation on Sybase
site).

freddy77


More information about the FreeTDS mailing list