Skip to Content.
Sympa Menu

freetds - RE: [freetds] Perl freetds SqlServer Stored Procedures

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Perl freetds SqlServer Stored Procedures
  • Date: Fri, 07 Nov 2003 10:11:30 -0800

On Thu, 2003-11-06 at 08:20, Lowden, James K wrote:
> > From: Vendetti, Jeff [mailto:Jeff.Vendetti AT FMR.COM]
> > Sent: November 6, 2003 9:10 AM
> >
> > I've got freetds 0.61.2, running Perl 5.6.1, using
> > DBD::Sybase 1.01 and all
> > works fine when I access MS SqlServer 2000!
> >
> > Does anyone know if I'm able to call SqlServer 2000 Stored
> > Procedures from within Perl using this setup?
>
> Of course! Just stuff "execute <procname>" into your command string, and
> off you go.

What does NOT work yet, AFAIK, is using ?-style placeholders with the
EXEC call, i.e.:

$sth = $dbh->prepare("exec my_proc ?, ?, ?");
$sth->execute(1,2,3);

will NOT work (yet).

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html




Archive powered by MHonArc 2.6.24.

Top of Page