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: mattficken@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: Website problem +Package: ODBC related Operating System: Windows 7 PHP Version: 5.6.3 Block user comment: N Private report: N New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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