| 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?
[2007年12月09日 20:57 UTC] davidc
(David Coallier)
Not that I know of. How much do you need it ?
[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.