and also sybase support will do the job w/o using freetds... you use mssql queries
-----Original Message----- From: Mark Par [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 8:28 AM To: Philippine Linux Users Group Mailing List Subject: [plug] PHP/FreeTDS/MSSQLServer2000 problem 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 -- 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
