Solved

PHP 5 and MSSQL EXPRESS 2005 - How to setup?

Posted on 2006-07-08
5
1,304 Views
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...


------------------------------------------------------
[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 =
------------------------------------------------------
0
Comment
Question by:georgecooldude
  • 2
5 Comments
 
LVL 12

Expert Comment

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

extension=php_mssql.dll

uncomment that line first.
0
 
LVL 5

Author Comment

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

Do I need to change anything else?
0
 
LVL 12

Accepted Solution

by:
GinEric earned 500 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

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

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

840 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