[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