PHPv5.0.5 upgrade to PHPv5.2.6

[Dominika]

I am not a PHP programmer but inherited some code. Basically they upgraded the PHP version from v5.0.5 to v5.2.6 and now the code gives the following errors:

 

PHP Warning: PHP Startup: Unable to load dynamic library 'c:\PHP\ext\php_oci8.dll' - The specified procedure could not be found. in Unknown on line 0

 

Fatal Error handling CallPHP Warning: PHP Startup: Unable to load dynamic library 'c:\PHP\ext\php_oci8.dll' - The specified procedure could not be found. in Unknown on line 0 PHP Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'function'. (severity 15) in \\166.37.214.35\OAWebData$\Production\VSSPT\db.inc on line 126 PHP Warning: mssql_query() [function.mssql-query]: message: Could not locate entry in sysdatabases for database 'the'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in \\166.37.214.35\OAWebData$\Production\VSSPT\db.inc on line 126 PHP Warning: mssql_query() [function.mssql-query]: Query failed in \\166.37.214.35\OAWebData$\Production\VSSPT\db.inc on line 126

 

I have no idea what this means, and there is almost nothing on Google. Any help to start correcting this, or pointing me in the right direction would help immensely.

 

Thanks :-)

[bobbinsbro]

that file is a php extension for interacting with an oracle DB, and you need to install this extension. the extension is called "Oracle 8" in the windows php install wizard. never installed php on *nix machine, so i can't help you there.

[revraz]

This is an Oracle DLL, so if you use a Oracle backend, you need to inform your host to enable this support.

[JonnoTheDev]

This means that the libraries php requires haven't been installed or are referenced to an incorrect path on your server.

I personally dont work in a Windows environment only Linux but its obvious you must obtain the dll files that your configuration requires.

 

The path for your setup is c:\PHP\ext\php_oci8.dll

[Dominika]

Thanks for the replies everyone. The database that this app uses us SQL, so I am not sure qhy it would look for a reference to Oracle. Where can I install this nedded dll from?

[Dominika]

Sorry I reread the post again and I see the answer where to install it from.

 

The question I have is why does it need an Dall for Oracle when it is using an MS SQL DB? Is there a place in the code that specifically references this Dall and I could remove it? Is there a specific file in all PHP codes that contains this info?

 

Thanks.

[JonnoTheDev]

The php.ini file will be loading it. Doesnt matter what functions you are using.

[wildteen88]

Yes PHP needs to be configured to use which ever extensions you want to use.  PHP can be configured via the php.ini

 

The only extensions you'll need to have enabled for MS SQL databases would be the following

;extension=php_msql.dll

;extension=php_mssql.dll

(remove the ; at the start of the line to enable the extension. To disable do the opposite)

 

Never enable ALL available extensions.

 

Once you have configured PHP make sure your restart your HTTP Server (eg Apache, IIS etc)

 

[Dominika]

Ok let me ask you this. If I want to remove all references to this dll, since I am not using Oracle, then I should basically comment out the code in PHP.ini?

[wildteen88]

Correct.