[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