Mantis code authenticating with MS-SQL

[aggiedj02]

okay I am trying to run a test copy of Mantis on my XP machine using IIS, PHP, and MSSQL. the SQL Server is SQL Server 2000, and is on another full time dedicated SQL server. IIS and PHP are loaded properly on my XP box.

the Mantis code throws this error:

APPLICATION ERROR #400
Database connection failed. Error received from database was #0: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This is an authentication error, but I do not know how to fix it. I have no experience with PHP. I have coded in ASP and ColdFusion, so I am a little confused at this point. Here is my config:

$g_db_type = "odbc_mssql";

When I use just the mssql driver, I get this error:

Fatal error: Call to undefined function mssql_get_last_message() in C:\mantis\core\adodb\drivers\adodb-mssql.inc.php on line 470


Can someone help me because this ticketing system would prevetn me from having to develop my own in ASP. Thanks guys!!!

[paul]

I use the 'hostname' field as an 'connect string' concept instead e.g. something like:

Code: Select all

$g_db_type = "odbc_mssql";
$g_hostname = "Driver={SQL Server};SERVER=sqlsrv;DATABASE=localhost;UID=mantis;PWD=mantis;";

If you are looking at using mantis with mssql in production, I'd consider using the DB create routine, i'm hoping to post to http://bugs.mantisbt.org/view.php?id=5289 in a few days, rather then the .sql files which are slightly old - having said that issues 0004846/0004845 I believe contain a updated table definition

Paul

[aggiedj02]

sorry for my delayed response... I got sidetracked with other stuff at work and had to put this on the back burner.

Anyway, I tried what you said and it worked like a charm. Thank you so much. I actually feel like a dope for not knowing that, but to be honest I am more of a network administrator than a developer. I just code when needed, and like I said before, I have never touched PHP, just ColdFusion and ASP.


Thanks again... i appreciate the help