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)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
2011-12-20 10:04 UTC
Package:
Bug Type:
Summary:
From: ariel dot kempf at gmail dot com
New email:
PHP Version: Package Version: OS:

 

 [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.