Forum Home
Press F1
 
Thread ID: 108189 2010-03-17 08:45:00 PHP MS SQL - Shouldn't this be working :S WarNox (8772) Press F1
Post ID Timestamp Content User
868106 2010-03-21 20:59:00 I hope this is what you meant:


C:\Inetpub\wwwroot\test>php index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or
g/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<div xmlns="www.w3.org xml:lang="en" lang="en">
<head>
<title>test</title>
</head>
<body>
PHP Warning: dl(): Unable to load dynamic library './php_mssql.dll' - The speci
fied module could not be found.
in C:\Inetpub\wwwroot\test\index.php on line 8
PHP Warning: dl(): Unable to load dynamic library './php_pdo_mssql.dll' - The s
pecified module could not be found.
in C:\Inetpub\wwwroot\test\index.php on line 9
Array
(
)
bool(false)
PHP Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwro
ot\test\index.php on line 22 		WarNox (8772)
868107 2010-03-22 00:36:00 Yep, that's what I meant. Now we're getting somewhere, as this is likely the root cause of your problem.

Where on your filesystem are the extensions stored? 		Erayd (23)
868108 2010-03-22 01:14:00 mm yea looks like it.

The extensions are just in the default PHP directory in C:\PHP\ext

Looking at the php.ini, its got "./" set for the extensions, so shouldn't that pick it up? Or do I need to set that up as C:\PHP\ext?




Gregor 		WarNox (8772)
868109 2010-03-22 05:20:00 './' will usually work if the extensions are in PHP's working directory, but otherwise may cause problems.

Try changing it to C:\PHP\ext and see what happens. 		Erayd (23)
868110 2010-03-22 09:00:00 Ok, I updated the php.ini file to:

extension_dir = "C:\PHP\ext"

and restarted the server. Then I run the ...php index.php command again and get the same error:

PHP Warning: dl(): Unable to load dynamic library './php_mssql.dll' - The speci
fied module could not be found.
in C:\Inetpub\wwwroot\test\index.php on line 8
PHP Warning: dl(): Unable to load dynamic library './php_pdo_mssql.dll' - The s
pecified module could not be found.
in C:\Inetpub\wwwroot\test\index.php on line 9
Array

Something strange is going on here. Why is it still looking at ./php_pdo_mssql.dll? and not C:\php\ext... 		WarNox (8772)
868111 2010-03-22 10:40:00 Any chance I could have a play with it via TeamViewer at some point? I'm intrigued - this is very strange behavior. Erayd (23)
868112 2010-03-22 18:33:00 Any chance I could have a play with it via TeamViewer at some point? I'm intrigued - this is very strange behavior.

Sure, but won't be able to do it until tonight, about 7 or 8pm. Let me know if thats ok. 		WarNox (8772)
868113 2010-03-22 19:22:00 That should be OK. I'll flick you a PM with my cellphone number. Erayd (23)
868114 2010-03-23 09:07:00 Well thanks for all the help, team viewer to the rescue.

If anyone else has this problem, the issue was with a missing .dll from .net framework, it wasn't anywhere in the path so PHP couldn't find it.

Copying "msvcr71.dll" to the C:\PHP\ directory fixed the issue :)

Thanks for all the help everyone and especially Erayd!

:banana 		WarNox (8772)
868115 2010-03-23 09:25:00 No worries - you're most welcome :D. Erayd (23)
1 2 3 4