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

Daniel Kasak dkasak at nusconsulting.com.au
Tue May 16 19:19:05 EDT 2006


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


More information about the FreeTDS mailing list