calling sp_password store procedure failed
mpeppler at peppler.org
Fri Jul 27 18:46:11 EDT 2001
Bob Kline writes:
> On Fri, 27 Jul 2001, Michael Peppler wrote:
> > Bob Kline writes:
> > > On Fri, 27 Jul 2001, Michael Peppler wrote:
> > > > The protocol doesn't handle this natively (at least I don't think
> > > > so), so the driver would have to handle this itself.
> > >
> > > If by protocol you mean TDS, yes.
> > Do you mean that TDS supports placeholders for stored proc calls?
> > If so does it query the server to check for datatypes, quoting, etc?
> > (the Sybase C API doesn't handle this)
> I'm not the most knowledgable on the TDS protocol, so I'm fairly
> confident someone will step in and correct anything I mangle, but off
> the top of my head the answer to your first question is yes, TDS does
> support placeholders for stored procedure calls.
Thanks for the explanation.
The C API for placeholders lets you pass the SQL statement with the ?
(eg "select ... from foo where bar = ?") to ct_dynamic(), and you then
query the server to get the datatype for the parameter to pass. What
you are describing, I think, is what corresponds to the CS_RPC_CMD
request type in C - I've added this to the DBD::Sybase perl driver,
which when it sees "exec some_proc ?" will convert this from
CS_LANG_CMD to a CS_RPC_CMD and process the parameters via ct_param()
So I *think* we are talking about the same thing.
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler at peppler.org - mpeppler at mbay.net
International Sybase User Group - http://www.isug.com
More information about the FreeTDS