Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (nike.apache.org: domain of adam.prime@utoronto.ca
 designates 128.100.132.18 as permitted sender)
Message-ID: <20071128200629.s8scv4s67fv40w48@webmail.utoronto.ca>
Date: Wed, 28 Nov 2007 20:06:29 -0500
From: adam.prime@utoronto.ca
To: modperl@perl.apache.org
Subject: Re: DBD::Sybase / freetds / Apache::DBI / ?
References: <20071128181244.7im4s3vkg8sgc4c4@webmail.utoronto.ca>
In-Reply-To: <20071128181244.7im4s3vkg8sgc4c4@webmail.utoronto.ca>
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1;
	DelSp="Yes";
	format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: 8BIT
User-Agent: Internet Messaging Program (IMP) H3 (4.1.4)

This turned out to just be a misconfiguration more than anything else.  
  the dsn was getting changed by some rogue code, and as a result it  
wasn't defined in the freetds.conf, however, the new servername  
resolved fine through DNS so it still connected ok.  The problem was  
that it defaulted to using the default TDS level of 4.2, which doesn't  
support ntext.

bleh.

Adam

Quoting adam.prime@utoronto.ca:

>
> We have a long standing problem pulling data from ntext fields in a
> server running MSSQL 2000, which i always assumed was a problem with
> freetds and or DBD::Sybase.
>
> However, I've actually done some investigation today, and i've
> discovered that the particular code that's causing problems actually
> runs fine at the command line, as well as under plain CGI.  However,
> it blows up when running in mod_perl.  I'm about to attempt to reduce
> this down to a simple case, but if anyone has any ideas, i'd love to
> here them.
>
> basically what happens is whenever i run a query that pulls an ntext
> field, i get this:
>
> 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.
>
> the freetds.conf for the DB is like this:
>
> [clients]
>      host = ...
>      port = 1433
>      tds version = 8.0
>      client charset = CP1252
>
> We're running freetds 0.64, and DBD::Sybase 1.08.
>
> Any ideas would be appreciated (and no i can't just change the fields
> to not be ntext)
>
> Adam
>
>