| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 2.5.0b5 |
| Request #8413 | ODBC driver | ||
|---|---|---|---|
| Submitted: | 2006-08-10 19:48 UTC | ||
| From: | ariel dot kempf at gmail dot com | Assigned: | danielc |
| Status: | Closed | Package: | MDB2 (version 2.2.0) |
| PHP Version: | 5.1.4 | OS: | |
| Roadmaps: | (Not assigned) | ||
[2006-08-10 19:48 UTC] ariel dot kempf at gmail dot com
(Ariel)
Description:
------------
I find very usefull to have an ODBC driver, like the one in the DB package.
Is it planned to have an ODBC driver like we have in DB?
Comments
[2006-08-10 21:09 UTC] lsmith
(Lukas Smith)
I personally have no need for such a driver. I would of course welcome someone else who steps up to deliver such a driver. It should not be all that hard by using the PEAR::DB and Metabase driver as a basis.
[2006-08-18 07:09 UTC] kellerkind018 at web dot de
(Thomas)
An ODBC driver would be very helpful for me too. The only reason because I am not switching from DB to MDB2 at the moment, is the missing ODBC support in MDB2. Hopefully there will be one soon.
[2007-11-12 13:00 UTC] castel
(Jay Castel)
I could also need an ODBC driver, or even an OLE driver as there don't exist a Pervasive driver.
[2007-12-09 20:53 UTC] mrsocks
(Max Arbos)
Is anyone working on this at all?
I NEED one now.
Any suggestions?
[2009-11-06 03:08 UTC] bryanboova
(Bryan Boova)
Lukas is right.
I just installed PEAR: DB, then wrote:
<?php
// include required files
require_once 'XML/Query2XML.php';
require_once 'DB.php';
try {
$db = DB::connect('odbc://user:password@server/table');
$query2xml = XML_Query2XML::factory($db);
$sql="SELECT * FROM DATABASE ";
$xml = $query2xml->getFlatXML($sql);
header('Content-Type: text/xml');
$xml->formatOutput = true;
echo $xml->saveXML();
} catch (Exception $e) {
echo $e->getMessage();
}
?>
[2011-07-19 01:13 UTC] jonathanm
(Jonathan Meraz)
Just checking if anything has changed on this. While Lukas and Bryan are correct that one can install PEAR::DB to use ODBC, it's not a desirable solution because DB has been deprecated in favor of MDB2.
There doesn't seem to be much energy behind MDB2. Has it also been deprecated? If so, does anyone know what database package is current?
Thanks.
[2011-12-20 10:04 UTC] danielc
(Daniel Convissor)
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: danielc
An ODBC driver was added in August of 2010 and made it into the 2.5.0b3 release. I hope a new release of MDB2 will be out shortly.