Bug #78423 [Asn]: ODBC functions work without extension=odbc

Edit report at https://bugs.php.net/bug.php?id=78423&edit=1 ID: 78423 User updated by: dpfender44 at gmail dot com Reported by: dpfender44 at gmail dot com Summary: ODBC functions work without extension=odbc Status: Assigned Type: Bug Package: PHP options/info functions Operating System: Windows 10 PHP Version: 7.4.0beta2 Assigned To: cmb Block user comment: N Private report: N New Comment: C:\WINDOWS\system32>cd \php740 C:\PHP740>php --ini Configuration File (php.ini) Path: C:\WINDOWS Loaded Configuration File: C:\PHP740\php.ini Scan for additional .ini files in: (none) Additional .ini files parsed: (none) C:\PHP740>php -m |findstr odbc C:\PHP740>php -r "odbc_connect();" Fatal error: Uncaught Error: Call to undefined function odbc_connect() in Command line code:1 Stack trace: #0 {main} thrown in Command line code on line 1 C:\PHP740> C:\PHP740>cd \php739 C:\PHP739>php --ini Configuration File (php.ini) Path: C:\WINDOWS Loaded Configuration File: C:\PHP739\php.ini Scan for additional .ini files in: (none) Additional .ini files parsed: (none) C:\PHP739>php -m |findstr odbc C:\PHP739>php -r "odbc_connect();" Fatal error: Uncaught Error: Call to undefined function odbc_connect() in Command line code:1 Stack trace: #0 {main} thrown in Command line code on line 1 C:\PHP739> C:\PHP739>cd \php738 C:\PHP738>php --ini Configuration File (php.ini) Path: C:\WINDOWS Loaded Configuration File: C:\PHP738\php.ini Scan for additional .ini files in: (none) Additional .ini files parsed: (none) C:\PHP738>php -m |findstr odbc odbc C:\PHP738>php -r "odbc_connect();" Warning: odbc_connect() expects at least 3 parameters, 0 given in Command line code on line 1 C:\PHP738> --PHP script-- <?php if (!function_exists('odbc_connect')) { echo "<br><br><b>Function odbc_connect does not exist!</b><br>\n"; echo "Make sure that php.ini enables extension for odbc.<br>\n"; } else { -------- This error never occurs in 7.3.9RC1 or 7.4.0beta2, only in 7.3.8. Mysterious. The odbc functions work properly (odbc_connect, odbc_prepare, odbc_execute, odbc_num_rows) without php.ini enabled for odbc. It fails if I disable odbc in 7.3.8. Previous Comments: ------------------------------------------------------------------------ [2019-08-17 16:42:54] cmb@php.net D:\Users\cmb>curl -L -s --output php-7.3.9RC1-nts-Win32-VC15-x64.zip https://windows.php.net/downloads/qa/php-7.3.9RC1-nts-Win32-VC15-x64.zip D:\Users\cmb>7z x -ophp-7.3.9RC1-nts-Win32-VC15-x64 php-7.3.9RC1-nts-Win32-VC15-x64.zip > nul D:\Users\cmb>cd php-7.3.9RC1-nts-Win32-VC15-x64 D:\Users\cmb\php-7.3.9RC1-nts-Win32-VC15-x64>php --ini Configuration File (php.ini) Path: C:\WINDOWS Loaded Configuration File: (none) Scan for additional .ini files in: (none) Additional .ini files parsed: (none) D:\Users\cmb\php-7.3.9RC1-nts-Win32-VC15-x64>php -m | findstr odbc D:\Users\cmb\php-7.3.9RC1-nts-Win32-VC15-x64>php -r "odbc_connect();" Fatal error: Uncaught Error: Call to undefined function odbc_connect() in Command line code:1 Stack trace: #0 {main} thrown in Command line code on line 1 ------------------------------------------------------------------------ [2019-08-17 15:59:32] dpfender44 at gmail dot com There is only one php.ini file and Fast CGI is use in IIS to process PHP files. When I initially saw the problem, I tried changing the php.ini file to enable and then disable the extension=odbc line and saw no difference. I even powered off the computer and then back on with the extension disabled and it still works. I also searched the php.ini file for all occurrences of the string 'odbc' looking for another string that might enable it, but found none. Testing on the same system with PHP 7.3.8 and the same PHP script, it detects when the function 'odbc_connect' is not available when changing the php.ini option. PHP 7.3.9RC1 and 7.4.0beta2 have the same symptom. I did not submit this bug report until I tested all 3 versions of PHP using the same PHP script. ------------------------------------------------------------------------ [2019-08-17 15:38:14] requinix@php.net To make sure, 1. There is no other extension=odbc line in there, 2. There are no other INI files being loaded, and 3. If you modify that same php.ini and reload IIS/FPM, you see the changes reflected in code? ------------------------------------------------------------------------ [2019-08-17 15:34:39] dpfender44 at gmail dot com Two versions have the same symptom. php-7.3.9RC1-nts-Win32-VC15-x64.zip php-7.4.0beta2-nts-Win32-vs16-x64.zip I have double checked the php.ini being used and php.ini has ";extension=odbc". ------------------------------------------------------------------------ [2019-08-17 07:02:14] cmb@php.net The ODBC extension is still supposed to be compiled as DLL (and as such has to be explicitly loaded). This is the case with php-7.4.0beta2-nts-Win32-vs16-x64. Which exact version did you try? Have you double-checked, that the desired php.ini is used? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=78423 -- Edit this bug report at https://bugs.php.net/bug.php?id=78423&edit=1