Page 1 of 1

MSSQL mssql_connect not working

Posted: Thu Nov 09, 2006 8:11 am
by mstrop
Hi,

I would like to use MS SQL with my PHP scripts. So, I installed MS SQL server, enabled extension in PHP.INI and tried to use mssql_connect. Unfortunatly it says the function doesn't exists. When I checked PHPINFO no MSSQL was loaded. When I checked Apache log it says:

Code: Select all

Thu Nov 09 14:39:20 2006] [notice] Child 956: All worker threads have exited.
[Thu Nov 09 14:39:20 2006] [notice] Child 956: Child process is exiting
[Thu Nov 09 14:39:20 2006] [notice] Parent: Child process exited successfully.
[Thu Nov 09 14:39:24 2006] [notice] Parent: Created child process 2484
PHP Warning:  PHP Startup: Unable to load dynamic library 'c:\\php\\ext\\php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0
But php_mssql.dll does exist in the directory and ntwdblib.dll is in the path as mention in manual. Please, could anybody tell my, why mssql is not loaded? I am running PHP 5.2.0 on WinXP SP2 with Apache 2.0.

Marek

Posted: Thu Nov 09, 2006 9:01 am
by Obadiah

Posted: Thu Nov 09, 2006 9:28 am
by mstrop
Thanks, it helps for now - using php_dblib.dll instead of php_mssql.dll. On other hand it doesn't make me very happy as I would like to use standard PHP package instead of add-ons, which can make me problems when deploying the application.

M.