MSSQL error

Databases
1

Hi there I am getting the follwoing error and I am not sure what the error means…can anyone help?

Thanks

[B]Warning: mssql_query() [function.mssql-query]: 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) in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 7

Warning: mssql_query() [function.mssql-query]: Query failed in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 7

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\Inetpub\wwwroot\zycko_2007\06\admin\cms2.php on line 9[/B]

<? 
session_start();

include "../../connect.inc.php";

$query="SELECT * FROM zycko_products.dbo.cms_pages";
$result=mssql_query($query);

while ($array=mssql_fetch_assoc($result)) {

echo $array['domain']."<br>";

}

?>
2

Hi, Have a look at http://php.net/manual/en/function.mssql-query.php and sepcifically the user notes:

Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library

solution:
try: select field from table, avoid “select * from table” php will scream at you. strangely after executing select field from table you’ll be able to execute select * from table.

i’m using apache2, win XP, sqlexpress05

Doing a select * for anything is a massive no no - select the fields you want not the whole caboodle!

3

Hi there I tried this and it still produces the same error, even when I just select the field I am interested in.


<? 
session_start();

include "../../connect.inc.php";

$query="SELECT content  FROM zycko_products.dbo.cms_pages";
$result=mssql_query($query);

while ($array=mssql_fetch_assoc($result)) {

echo $array['content']."<br>";

}

?>