FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Boyke,

First up, welcome to FreeTDS. It's good to have you aboard!

I've not seen this error message before. However I can confirm it is  a
valid SQL Server message, message number 4004, actually. There's a
discussion on dbforums from someone with a similar problem, although they
weren't using FreeTDS...

http://dbforums.com/archive/70/2001/12/4/239540

It looks to me like you're accessing a column type of "ntext" or one of the
other unicode datatypes on the SQL server. It would not entirely surprise me
if we had a problem or two with that.

Which api have you configured PHP to use ? dblib ctlib or odbc ?
Can you get a tds dump log file from your session ? Here's how.

http://www.freetds.org/userguide/x2052.htm 

Good Luck!

Bill


> -----Original Message-----
> From: Haany Boyke [SMTP:bhaany AT yahoo.com]
> Sent: Friday, September 27, 2002 12:45 AM
> To:   TDS Development Group
> Subject:      [freetds] beginner: unicode error, coulnt exec query
> 
> hi,
>  i am trying to use freetds so i can acces my ms-sql
> server database from my php in linux. I already
> installed everything, and it seems the connection is
> working. But when i try to run a query on it, it
> displays the warning sign:
> Warning: Sybase error: Unicode data in a Unicode-only
> collation or ntext data cannot be sent to clients
> using DB-Library (such as ISQL) or ODBC version 3.7 or
> earlier. (severity 16) in
> /home/haany/public_html/admin/dbmssql.php on line 13
> 
> Warning: 0 is not a Sybase result index in
> /home/haany/public_html/admin/dbmssql.php on line 14
> 
> the tds version is 0.60
> my apache version is apache_1.3.26.tar.gz
> and my php version is php-4.2.3.tar.gz...
> the mssql that i tried to connect to is ms-sql 7.0
> please help...:)
> 
> thanks..
> 
> boyke
> 
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')