Solved

PHP 5 and MSSQL EXPRESS 2005 - How to setup?

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

831 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