meiyu

I'm trying to begin rebuilding our web page in php and am having trouble figuring out what needs to be set in the php.ini file to enable MSSQL. There is no section in the phpinfo() about MSSQL and I read in a few places about enabling MSSQL in the php.ini file. The MSSQL section contains this: [MSSQL] ; Allow or prevent persistent links. mssql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mssql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. mssql.max_links = -1 ; Minimum error severity to display. mssql.min_error_severity = 10 ; Minimum message severity to display. mssql.min_message_severity = 10 ; Compatibility mode with old versions of PHP 3.0. mssql.compatability_mode = Off ; Connect timeout ;mssql.connect_timeout = 5 ; Query timeout ;mssql.timeout = 60 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 ; Limits the number of records in each batch. 0 = all records in one batch. ;mssql.batchsize = 0 ; Specify how datetime and datetim4 columns are returned ; On => Returns data converted to SQL server settings ; Off => Returns values as YYYY-MM-DD hh:mm:ss ;mssql.datetimeconvert = On ; Use NT authentication when connecting to the server mssql.secure_connection = Off ; Specify max number of processes. -1 = library default ; msdlib defaults to 25 ; FreeTDS defaults to 4096 ;mssql.max_procs = -1 ; Specify client character set. ; If empty or not set the client charset from freetds.comf is used ; This is only used when compiled with FreeTDS ;mssql.charset = "ISO-8859-1" If I try to connect to our database I get a 500 - Internal server error Thanks for any help! Mei

We are building new server to host our website. I installed Windows Server 2008 with all SP and patches and IIS 7 with CGI. Our website is mainly ColdFusion so I focused on getting that running first. (If anyone is interested in doing a CF to PHP conversation let me know at meiyuinchina@hotmail.com) All of this worked fine so I installed PHP 5.3.2 (VC9 x86 Non Thread Safe) using the installer. The webpages that are in PHP didn't work so I verified that PHP is running. I have a php file with the code <?php phpinfo(); ?> in it and I get the following message "Error during XSLT transformation: An unknown XPath extension function was called." from a debug trace. IIS 7 has handler mapped and the php.ini file has fastcgi.impersonate=1, fastcgi.logging=0, cgi.fix_pathinfo=1, cgi.forceredirect=0 and open_basedir="c:\inetpub" modified to these values. I restored to an earlier backup with Server 2008 and IIS 7 only and added PHP 5.3.2. Still same message. AHHHHHH! Searching the web finds next to nothing and certainly nothing useful. Thanks for any help you can provide!

Indeed, one should never assume; especially when working with a Microsoft product. It was looking in the C:\Windows directory where no php.ini existed. Being new to php, I wasn't sure of where to look, but the load path and loaded .ini file are part of the main phpinfo display. Thanks for your help! On until the next problem! Mei

I assume it is. It was never previously installed. How would I know?

I installed PHP 5.2.13 on a Windows 2003 server and have verified PHP is running. I've installed phpBB3 successfully but get the message "Thumbnail support has been disabled. For proper functionality either the GD extension need to be available or imagemagik being installed. Both were not found." I have verified that the ;extension=php_gd2.dll is no longer commented in the C:\PHP\php.ini file. The path variable has also been modified to include the C:\PHP; and C:\PHP\ext directories. Restarted the server. Server has all patches applied. Still getting the message! Thanks for any help. Mei