[Help]small issue in admin panel

[knifeman92]

when i set it up i get these errors...

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:\wamp\www\AdminPanel\index.php on line 61

Warning:  mssql_query() [function.mssql-query]: Query  failed in C:\wamp\www\AdminPanel\index.php on line  61

Warning: mssql_num_rows(): supplied argument is not a  valid MS SQL-result resource in C:\wamp\www\AdminPanel\index.php on line  62

how would i fix this error...or errors.

[MentaL]

[Omer]

Added you a Tag don't do it again.

[Keith]

This is GUNZ server section not support on other misc items that was created, closed.

[RepublicOfAstra]

His error is on a Gunz site he created.

I don't have a solution, but I'm re-opening this thread.

[Rotana]

I have the same problem with some mssql querys.
I'm looking for an solution.

[Rotana]

I found an solution for it.

The problem is when you use SELECT * From Account You will have sometime an error, like severity 16 .

Example normale:

?>
    - Accounts: <strong>
    <?php require 'config.php';
	$query = mssql_query("SELECT * FROM Accounts");
$num_rows = mssql_num_rows($query);
echo "$num_rows";?>

Example to solve this issue

?>
    - Accounts: <strong>
    <?php require 'config.php';
	$query = mssql_query("SELECT AID, UserID FROM Accounts");
$num_rows = mssql_num_rows($query);
echo "$num_rows";?>

To solve the issue with the admin panel, just look to your code and replace the * with the coloms you need

I hope this is helpfull for you

[marcelinni]

kay, ell you have to be running through sql server authentication mode. to make it work, in installation click the mixed mode wen u install sql server 2005 express edition (not the managemtn studio). it will ask you either windows authentication or sql server authentication. click on sql server auth. then, wen u login to windows authentication. right click on your the thing above you databases ----------



i hope that helped. now in ur config.php put ur sa and password in it and the name of ur db, for example my db is ''GunzDB'', put the EXACT name so that it registers users to it. i got liek 5 sites worin gand im gonna hsot my main one. after i ameka new template and add more optons.

[knifeman92]

ty the info helped.