Page 1 of 1

Mantis, IIS and MS SQL Server 2000

Posted: 16 Nov 2005, 10:45
by DarenHawes
Hi,

I have finally got PHP running on my IIS6 box and now need to use MS SQL Server 2000 as my Database.

Is there any information on this? I have found the SQL Scripts and built the Database fine, but I get

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Mantis Bug Tracker\core\adodb\drivers\adodb-mysql.inc.php on line 338

When trying to run? Any Ideas?

Thx

MSSQL Support

Posted: 16 Nov 2005, 21:03
by p_alex
Add in config_inc.php:

$g_hostname = 'sql2000server';
$g_db_username = 'sa';
$g_db_password = 'sapass';
$g_database_name = 'bugtracker';
$g_db_type = 'mssql';

Still get errors

Posted: 16 Nov 2005, 21:49
by Daren Hawes
now I get this error..

Fatal error: Call to undefined function mssql_get_last_message() in D:\Clients\Mantis Bug Tracker\core\adodb\drivers\adodb-mssql.inc.php on line 470

I have tried both the new Login I created in MSSQL as well as the SA.

Posted: 16 Nov 2005, 23:22
by Narcissus
Sounds like you don't have your MS SQL extension for PHP set up. I don't use it myself, but a quick Google found this line:

"You probably do not have php_mssql.dll added to your extension list in your php.ini."

So either you don't have the file at all, or maybe it's not enabled in your PHP.INI file.