View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0011497mantisbtdb mssqlpublic2010-02-12 09:572014-05-16 15:00
Reporterjeckyll Assigned Todregad  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
PlatformIIS 6.0/PHP 5.3.1OSMicrosoft Windows Server 2003OS VersionSP2
Product Version1.2.0rc2 
Summary0011497: Connection issue with SQL Server (PHP 5.3)
Description

The problem occurs when Mantis est installed with a SQL Server database and PHP 5.3.
The new MSSQL provider for PHP 5.3 use sqlsrv_connect instead of mssql_connect.
It seems that Mantis doesn't use this new function. As a result Mantis cannot connect to the SQL Server database.

This can be seen when you run <my_mantis_site>/admin/install.php. Mantis displays
"database is not supported by PHP" when checking PHP support for database type. This is because the function db_check_database_support() in database_api checks that mssql_connect() exists.

Steps To Reproduce

--> The test "Checking PHP support for database type" fails (error "BAD
database is not supported by PHP. Check that it has been compiled into your server.")

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0011776 closeddregad Support for Sql Server Native driver (sqlsrv) 

Activities

sima

sima

2010-10-12 13:15

reporter   ~0027013

Hello, may i ask, this bug will be fixed?
jeckyll

jeckyll

2011-01-03 12:06

reporter   ~0027787

It may be fixed by 0011776
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040381

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul