Skip to Content.
Sympa Menu

freetds - RE: beginner: unicode error, coulnt exec query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: beginner: unicode error, coulnt exec query
  • Date: Fri, 27 Sep 2002 07:04:56 +0100


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')





Archive powered by MHonArc 2.6.24.

Top of Page