php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #43711 Can't load php_mssql.dll
Submitted: 2007-12-30 04:13 UTC Modified: 2007-12-30 07:45 UTC
From: vlad275 at ya dot ru Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 5.3CVS-2007-12-30 (snap) OS: Windows 2003
Private report: No CVE-ID: None
 [2007-12-30 04:13 UTC] vlad275 at ya dot ru
Description:
------------
Windows2003+IIS+PHP5.3.0+MS SQL Server 2005 
Can't load php_mssql.dll


1. Installed under IIS php-5.2.5-win32-installer.msi as ISAPI for .php
2. Uncommented at php.ini  extension=msql.dll
3. Added at php.ini  extension=php_mssql.dll
4. Copied all extentions into C:\WINDOWS\system32\
5. Copied ntwdblib.dll version 8.x into c:\php and c:\windows\system32. 
6. Reooted

Fatal error: Call to undefined function mssql_connect()

What do I have to do?!!!

Reproduce code:
---------------
if (function_exists('mssql_connect')) echo "Okay, fn is there"; else echo "Not found\n";
echo phpinfo();

print_r (get_loaded_extensions());


$mssql_server='195.42.181.173';
$mssql_user='';
$mssql_pass='';
mssql_connect($mssql_server,$mssql_user,$mssql_pass);

Expected result:
----------------
'Okay, fn is there'

I wanna use 'mssql_connect'!!! I cannot! Help me!!!

Actual result:
--------------
Not found

1Array ( [0] => bcmath [1] => calendar [2] => com_dotnet [3] => ctype [4] => session [5] => ereg [6] => filter [7] => ftp [8] => hash [9] => iconv [10] => json [11] => mysqlnd [12] => odbc [13] => pcre [14] => Reflection [15] => date [16] => libxml [17] => standard [18] => tokenizer [19] => zlib [20] => SimpleXML [21] => dom [22] => SPL [23] => wddx [24] => xml [25] => xmlreader [26] => xmlwriter [27] => ISAPI )

Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwroot\administrator\vt_example.php on line 52

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-12-30 07:45 UTC] fmk@php.net
Step 2 indicates your are loading msql instead of mssql. Those are two different extensions.

If that's just a typo in your submission you are most likely missing the ntwdblib.dll in \windows\system32. This file is required for the mssql extension to load. You can copy this file from the server or you can install the client tools on your PHP server box.
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Mon Oct 03 19:03:44 2022 UTC