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 17:25:48 -0700 (PDT)


if it is because of my odbc driver that old, anyone
now how to get a new odbc driver to linux and how to
install it so it can be used by the tds?
I am not allowed to change the mssql field ntext into
text...

thanks

boyke
--- Haany Boyke <bhaany AT yahoo.com> wrote:
> 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
>
> ---
> 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