I am working with PHP and need it to connect to a MS SQL Enterprise database on a different server. I have read TONS of suggestions and nothing works, here is the situation:
-IIS is on a Win XP Pro System with PHP5 Installed (the rest of php seems to be running fine).
-extension=php_m ssql.dll is uncommented- not only has the service been restarted but the computer has been rebooted several times
-We are NOT running Apache as well.
-SQL Server is version 8 running on a Win 2003 Server
-the ntwdblib.dll file from the SQL server is copied to the XP system in the system32, php AND php/ext directories
-SQL Server is set up for both named pipes and TCP/IP
-SQL Server will accept both NT authorization and SQL server logins
Here is my code:
$connection = @mssql_connect( 'SQLServer','us rnm','psswd');
echo 'Made it bast the attempt to connect';
if (!$connection)
{
echo 'Could not connect'; }
else { echo 'Connected';}'
The Web stops when it gets to the connect statement, it will not send any of the echo'd statements.
I have found code statements with and without the leading '@', without it, I get:
Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwr oot\NewSite\new s.php on line 47
Can someone please help, I am up against a wall and connot contiue with the website until I figure out the configuration problem.
Thanks
-IIS is on a Win XP Pro System with PHP5 Installed (the rest of php seems to be running fine).
-extension=php_m ssql.dll is uncommented- not only has the service been restarted but the computer has been rebooted several times
-We are NOT running Apache as well.
-SQL Server is version 8 running on a Win 2003 Server
-the ntwdblib.dll file from the SQL server is copied to the XP system in the system32, php AND php/ext directories
-SQL Server is set up for both named pipes and TCP/IP
-SQL Server will accept both NT authorization and SQL server logins
Here is my code:
$connection = @mssql_connect( 'SQLServer','us rnm','psswd');
echo 'Made it bast the attempt to connect';
if (!$connection)
{
echo 'Could not connect'; }
else { echo 'Connected';}'
The Web stops when it gets to the connect statement, it will not send any of the echo'd statements.
I have found code statements with and without the leading '@', without it, I get:
Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwr oot\NewSite\new s.php on line 47
Can someone please help, I am up against a wall and connot contiue with the website until I figure out the configuration problem.
Thanks
Comment