Re: MS SQL extension not loading

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




 Hello Richard,

Check the "php.ini" setting in the top portion to see where php.ini
MUST BE for it to be read.
It is telling me:

Configuration File (php.ini) Path  C:\WINDOWS

Step #2:
Find your php.ini file, and MOVE it to where phpinfo() wants it to be.
I have my php.ini at C:\WINDOWS\PHP.ini.
Step #3
In php.ini look at the "extensions_dir" setting.
Fix it.
extension_dir = "C:\PHP\ext"

which is correct.
Step #4.
Compare version numbers of your mssql_php.dll and the version of PHP
you are running.  You CANNOT mix-n-match old DLLs with new PHP and
vice versa.  It will sometimes "work" until you happen to use the one
function that CHANGED between versions.
php_mssql.dll version is 5.1.2.2
PHP version is 5.1.2

Looks okay.

If you just went out and found some random mssql_php.dll to throw in
the directory, it is NOT going to work.
Well, I installed PHP manually, as described in install.txt. The file I have downloaded was

php-5.1.2-Win32.zip
9,140,593 bytes

It was released on 12 Jan 2006. This is the official latest stable version, and it had all of the extensions packaged together with php.exe. I used the same one on my home computer and it worked. I think this can't be the problem.

Step #4a
Check your log files.  I'm assuming ISS actually HAS logfiles...  It
must have, right?  Might be in system events log.  Might be in an
"error_log" file next to your IIS web traffic logs.  Knowing
Microsoft, it might be *ANYWHERE*...
Yes, you are right. The event log contains some error entries telling me this:

Faulting application w3wp.exe, version 6.0.3790.1830, faulting module unknown, version 0.0.0.0, fault address 0x01b3e8e0. For more information, see Help and Support center at http://go.microsoft.com/fwlink/events.asp

The above link contains the text

"We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere."

Yes, this is tipical Microsoft. I had to figure out that the logfiles for my website in under

c:\windows\system32\logfiles\W3SVC848989038\

Don't ask me why. :-) Unfortunately, the logfile does not help, because it DOES NOT log out php error messages. For example, if I have an error in my php script, this is all I get:

2006-04-11 16:43:04 127.0.0.1 GET /info.php =PHPE9568F34-D428-11d2-A769-00AA001ACF42 9000 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0

I'm guessing that you might find an error message about the
mssql_php.dll being the wrong version...
Hmm. I also tried to load it with the dl() function, but then I got an error:

"Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=php_mssql in your php.ini in C:\Inetpub\vtracks_server\info.php on line 2"

Step #5.
Switch to a superior web server: Apache
:-)
I wish I could.
Step #6.
Switch to a superior OS like Linux or FreeBSD
:-) :-) :-)
Yes, I would like to. The problem is that I cannot. I got detailed instructions and my boss wants to run this on IIS6 and Windows. I might be able to ask him to use apache. That would be wonderful.

It is strange that I have a test server which is almost the same (Win2003 server, IIS6 and PHP 5.1.2) and it works here. :-/

Thank you for your help.

  Laszlo

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux