|
|
Posted by "Chris Boget" on 07/23/05 15:58
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?
thnx,
Chris
Navigation:
[Reply to this message]
|