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...


------------------------------------------------------
[MSSQL]
; 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"

[Assertion]
; 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 =
------------------------------------------------------
LVL 5
georgecooldudeAsked:
Who is Participating?
 
GinEricCommented:
Read the setup files, uncomment certain lines in php.ini

If you use mysql you will also have to uncomment the

extension=php_mysql.dll

line.

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.
0
 
GinEricCommented:
Where is your mssql.dll module loaded at?

extension=php_mssql.dll

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

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