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, we need a worky code and db file, not just a description. Thanks. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2014-12-09 17:25:48] ab@php.net Could you please provide a short worky reproduce case including a PHP snippet and an Access database file? Thanks. ------------------------------------------------------------------------ [2014-12-09 16:24:00] rajendradewani at gmail dot com Description: ------------ HI, I have a ms-access file which has linked table. The linked table is connected to a ODBC source (e.g MS-SQL or 3rd Party ODBC Driver). WebPage(php) Apache, connecting to a ODBC DSN of MS-Access, MS-Access is having linked tables. Linked tables as from another ODBC source. On the PHP Page, When I am trying to connect the ms-access odbc dsn , I am able to connect. But when I query any of the linked tables, PHP is not able to query and is failing. Does php has capabilities to read/write to linked tables in ms-access file. Or it is issue with MS-Access Or is it I am missing something. Microsoft says, its an issue of PHP https://social.msdn.microsoft.com/Forums/office/en-US/04d10d5d-698b-404b-8eef-7b16d83ac99b/does-msaccesss-linked-tables-are-supports-on-php?forum=accessdev Regards Rajendra Dewani ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=68578&edit=1