Bug #68578 [Fbk->Opn]: 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 User updated by: rajendradewani at gmail dot com Reported by: rajendradewani at gmail dot com Summary: MS-Access's Linked tables are Not supported on PHP -Status: Feedback +Status: Open 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. As For the data source ( linked table to work ) you will have to install QuickBooks ( Preferred QuickBooks Enterprise - or my try trial edition of enterprise USA) and QODBC ( www.QODBC.com). Just install QuickBooks + QODBC and your ms-access file should get connect and should get data from QuickBooks. I have verified the ms-access file, if I open the linked table from ms-access I am able to connect to the source and it shows the table result in ms-access. Also, I have verified the ms-access file using it via asp.net, when i connect to the ms-access file using the same DSN which i used for PHP, i am able to query linked table and able to get result on web page. Previous Comments: ------------------------------------------------------------------------ [2015-01-13 15:02:10] ab@php.net 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. ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ 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