Bug #68578 [Fbk]: MS-Access's Linked tables are Not supported on PHP

Edit report at https://bugs.php.net/bug.php?id=68578&edit=1 ID: 68578 Updated by: ab@php.net Reported by: rajendradewani at gmail dot com Summary: MS-Access's Linked tables are Not supported on PHP Status: Feedback Type: Bug Package: ODBC related Operating System: Windows 7 PHP Version: 5.6.3 Block user comment: N Private report: N New Comment: Ah, man ... i just see the linkedtable2.png and that warning is the exact issue. Ok. But you see that i don't have that data source at all, and i have the same warning. I guess the issue is in the .accdb file when it tries to connect to another data source. Thanks. Previous Comments: ------------------------------------------------------------------------ [2015-01-13 14:59:03] ab@php.net Hi, thanks for the update. And the holidays are passe :) I've tried your snippet, took one from before: oConnect = odbc_connect("QB Access", "", ""); $sSQL = "SELECT TOP 50 ListID, FullName, CompanyName FROM Customer"; $oResult = odbc_exec($oConnect, $sSQL); Unfortunately the issue is still blended by something else, namely here's the error message i see: Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'QuickBooks Data QRemote' failed., SQL state S1000 in SQLExecDirect in C:\php-sdk\php56\vc11\x64\php-src\68578\other.php on line 10 I see from your screenshot that you have several other data sources which probably communicate with each other. But I see anyway that the .accdb file you've supplied is way too complicated. As with the current test data the actual issue isn't reproduceable, I would like to ask you to simplify the DB file. Please note - we don't need your whole db file(s), it would be much better you to create a completely synthetic case. Like - one normal table, one linked table, some lines of the data. Btw. maybe that warning above already reveals you something why that error could be happening? Thanks. ------------------------------------------------------------------------ [2015-01-12 15:42:30] rajendradewani at gmail dot com Any updates on the reported issue. Please do let me know if any additional details is required. ------------------------------------------------------------------------ [2014-12-30 10:09:19] rajendradewani at gmail dot com Any updates on the reported issue. Please do let me know if any additional details is required. ------------------------------------------------------------------------ [2014-12-24 08:54:45] rajendradewani at gmail dot com Here is the requested information. Please note, you will have to create ms-access dns manually. https://dl.dropboxusercontent.com/u/5177330/temp/todelete/PHP%20Issue.zip Regards Raj ------------------------------------------------------------------------ [2014-12-24 08:54:04] rajendradewani at gmail dot com Here is the requested information. Please note, you will have to create ms-access dns manually. https://dl.dropboxusercontent.com/u/5177330/temp/todelete/PHP%20Issue.zip Regards Raj ------------------------------------------------------------------------ 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=68578 -- Edit this bug report at https://bugs.php.net/bug.php?id=68578&edit=1