Bug #68578 [Opn->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: Open +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: 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. Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2014-12-23 19:07:20] ab@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ 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