perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: DBD::Sybase / freetds / Apache::DBI / ?
Date Thu, 29 Nov 2007 01:06:29 GMT
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.




> 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

View raw message