[freetds] Using sp_executesql with Microsoft SQL Server 2000

ZIGLIO Frediano Frediano.Ziglio at vodafone.com
Tue Jul 1 15:32:59 EDT 2003


> > 
> > Has anyone on the freeTDS team looked at using sp_executesql in 
> > freeTDS for parameter passing using freeTDS with Microsoft 
> SQL Server 
> > 2000?
> ...
> > I'm working on an optional perl only extension to DBD::Sybase that 
> > will allow me to do '?' based parameter passing using this 
> technique, 
> > but am wondering if anyone has looked a lower level interface.
> 
> DBD::Sybase uses ct-lib.  I think current ct-lib in CVS 
> supports '?' placeholders via ct_send_dyn().  I don't know 
> how well it works.  I don't see a unit test for it, and it 
> hasn't been crossed off the TODO.  In any case, all the hard 
> parts are done in libtds, and placeholders work at least 
> somewhat in ODBC.  
> 
> Frediano reverse engineered the TDS 7.0 protocol for dynamic 
> SQL.  IIRC, his work is based on the RPC protocol.  It 
> doesn't look like he uses sp_executesql.  I don't know why; I 
> don't recall any discussion about it.  I wonder if he ever 
> came across it in his traces.  
> 

?? Code in in CVS since a month... in query.c (search
"s\0p\0_\0e\0x\0e\0c\0u\0t\0e\0s\0q\0l").
I think only ct-lib can use this stuff and I don't know if it work
well...

bye


More information about the FreeTDS mailing list