Bug #69354 [Asn]: Incorrect use of SQLColAttributes with ODBC 3.0

Edit report at https://bugs.php.net/bug.php?id=69354&edit=1 ID: 69354 Updated by: ab@php.net Reported by: php at mdjnet dot dk Summary: Incorrect use of SQLColAttributes with ODBC 3.0 Status: Assigned Type: Bug Package: ODBC related Operating System: All PHP Version: 5.6.7 Assigned To: ab Block user comment: N Private report: N New Comment: Thanks for checking, closing. Previous Comments: ------------------------------------------------------------------------ [2015-04-05 12:35:48] php at mdjnet dot dk I have just tried out php-5.6-ts-windows-vc11-x86-rc585b48.zip, and it appears to working just fine with un-fixed odbc drivers. ------------------------------------------------------------------------ [2015-04-05 10:27:52] ab@php.net Please check the latest 5.5+ snapshots, the fixes was cherry picked. Thanks. ------------------------------------------------------------------------ [2015-04-03 06:21:13] php at mdjnet dot dk I just tried out the rf265928 snapshot, and it works fine. The odbc trace shows that now SQLColAttribute is called instead of SQLColAttributes. ------------------------------------------------------------------------ [2015-04-02 20:55:13] php at mdjnet dot dk Try to shoot this into your registry (assuming you put the driver in c:\windows\system32, and that you have a 64 bit Windows, otherwise remove the Wow6432Node part): Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\TestOdbc] "UsageCount"=dword:00000001 "Setup"="C:\\Windows\\System32\\TestOdbc.dll" "Driver"="C:\\Windows\\System32\\TestOdbc.dll" "APILevel"=dword:00000001 "ConnectFunction"="YYN" "DriverODBCVer"="03.00" "FileExtns"="" "FileUsage"=dword:00000000 "SQLLevel"=dword:00000000 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers] "TestOdbc"="Installed" - and you should have a driver ready to configure a DSN for. No database, no nothing else required, the odbc driver has it all within it. ------------------------------------------------------------------------ [2015-04-02 20:40:38] ab@php.net Yeah, I require really - a mdb file or sql file to import - which registry keys are to edit - the exact php code we call it "a self enclosed reproduce case" :) Otherwise it's really shooting in the sky. I was adding a test http://git.php.net/?p=php-src.git;a=commitdiff;h=f26592846f8190fdab6cb148e484a4aeb032c096 based on your PHP example, however it doesn't repro on the usual drivers. Also, maybe it's already fixed in master, so worth to check that snap. If it is, one could think about backporting it into 5.5/6 Thanks. ------------------------------------------------------------------------ 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=69354 -- Edit this bug report at https://bugs.php.net/bug.php?id=69354&edit=1