bisleyboy
asked on
Configuring WAMP (Windows/Apache/MSSQL/PHP) environment
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thats only for *nix installations
in fact you can have WAMP and also have mssql on the same server
in fact you can have WAMP and also have mssql on the same server
ASKER
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();
ASKER
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
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.
;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
; 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
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.
if the extension if uncommented in the ini file then should load and if not then there should be an error.
ASKER
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
Many thanks for the advice though
Where i can download ntwdblib.dll version 2000.2.8.0? Please help me..
ASKER