[freetds] ***POTENTIAL SPAM*** error 778672 ...

Bob Hetzel beh at case.edu
Wed May 17 09:08:49 EDT 2006


When the prepare succeeds but the execute fails in my perl programs, 
it's always been because of a bad syntax, most likely due to a 
character that confuses the perl interpreter (i.e. a value you need 
to escape before it can be combined in perl code).

Check for and escape all the special perl characters like $, @, &, 
single quotes, double quotes, the backslash character, (, ), [, ], etc.

     Bob

> >>
> >> 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?
> >>
> >>
>



More information about the FreeTDS mailing list