aspnetguy Posted December 7, 2006 Share Posted December 7, 2006 I am trying to get the mentioned software installed on Windows Server 2003 (IIS6).I have MySql installed and working.I have PHP installed and running but there are 2 problems.1. I can't display PHP errors2. Can't load the MySql Library.I have php.ini in C:\WINDOWS, I have set "display_errors = On" and uncommented the mysql extension.When I run phpinfo() it still says display_errors = Off and there is no MySql information plus a small test app fails to retreive some data from MySql.Any ideas? I followed this tutorial to the letter to get to this point. http://www.tjitjing.com/blog/2006/05/php5-...erver-2003.htmlJust some more info about the setup, it is Win2003 Standard SP1. It also has .Net 2.0 and Sql Server 2000 SP4 installed. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 7, 2006 Share Posted December 7, 2006 I've got a very similar setup here. Server 2003, PHP5, Mysql, .NET 2.0, and SQL Server 2000. Everything is working fine.It sounds like it is loading a different version of php.ini then what you are editing. It looks for php.ini in several places. You might want to do a search for files called "php.ini" and see if there are more then one. The one I have using here is in the c:\windows folder.Also, keep in mind that you have to restart IIS to get changes in php.ini to come into effect. You can put these commands in a bat file to restart web services:net stop iisadmin /ynet start w3svcnet start msftpsvcnet start smtpsvc Link to comment Share on other sites More sharing options...
aspnetguy Posted December 7, 2006 Author Share Posted December 7, 2006 thanks, phpinfo() says it is looking in C:\WINDOWS\PHP.INI. I'll try a restart of IIS later when I get home. Link to comment Share on other sites More sharing options...
aspnetguy Posted December 8, 2006 Author Share Posted December 8, 2006 ok I rebooted IIS and PHP is now displaying error message but still not loading the MySql library. "Call to an undefined function mysql_connect()...."I have libmysql.dll in C:\WINDOWS\SYSTEM32 - is this correct?I have the mysql extension uncommented in php.ini (and restarted IIS).What else do I need to do? On another note has anyone used SQLite yet? How does it compare to MySql? What do I have to do to get that to work? Link to comment Share on other sites More sharing options...
aspnetguy Posted December 10, 2006 Author Share Posted December 10, 2006 anyone? Link to comment Share on other sites More sharing options...
boen_robot Posted December 10, 2006 Share Posted December 10, 2006 Look at your "extension_dir" directive. The php_mysql.dll file must be in that directory. If not, simply set that directive properly. If PHP was installed in C:\PHP5 and the extensions were in the "ext" dir from there, the directive would simply be: extension_dir = "C:\PHP5\ext" If everything is OK, PHP should show information about MySQL in phpinfo(). Link to comment Share on other sites More sharing options...
aspnetguy Posted December 10, 2006 Author Share Posted December 10, 2006 thanks I'll try that.EDIT: Worked thanks to much! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now