|
|
Posted by Matthew Weier O'Phinney on 07/24/05 06:41
* "Chris Boget" <chris.boget@wild.net>:
> I'm using PEAR::DB to connect to a MS SQL Server 2000.
> I'm attempting to run the following query:
>
> SELECT * FROM myTable FOR XML AUTO, ELEMENTS
>
> When I run the above query using the Query Analyzer, I get back
> the results as expected. However, when I try to run the same query
> using PEAR, I get the following error:
>
> [nativecode=4004 - 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.]
>
> and I'm not sure why. I've googled the error and see that alot of
> other people are getting the same error (though, it doesn't seem
> that they are necessarily using PEAR). From what I can tell, it is
> a client error and not a server error. So my questions are 1) is
> there something wrong with PEAR and 2) if so, is there a fix in
> the works? Does anyone know? But that aside, has anyone else
> come up against this issue and found a workaround using PEAR?
You should probably post this to php-pear-general, or to the pear-dev
list. If no response there, or if no solutions are forthcoming, file a
bug report with PEAR::DB. PEAR::DB *is* under active maintainership,
from what I can tell, and some of the more recent changes had to do with
MS-SQL report, if memory serves.
Good luck!
--
Matthew Weier O'Phinney
Zend Certified Engineer
http://weierophinney.net/matthew/
Navigation:
[Reply to this message]
|