PHP 5 and MSSQL EXPRESS 2005 - How to setup?

Posted on 2006-07-08
Medium Priority
Last Modified: 2013-12-12
I am trying to get PHPBB2 working with PHP5 and MSSQL EXPRESS 2005 however when I run the installation script I'm getting the following error:

"The PHP configuration on your server doesn't support the database type that you chose"

How can I setup PHP so that it recognises a MSSQL EXPRESS database?

I am using XP Pro's version of IIS

This is my MSSSQL configuration in PHP.INI - No idea if I need to change anything...

; Allow or prevent persistent links.
mssql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mssql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
mssql.max_links = -1

; Minimum error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Connect timeout
;mssql.connect_timeout = 5

; Query timeout
;mssql.timeout = 60

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096

; Limits the number of records in each batch.  0 = all records in one batch.
;mssql.batchsize = 0

; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1

; Specify client character set.
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
;mssql.charset = "ISO-8859-1"

; Assert(expr); active by default.
;assert.active = On

; Issue a PHP warning for each failed assertion.
;assert.warning = On

; Don't bail out by default.
;assert.bail = Off

; User-function to be called if an assertion fails.
;assert.callback = 0

; Eval the expression with current error_reporting().  Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0

[Verisign Payflow Pro]
; Default Payflow Pro server.
pfpro.defaulthost = "test-payflow.verisign.com"

; Default port to connect to.
pfpro.defaultport = 443

; Default timeout in seconds.
pfpro.defaulttimeout = 30

; Default proxy IP address (if required).
;pfpro.proxyaddress =

; Default proxy port.
;pfpro.proxyport =

; Default proxy logon.
;pfpro.proxylogon =

; Default proxy password.
;pfpro.proxypassword =
Question by:georgecooldude
  • 2
LVL 12

Expert Comment

ID: 17078856
Where is your mssql.dll module loaded at?


uncomment that line first.

Author Comment

ID: 17083571
I just installed it to d:\program files

Do I need to change anything else?
LVL 12

Accepted Solution

GinEric earned 2000 total points
ID: 17096759
Read the setup files, uncomment certain lines in php.ini

If you use mysql you will also have to uncomment the



IIS will have to include the directory where you installed php5

You've done it rather the hard way, using Program Files, a dastardly directory.  You're better off putting things in specific places, like D:\PHP5 for php, and so on.

Then you'll be able to find and adjust the entire structure, rather than weed through a million programs installed under Program Files.

php.ini would be in D:\PHP5 and easier to find and fix, unless your install put it under C:\Windows\

IIS where you specify the php5 directory will also need execute permissions I think.  Also, go get phpMyAdmin and make the job easier.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article discusses how to create an extensible mechanism for linked drop downs.
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question