Skip to Content.
Sympa Menu

freetds - Problem with text (blob) field

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Jones <john AT iigi.net>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Problem with text (blob) field
  • Date: Fri, 24 Aug 2001 12:34:06 -0400


Help!

I am using FreeTDS and DBI (DBD::Sybase) with the 4.2 version of the
protocol to talk to an MSSQL 6.5 database from a RH7.1 machine.


Everthing works fine with reading and writing to/from the database until
I go to write to a Text/Image (aka "Blob") field.


Here is my code:

$dbh = DBI->connect( "dbi:Sybase:server=dbdaddy", "webuser",
"xxxxxxxx", {LongReadLen=>64000, LongTruncOk=>1} )
|| bail("Connect Error: $DBI::errstr");
$dbh->do("use Vibe");

# ... more code here and there...

$sqlstatement = "update vibe set images = 'abcd' where spid_mid =
$userid and date_entered = $date";
$sth = $dbh->prepare($sqlstatement) || bail("Prepare Error:
$DBI::errstr");
$sth->execute() || bail("$DBI::errstr");

I was trying to write out an image or some MIME encoded text, for a
while I thought that was the problem. Then I went to write something
simple like 'abcd' and found I could not do that either.

Should this code work? The error I am getting is this:

DBD::Sybase::st execute failed: Server message number=170 severity=15
state=1 line=1 server=dbdaddy text=line1: Incorrect syntax near '15'. at
.... (blah blah blah)

Any ideas? Is this even a FreeTDS problem? Or a DBD problem?

Thanks.

-John Jones







Archive powered by MHonArc 2.6.24.

Top of Page