Solved

Configuring WAMP (Windows/Apache/MSSQL/PHP) environment

Posted on 2006-11-10
8
7,112 Views
Last Modified: 2010-10-14
Hi,

I have used MySQL for a long time in the WAMP setup but am unsure how I go about getting the WAMP setup with MSSQL.

This is probably an easy solution but a simple step through guide would be much appreciated.
0
Comment
Question by:bisleyboy
  • 4
  • 3
8 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 250 total points
ID: 17913152
Hi,

The Windows, Apache and PHP installation stuff remains the same - for the mssql you just need to install it then for php to run

" The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools."

then enabling this library in the php.ini file

http://au3.php.net/mssql

and then using the mssql functions inside php rather than the mysql ones (most are pretty similar)
0
 

Author Comment

by:bisleyboy
ID: 17913477
do i not need to reconfigure it or is that just for the unix/linux installations?
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 17913508
thats only for *nix installations

in fact you can have WAMP and also have mssql on the same server
0
 

Author Comment

by:bisleyboy
ID: 17913520
aah ok - didnt realise that it was this easy - The thing that was throwing me was that there was no MS SQL section like there is a MySQL section in phpinfo();
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:bisleyboy
ID: 17913789
Fatal error: Call to undefined function: mssql_connect() in C:\web\mssql.php on line 2

not sure everything is as it should be. Various bits and pieces I have noticed are detailed below - hope this helps in some way!

<<php.ini>>
extension_dir = "./"
...
;extension=php_mime_magic.dll
;extension=php_ming.dll
extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_oci8.dll
<<php.ini>>

php_mssql.dll is in the php folder (c:\php) as is the ntwdblib.dll (it's also in c:\windows\system32 || version 2000.2.8.0)

I noticed the following in the php.ini as well - do i need to make changes to this.


[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
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 17918659
is php giving you any errors when you are trying to load apache? have you restarted apache?
if the extension if uncommented in the ini file then should load and if not then there should be an error.
0
 

Author Comment

by:bisleyboy
ID: 17958156
I have decided that learning ASP may be an easier option as the script is going to run on IIS in the end anyway and I think I can get that to work.

Many thanks for the advice though
0
 

Expert Comment

by:gtmathewDallas
ID: 33907730
Where i can download ntwdblib.dll version 2000.2.8.0? Please help me..
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now