Hi *,
I am trying to query some records on my linux box using PHP from an
MSSQL Server 2k, my problem is, when I call mssql_query() with the
argument "SELECT * FROM dbo.table", I get an error message:
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-mssql.php on line 18
I do not get this error when I call it with "SELECT fld0 FROM
dbo.table". Anyone who had this problem?
Here's the complete script:
<?php
$ms_con = mssql_connect("server", "name", "password") or
die("mssql_connect(): Can't connect to server.\n");
$res = mssql_query("SELECT * FROM dbo.table", $ms_con) or
die("mssql_query(): Wrong query.\n");
while ($arr = mssql_fetch_row($res)) {
print $arr["fld0"] . " " . $arr["fld1"] . "\n";
}
?>
The software I use
+ client side
* PHP/4.1.12 --with-sybase-ct linked against FreeTDS/4.0.4.5rc6-3
* Debian GNU/Linux 3.0 (woody)
* Apache/1.3.26
+ db side
* MSSQL Server 2000
--
Real men use *UNIX*
--
Philippine Linux Users' Group (PLUG) Mailing List
[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
