Skip to Content.
Sympa Menu

freetds - [freetds] TDS wants to show me raw hex via PHP from MSSQL2k

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Eddie Johnson <fast_eddie_007 AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] TDS wants to show me raw hex via PHP from MSSQL2k
  • Date: Tue, 5 Aug 2003 13:50:22 -0700 (PDT)

Trying to pull an Image field from MSSQL2000 ( i know bad idea fromt the
start...not my choice )
Can get it to echo out as hex characters, but that looks a bit goofy.

It works fine via an ODBC connection. But FreeTDS wants to just show it as is.
Header is set. what am i missing??? I am running it as version 8.0 in the
freetds.conf file

here is my code so far
-- begin code
$sql = " select imLarge from image where cCompanyID = '10CC-EAFH-6E59' and
ititlenum = $id ";
// echo "sql is $sql for now";
$dbh= mssql_connect( $db , $user , $pass );
$dbr = mssql_query( $sql , $dbh );
$row = mssql_fetch_array($dbr) ;
Header( "Content-type: image/jpeg" );

?>
<img src="<? echo $row['imLarge']; ?>" >

-- end code.

so it works fine on ODBC, but not via FreeTDS. Have scoured the net for
someone
who is doing this very silly idea. but no luck. And am getting cross eyed
reading old listing posts. And the searchable archive has been offline for
about 3 days now.

Obi-Wan you are our only hope.....

Thanks,
Eddie




Archive powered by MHonArc 2.6.24.

Top of Page