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 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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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)
|
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 =...
|
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...
|
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...
|
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...
|
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....
|
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....
|
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...
|
by: saverio.post |
last post by:
What does this represent?
unsigned int n : 6;
???
Saverio
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
|
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...
| |