FreeTDS Development Group

[John Jones <john AT iigi.net>]

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