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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Glenn
    #1

    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_m ssql.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;\pa th2"
    ;include_path = ".;c:\php\inclu des"

    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\syste m32
    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
    Tags: extension
    • Andy Hassall
      #2
      Re: followed manual instructions.. php_mssql.dll still doesn't load

      On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <bagsmode@yahoo .com> wrote:
      [color=blue]
      >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.dl l. I've updated the php.ini to the following:[/color]

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

      --
      Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
      <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

        Comment

        • Glenn
          #3
          Re: followed manual instructions.. php_mssql.dll still doesn't load

          Andy Hassall wrote:
          [color=blue]
          > On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <bagsmode@yahoo .com> wrote:
          >
          >[color=green]
          >>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:[/color]
          >
          >
          > php_mssql.dll is for Microsoft SQL Server.
          > php_mysql.dll is for MySQL. Surely you mean this DLL instead?
          >[/color]

          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

            Comment

            • Andy Hassall
              #4
              Re: followed manual instructions.. php_mssql.dll still doesn't load

              On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <bagsmode@yahoo .com> wrote:
              [color=blue]
              >Andy Hassall wrote:[color=green]
              >> On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <bagsmode@yahoo .com> wrote:[color=darkred]
              >>>
              >>>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.dl l.[/color][/color][/color]

              Please post a reference to the bits of the manual that have given you this
              impression?
              [color=blue][color=green]
              >> php_mssql.dll is for Microsoft SQL Server.
              >> php_mysql.dll is for MySQL. Surely you mean this DLL instead?[/color]
              >
              >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.dl l is in version 5, not 4. Please correct me if I'm wrong.[/color]

              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 / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
              <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

                Comment

                • Glenn
                  #5
                  Re: followed manual instructions.. php_mssql.dll still doesn't load

                  Andy Hassall wrote:
                  [color=blue]
                  > On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <bagsmode@yahoo .com> wrote:
                  >
                  >[color=green]
                  >>Andy Hassall wrote:
                  >>[color=darkred]
                  >>>On Sat, 18 Dec 2004 16:59:42 GMT, Glenn <bagsmode@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.d ll.[/color][/color]
                  >
                  >
                  > Please post a reference to the bits of the manual that have given you this
                  > impression?
                  >
                  >[color=green][color=darkred]
                  >>> php_mssql.dll is for Microsoft SQL Server.
                  >>> php_mysql.dll is for MySQL. Surely you mean this DLL instead?[/color]
                  >>
                  >>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.d ll is in version 5, not 4. Please correct me if I'm wrong.[/color]
                  >
                  >
                  > 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.
                  >[/color]
                  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

                    Comment

                    • Andy Hassall
                      #6
                      Re: followed manual instructions.. php_mssql.dll still doesn't load

                      On Sat, 18 Dec 2004 19:59:33 GMT, Glenn <bagsmode@yahoo .com> wrote:
                      [color=blue]
                      > On Sat, 18 Dec 2004 17:43:14 GMT, Glenn <bagsmode@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?[/color]

                      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.
                      [color=blue]
                      >Still curious about the module not loading.. but I guess for me the
                      >point is moot.[/color]

                      Here's the explanation again...
                      [color=blue][color=green]
                      >> 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.[/color][/color]

                      --
                      Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
                      <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

                        Comment

                        Previous template Next
                        Working...