PHP 5 and MSSQL EXPRESS 2005 - How to setup?

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.
; = 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 = ""

; 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 =
Who is Participating?
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.
Where is your mssql.dll module loaded at?


uncomment that line first.
georgecooldudeAuthor Commented:
I just installed it to d:\program files

Do I need to change anything else?
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.

All Courses

From novice to tech pro — start learning today.