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: Haany Boyke <bhaany AT yahoo.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: RE: beginner: unicode error, coulnt exec query
  • Date: Mon, 30 Sep 2002 11:51:19 -0700 (PDT)


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




Archive powered by MHonArc 2.6.24.

Top of Page