Skip to Content.
Sympa Menu

freetds - RE: [freetds] Using sp_executesql with Microsoft SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Using sp_executesql with Microsoft SQL Server 2000
  • Date: Tue, 1 Jul 2003 14:32:59 +0200

> >
> > 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




Archive powered by MHonArc 2.6.24.

Top of Page