Bug #68578 [Csd->Asn]: 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: Closed +Status: Assigned Type: Bug Package: ODBC related Operating System: Windows 7 PHP Version: 5.6.3 Block user comment: N Private report: N New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2014-12-12 08:05:54] ab@php.net Hi, we need a worky code and db file, not just a description. Thanks. ------------------------------------------------------------------------ [2014-12-10 13:16:16] rajendradewani at gmail dot com Create a ms-access file. Then create a linked table ( you can create linked table of any source, I have used QODBC driver, but it does not matter). then create a System DSN which points to ms-access file. then i am using below code, i did debug and found its able to connect but when querying the linked table it fails, when I query a physical/local table "localtable" which is on the ms-access file, the code works. $oConnect = odbc_connect("myAccessDSN", "", ""); #Set the SQL Statement $sSQL = "SELECT TOP 50 ListID, FullName, CompanyName FROM Customer"; #$sSQL = "SELECT TOP 50 ListID, FullName, CompanyName FROM localtable"; #Perform the query $oResult = odbc_exec($oConnect, $sSQL); ------------------------------------------------------------------------ [2014-12-09 18:13:28] mattficken@php.net Sounds like this isn't a problem with the php.net web site. PHP doesn't have its own driver for the MS-Access database. You are either using the odbc or pdo_odbc extension to use an MS-Access driver provided by Microsoft that you've already installed on your Windows box. Neither the odbc or pdo_odbc extension know about linked tables or other features specific to a database provider (MS-Access, etc...), they simply provide a consistent API to access different database providers and pass requests along. Its unlikely the problem is there, but with some info, we could tell. As with any issue, you need to take some time to provide us a repro case: a sample of the PHP code and/or the MS Access file and/or information about which MS-Access driver you are using before we can take time to help. To tell which MS-Access driver you are using, copy the DSN information from the 'Set up data sources (ODBC)' applet in the Windows Control Panel. ------------------------------------------------------------------------ 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