freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Warning: Sybase: Server message

From: Mark Par <markp AT ispbonanza.com.ph>
To: FreeTDS Mailing List <freetds AT lists.ibiblio.org>
Subject: [freetds] Warning: Sybase: Server message
Date: Thu, 6 Nov 2003 01:34:35 +0800

Hi,

Why does this query "SELECT * FROM Northwind.dbo.Categories" fail?
The query emits this:

Warning: Sybase: Server message: 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, procedure
N/A) in /home/markp/public_html/test.php on line 8

The php script:

<html>
<body>

<?php

$con = sybase_connect("server", "uname", "pword")
or die("Can't connect.\n");
$res = sybase_query("SELECT * FROM Northwind.dbo.Categories")
or die("Bad query");
print "Number of rows fetched: " . sybase_num_rows($res);

?>

</body>
</html>

I'm using PHP/4.1.2 + FreeTDS/0.53.1.

Thanks.
--
Real (wo)men use *UNIX*

[freetds] Warning: Sybase: Server message, Mark Par, 11/05/2003
- Re: [freetds] Warning: Sybase: Server message, James K. Lowden, 11/06/2003