Re: Re: Install trouble - PHP & MS SQL

Can't speak to MSSQL but getting PHP to talk to MySQL is not so difficult. However, one thing I would recommend is putting your DLLs in the actual Windows system directory rather than in the PHP directory and relying on the PATH variable. I found that even having the PHP dir in the PATH and having my libmysql.dll file in there, it still didn't work properly. As soon as I dropped libmysql.dll into the Windows/system32 directory, everything was peachy keen. G. - What version of MySQL are you trying to get PHP to talk to? I just upgraded my MySQL servers to 5 from 4.0.2x the other night and ended up having to upgrade from PHP 5.0.1 to 5.0.5 before it would talk to the MySQL server properly. All is running smooth again though, and I am mighty happy with them thus far. Cheers. Armando G. Eggold wrote:

If it's any consolation, I'm having the same issue. In my case, I can't seem to get PHP5 to talk to either MySQL or MS SQL by following all the documentation I've been able to get my hands on. See my post from 11/5 entitled: Re: [PHP-WIN] PHP 5.0 and MySQL Support One note: when you execute the "phpinfo()" function, do YOU see an MS SQL section appear? I'll be watching to see if anyone can step up to the plate on this one. ""Jim McDonald"" <jam@buckinghamcolour.com> wrote in message news:8E.CE.08337.EB073734@pb1.pair.com...

MS SQL "database type" not supported --------------------------------------------------------------------------

------

I can't get MS SQL supported in my PHP installation. I've just installed PHP BB (and I have tried their forums) and want to use MS SQL, here's my setup MS Win 2K SP4 Apache 2.0.50 with OpenSSL v 0.9.7d MS SQL 2000 SP3 PHP 5.0.5 PHP BB 2.0.18 Apache has been running for some time serving other live sites (with MS

SQL

integration) - no trouble there. I've done an install of PHP (1st & fresh) onto the above, which tested fine with a simple test page. I have looked at the php.ini (based upon php.ini-recommended) file and (thanks to a posting on a forum) tried a few settings (like changing "mssql.secure_connection" from "off" to "on") I have copied all the DLL's to the same directory that holds PHP.exe (to

be

sure) and this is in windows PATH variable of course. I have uncommented the extension=php_mssql.dll as well of course. Elsewhere, ppl have mentioned having MS SQL Client tools installed, which

I

have. And, just in case it occurs to anyway, I have restarted Apache after changes. As a complete noob to PHP and PHP BB I've now run out of ideas, although

I'm

sure it's a simple solution of getting the settings right. I'd appreciate someone letting me know what the php.ini settings should be (and if necc, and changes to httpd.conf) I should be doing. Thanks in advance.