Dominika Posted November 6, 2008 Share Posted November 6, 2008 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 :-) Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/ Share on other sites More sharing options...
bobbinsbro Posted November 6, 2008 Share Posted November 6, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683679 Share on other sites More sharing options...
revraz Posted November 6, 2008 Share Posted November 6, 2008 This is an Oracle DLL, so if you use a Oracle backend, you need to inform your host to enable this support. Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683681 Share on other sites More sharing options...
JonnoTheDev Posted November 6, 2008 Share Posted November 6, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683682 Share on other sites More sharing options...
Dominika Posted November 6, 2008 Author Share Posted November 6, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683699 Share on other sites More sharing options...
Dominika Posted November 6, 2008 Author Share Posted November 6, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683705 Share on other sites More sharing options...
JonnoTheDev Posted November 6, 2008 Share Posted November 6, 2008 The php.ini file will be loading it. Doesnt matter what functions you are using. Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683706 Share on other sites More sharing options...
wildteen88 Posted November 6, 2008 Share Posted November 6, 2008 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) Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683818 Share on other sites More sharing options...
Dominika Posted November 6, 2008 Author Share Posted November 6, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683831 Share on other sites More sharing options...
wildteen88 Posted November 6, 2008 Share Posted November 6, 2008 Correct. Quote Link to comment https://forums.phpfreaks.com/topic/131634-phpv505-upgrade-to-phpv526/#findComment-683844 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.