Re: Windows and MS SQL Server - My Solution

I have just added this howto file to the cvs. We are not allowed to distribute MSSQL files with php. Please get the files from your MS SQL Server CD. - Frank >Hello all, > >many thanks for your replies, I've got it up and running now (with NT4SP6a, >PHP4.01PL02, CGI as well as ISAPI, thanks to Brad Jackson!). > >The php_mssql70.dll requires NTWDBLIB.DLL to work, which isn't included in >the PHP4.01PL2 package. I've got it from the actual developer-version at >http://www.php4win.de/, restarted the web-service, and it works! > >I'm unfortunately not really familiar with SGML, but it would be great if >this hint could be included in the installation-manuals (or at leastin the >readme.txt of the next PHP-package). Or are there some descriptions about >the extensions I've only missed? > >Hope everybody gets this prob. solved now.... > >Cu, >Thomas > > > >Aaron Prohaska wrote: > >> Has anyone got PHP working with MS SQL Server? When every I uncomment >> the mssql70.dll extension line and browse to a page inetinfo starts >> running 100% CPU and doesn't stop. I am currently tring this on W2K >> Server, PHP Version 4.0.1pl2 (ISAPI), and have tried using both MS SQL >> 7.0 and 2000 beta 2. Anyone have any idea why this is happening? >> >> thanks, >> >> Aaron >> >> -- >> PHP Windows Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> For additional commands, e-mail: php-windows-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >

Rules for building MSSQL ------------------------ The MSSQL project contains 4 configurations. The files needed for each configurations are: MSSQL 65 Release_TS MSSQL 65 Debug_TS php_build\mssql-65\include\sqldb.h php_build\mssql-65\include\sqlfront.h php_build\mssql-65\lib\ntwdblib.lib MSSQL 70 Release_TS MSSQL 70 Debug_TS php_build\mssql-70\include\sqldb.h php_build\mssql-70\include\sqlfront.h php_build\mssql-70\lib\ntwdblib.lib php_build is a directory at the same level as php4. Start Visual Studio, load php_modules.dsw, select the MSSQL projects, configuration and build it. This module requires ntwdblib.dll and one or more of the following dll's dbmsadsn.dll dbmsrpcn.dll dbmsshrn.dll dbmssocn.dll for tcp/ip connections dbmsspxn.dll for ipx/spx connections dbmsvinn.dll dbnmpntw.dll for netbios connections All these files are installed while installing MS SQL Server. If the SQL Server is installed on another maschine you need to install the client tools on the web server as well.