FreeTDS Development Group

[Daniel Kasak <dkasak AT nusconsulting.com.au>]

Bort, Paul wrote:

> Does DBD::ODBC support placeholders? Older versions of DBD::Sybase
> didn't.

Yes it does. I moved from DBD::Sybase to DBD::ODBC so I could make use 
of placeholders. I've been relatively successful, but this simple insert 
query has be stumped.

> You might want to test the insert wihtout any placeholders and
> see if the message changes.
>   

Unfortunately that's not an option. I'm using a fair bit of abstraction 
to get the job done, and using placeholders is buried quite deep into my 
tools.

> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org 
> > [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Daniel Kasak
> > Sent: Tuesday, May 16, 2006 2:17 AM
> > To: freetds AT lists.ibiblio.org
> > Subject: ***POTENTIAL SPAM*** [freetds] error 778672 ...
> > Importance: Low
> >
> > Greetings.
> >
> > I'm using freetds-0.64 and DBD::ODBC-1.13 to talk to SQL 
> > Server 7 from Perl.
> >
> > I'm doing a simple insert:
> >
> > my $sth = $dbh->prepare(
> > "insert into Contacts (  Salutations, FirstName, LastName, 
> > Title, Area, 
> > PhoneSTD, PhoneNo, FaxSTD, FaxNo, Mobile, Email, BulkEmail, BillID ) 
> > values (  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ) || die 
> > $dbh->errstr;
> >
> > $sth->execute( @values ) || die $dbh->errstr;
> >
> > It dies on the execute line:
> >
> > [unixODBC][FreeTDS][SQL Server]RAISERROR could not locate entry for 
> > error 778672 in sysmessages. (SQL-42000)(DBD: 
> > st_execute/SQLExecute err=-1)
> >
> > There's nothing surprising in the data - each element of the 
> > array has a 
> > non-NULL value etc. Does anyone know what this error is? Is 
> > there some 
> > place I should look for this error myself?
> >
> >     


--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak AT nusconsulting.com.au
website: http://www.nusconsulting.com.au