Hi,
regarding this website I get the following error after calling the website:
Code:
PHP Fatal error: Uncaught TypeError: odbc_result(): Argument #1 ($statement) must be of type resource, bool given in C:\inetpub\wwwroot\website\includes\xinc_config.php:73
Stack trace:
#0 C:\inetpub\wwwroot\website\includes\xinc_config.php(73): odbc_result()
#1 C:\inetpub\wwwroot\website\index.php(4): require_once('...')
#2 {main}
thrown in C:\inetpub\wwwroot\website\includes\xinc_config.php on line 73
Line 73:
Code:
$_CONFIG['allg_user_online'] = @odbc_result(@odbc_exec($odbc_connect, 'SELECT COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0'), 'OnlineCount');
I mean, obviously the type of argument it's expecting doesn't match, but dunno how to fix it.
Do you know what's the issue here is?
Solution:
- deleting the "@"s of "odbc_result" method (suppressed the detailed message)
- added a new user on SQL Management Studio at "Security"-Folder and added to the IIS ApplicationPool Website
- turned newly created user to "owner" of the databases