Skip to Content.
Sympa Menu

freetds - Re: placeholders in TDS 7.0?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: wsheldah AT lexmark.com
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: placeholders in TDS 7.0?
  • Date: Tue, 26 Mar 2002 09:57:56 -0500




Ok, thanks for confirming. One reason I'm using freetds is to avoid having to
ask anyone to do anything on the Windows machine to enable communication, and
I
believe DBD::ODBC would require them to run DBD::Proxy. Since I'm only doing
lookups in a couple of tables, I'll either handle quoting manually or use
$dbh->quote(). Thanks,

Wes



Brian Bruns <camber%ais.org AT interlock.lexmark.com> on 03/24/2002 09:31:00 AM

Please respond to "TDS Development Group"
<freetds%franklin.oit.unc.edu AT interlock.lexmark.com>

To: "TDS Development Group"
<freetds%franklin.oit.unc.edu AT interlock.lexmark.com>
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [freetds] Re: placeholders in TDS 7.0?



The message is true, placeholders are only supported under TDS 5.0 (and
even then support is flakey). For placeholders with TDS 7.0, I'd
recommend trying out DBD::ODBC which supports a bind column type option.

Brian

On Fri, 22 Mar 2002 wsheldah AT lexmark.com wrote:

>
>
> Hi,
>
> I'm using freeTDS to access MS SQL Server 2000 from a perl module running on
an
> intel linux box, via DBD::Sybase. freeTDS was compiled to use TDS 7.0.
>
> The problem is when I execute a simple query that has a placeholder, like
> "select name from mytable where id=?" in perl, I get the following error
> message:
> "Dynamic placeholders only supported under TDS 5.0"
>
> Are they truly not supported under TDS 7.0, or should the test be changed to
> check for TDS versions less than TDS 5.0 instead of only equal to TDS 5.0?
> Any
> specific patches available, and if not, would this be safe for me to patch
> directly? Thanks again,
>
> Wes Sheldahl
>
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>


---
You are currently subscribed to freetds as: [wsheldah AT lexmark.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')










Archive powered by MHonArc 2.6.24.

Top of Page