FreeTDS Development Group

["Bort, Paul" <pbort AT tmwsystems.com>]

Does DBD::ODBC support placeholders? Older versions of DBD::Sybase
didn't. You might want to test the insert wihtout any placeholders and
see if the message changes.

Regards,
Paul 

> -----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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>