FreeTDS Development Group

[Haany Boyke <bhaany AT yahoo.com>]

i tried to export the log environment variable, but
the log file was never created when i try to
connect...
And you're right about the ntext. When i try to get
non-ntext variable it works....
i dont know which api i use to configure the php, i
guess its the default one...
...confused...

thanks..

boyke
--- "Thompson, Bill D (London)"
<ThompBil AT exchange.uk.ml.com> wrote:
> 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')
> 
> 
> ---
> You are currently subscribed to freetds as:
> [bhaany AT yahoo.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com