473,322 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

followed manual instructions.. php_mssql.dll still doesn't load

I've RTFM'd and searched google and Zend and still am having a problem
loading php_mssql.dll.

First, background:

I'm using PHP Version 4.3.10
Apache/2.0.52
MySQL Server 4.1
Windows 2000 Professional OS

I installed Apache successfully, index.html works.
I've successfully downloaded and created a test page with simple php
instructions and that's working.
I've been using MySQL and have a running database.

Now I'm trying to be able to use dbx functions to access MySQL via PHP.
According to the manual, (since I'm using PHP4, not 5) I need to load
php_mssql.dll. I've updated the php.ini to the following:

extension_dir = c:/php/extensions/

and uncommented:

extension=php_mssql.dll

But got the famous error from Apache:

Unable to load dynamic library 'c:/php/extensions/php_mssql.dll' -
The specified module could not be found

After looking at the php.ini above and seeing:

; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

I switched the forward slashed to backslashes and I get the same error
(showing the backslashes this time) that it could load/find.

I searched Google archives and Zend mailing list archives and some say
to put the extension_dir to just C:\php\ and copying the php_mssql.dll
to that directory. Did both, get the same error, can't find the file in
C:\php...

Some of the archives say that I they've copied the file to the windows
dir (C:\WINNT for me) and some say to the system dir (C:\WINNT\system32
for me), and each time still get the error can't load/find.

Any other suggestions would be appreciated.

There is a mention in the manual about loading via dl(). Is this a
consideration?

Thanks for any help :)
Glenn
Jul 17 '05 #1
5 6805
On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <ba******@yahoo.com> wrote:
Now I'm trying to be able to use dbx functions to access MySQL via PHP.
According to the manual, (since I'm using PHP4, not 5) I need to load
php_mssql.dll. I've updated the php.ini to the following:


php_mssql.dll is for Microsoft SQL Server.
php_mysql.dll is for MySQL. Surely you mean this DLL instead?

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #2
Andy Hassall wrote:
On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <ba******@yahoo.com> wrote:

Now I'm trying to be able to use dbx functions to access MySQL via PHP.
According to the manual, (since I'm using PHP4, not 5) I need to load
php_mssql.dll. I've updated the php.ini to the following:

php_mssql.dll is for Microsoft SQL Server.
php_mysql.dll is for MySQL. Surely you mean this DLL instead?


But this is PHP4, not 5.. therefore, there is no php_mysql.dll in this
version. From reading the documentation, it's my understanding that
php_mysql.dll is in version 5, not 4. Please correct me if I'm wrong.

Thanks
Glenn
Jul 17 '05 #3
On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <ba******@yahoo.com> wrote:
Andy Hassall wrote:
On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <ba******@yahoo.com> wrote:

Now I'm trying to be able to use dbx functions to access MySQL via PHP.
According to the manual, (since I'm using PHP4, not 5) I need to load
php_mssql.dll.

Please post a reference to the bits of the manual that have given you this
impression?
php_mssql.dll is for Microsoft SQL Server.
php_mysql.dll is for MySQL. Surely you mean this DLL instead?


But this is PHP4, not 5.. therefore, there is no php_mysql.dll in this
version. From reading the documentation, it's my understanding that
php_mysql.dll is in version 5, not 4. Please correct me if I'm wrong.


Yes, you're quite right that there is no php_mysql.dll in the current 4.3
Windows binary distribution, because as the manual and php.ini notes, MySQL
support is compiled directly into this build of PHP, so no additional php_*
extension DLLs are required. It's got MySQL support straight out of the box.

However, php_mssql.dll has always been for Microsoft SQL Server and has
nothing whatsoever to do with MySQL, and without SQL Server client libraries
installed you won't be able to load it.

PHP5 has an additional php_mysqli.dll for the MySQL-improved extension, which
gives access to MySQL 4.1 features, and php_mysql.dll returns as a separate
optionally loadable extension DLL for the "classic" interface.

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #4
Andy Hassall wrote:
On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <ba******@yahoo.com> wrote:

Andy Hassall wrote:
On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <ba******@yahoo.com> wrote:

Now I'm trying to be able to use dbx functions to access MySQL via PHP.
According to the manual, (since I'm using PHP4, not 5) I need to load
php_mssql.dll.

Please post a reference to the bits of the manual that have given you this
impression?

php_mssql.dll is for Microsoft SQL Server.
php_mysql.dll is for MySQL. Surely you mean this DLL instead?


But this is PHP4, not 5.. therefore, there is no php_mysql.dll in this
version. From reading the documentation, it's my understanding that
php_mysql.dll is in version 5, not 4. Please correct me if I'm wrong.

Yes, you're quite right that there is no php_mysql.dll in the current 4.3
Windows binary distribution, because as the manual and php.ini notes, MySQL
support is compiled directly into this build of PHP, so no additional php_*
extension DLLs are required. It's got MySQL support straight out of the box.

However, php_mssql.dll has always been for Microsoft SQL Server and has
nothing whatsoever to do with MySQL, and without SQL Server client libraries
installed you won't be able to load it.

PHP5 has an additional php_mysqli.dll for the MySQL-improved extension, which
gives access to MySQL 4.1 features, and php_mysql.dll returns as a separate
optionally loadable extension DLL for the "classic" interface.

OMG.. in the manual "Microsoft SQL Server" & "MySQL" are right next to
each other, and I can see that the link for "Microsoft SQL Server" has
been clicked, but not for "MySQL"... a thousand pardons! I clicked the
wrong link and was following the instructions for including php_mssql.dll.

So, for my concerns.. I can re-comment out php_mssql.dll and I should be
good to go. Do I still use the dbx commands?

Still curious about the module not loading.. but I guess for me the
point is moot.

Thank you for pointing out my error.

Glenn
Jul 17 '05 #5
On Sat, 18 Dec 2004 19:59:33 GMT, Glenn <ba******@yahoo.com> wrote:
On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <ba******@yahoo.com> wrote:

So, for my concerns.. I can re-comment out php_mssql.dll and I should be
good to go. Do I still use the dbx commands?
Well, that's up to you. I've never used dbx so can't offer much in the way of
informed comment. I see it's a database abstraction layer; so long as it
transparently emulates placeholders for MySQL then that'd be a good thing.

From looking at the manual, it doesn't appear to. In fact at a glance it
appears to force you to embed variables in literal SQL, even for databases that
support placeholders - so forcing you into the classic cases for SQL injection,
and crippling scalability on databases like Oracle. If this is the case, and
I've not missed something obvious, I'd say this is a particularly useless
abstraction layer.

Personally, I recommend ADOdb. In the end, you should research and find out
which one best suits your own requirements.
Still curious about the module not loading.. but I guess for me the
point is moot.


Here's the explanation again...
However, php_mssql.dll has always been for Microsoft SQL Server and has
nothing whatsoever to do with MySQL, and without SQL Server client libraries
installed you won't be able to load it.


--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Robert Brewer | last post by:
Playing around with bytecodes some more: >>> def g(x): .... if x: .... y .... else: .... z .... >>> dis.dis(g) 2 0 LOAD_FAST 0 (x)
12
by: Andrew Baker | last post by:
What is the best way to lock an individual row in the following scenerio: --TODO - LOCK THIS ROW -- Return the next id SELECT next_id INTO next_id_out FROM owner.my_id_table WHERE app_id =...
9
by: Dominic Olivastro | last post by:
Hi all: I'm new to this newsgroup, and new to XML. We receive documents in XML, and I am trying to tear them apart to obtain information. I decided that, for my purposes, it would be fairly...
2
by: Griff | last post by:
What I'm trying to achieve is to have a title followed by a horizontal rule on the same line. For example: Living on Mars ---------------- Living on Mars would be at best impractical for the...
5
by: Zlatko Matiæ | last post by:
Hello. I have finished my MS Access application and now I would like to embedd some users manual in the aplication. Is it possible and how to create it ? In which format, by which tools ? Thanks...
1
by: Mark | last post by:
I get the following error (see stacktrace) while loading an XMLDocument. The document is huge and it has PI's created from Arbortext's editor. Works fine when I use MSXML2 to load the Document....
1
by: adolfo | last post by:
I am at the very beginning of the DISLIN 9.3 Manual: 1.4 Quickplots Some quickplots are added to the DISLIN module which are collections of DISLIN routines for displaying data with one command....
12
by: chardish | last post by:
Hello, I'm trying to build an executable with py2exe, but unfortunately the version I have is 0.6.6, which has a rather annoying bug that doesn't let you rename the executable file if you bundle...
12
by: saverio.post | last post by:
What does this represent? unsigned int n : 6; ??? Saverio
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.