[freetds] error 778672 ...

Daniel Kasak dkasak at nusconsulting.com.au
Tue May 16 02:17:09 EDT 2006


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


More information about the FreeTDS mailing list