Admin detecting MS SQL Server...

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
nasserd
Posts: 2
Joined: 18 Feb 2005, 14:11

Admin detecting MS SQL Server...

Post by nasserd »

Hi,

I have set-up Mantis to use MS SQL Server (2000), and all seems well; however, I cannot get Mantis to look for and use the SQL Server.

How do I do that? Is there a particular configuration required? Will Mantis detect between MySQL and MS-SQL?

Thanks.
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Post by thraxisp »

Not automatically. You need to configure it by setting "$g_db_type = 'mssql';" .
hestevan
Posts: 2
Joined: 03 Oct 2007, 17:21

Post by hestevan »

I set-up mantis to use SQL Server in config_inc.php with this configuration:

$g_hostname = 'bsbserv029:1433';
$g_db_type = 'mssql';
$g_database_name = 'mantis_rt';
$g_db_username = 'mantisuser';
$g_db_password = 'mantisfproj';

When i try access in mantis it show me the message: "PHP Fatal error: Call to undefined function mssql_get_last_message() in D:\Dados\Inetpub\wwwrootmantisfproj\revisao_tecnica\core\adodb\drivers\adodb-mssql.inc.php on line 470 "

What i'm doing wrong? Can anyone help me?

When i check my installation in item: "Checking PHP support for database type" the aswer is: "BAD - database is not supported by PHP. Check that it has been compiled into your server."

I'm using the version PHP 5.2.0.

Thanks
Post Reply