Has anyone any luck connecting to an SQL Server 2k database on a remote machine over the local network?
This works with ODBC, but not using the php mssql functions. I have a similar setup on another machine where this works - but the client tools are installed. I have everything necessary setup on the machines. I have apache running as a user service. I have that user allowed to run on the remote machine where sql server is running. I have ntwdblib.dll in winnt\system32. I have the correct php_mssql.dll. I get no errors other than "can't connect to the host" that I am trying to connect to. The same script works off my machine - but I have SQL Server installed on my machine. I am down to thinking that I have to have the client tools in order to access the database; however, the snip of text below leads me to believe that I should be able to connect with just the ntwdblib.dll and php_mssql.dll files alone: <snip source="http://www.php.net/manual/en/ref.mssql.php";> These functions allow you to access MS SQL Server database. 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. The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. </snip> This line "Copying ntwdblib.dll will only provide access." is what lets me think I can do this. Any one? Help, please. Thanks! :) Nicole www.aeontrek.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
