Skip to Content.
Sympa Menu

freetds - Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Kasak <dkasak AT nusconsulting.com.au>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...
  • Date: Wed, 17 May 2006 09:19:05 +1000

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




Archive powered by MHonArc 2.6.24.

Top of Page