[PEAR-BUG] Req #8413 [Com]: ODBC driver

Edit report at http://pear.php.net/bugs/bug.php?id=8413&edit=1

 ID:              8413
 Comment by:      jonathanm
 Reported By:     jomeraz at atcdrivetrain dot com
 Summary:         ODBC driver
 Status:          Open
 Type:            Feature/Change Request
 Package:         MDB2
 Package Version: 2.2.0
 PHP Version:     5.1.4
 New Comment:

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.


Previous Comments:
------------------------------------------------------------------------

[2009-11-05 22:08:44] bryanboova

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();
}
?>

------------------------------------------------------------------------

[2007-12-09 15:57:38] davidc

Not that I know of. How much do you need it ?

------------------------------------------------------------------------

[2007-12-09 15:53:17] mrsocks

Is anyone working on this at all?
I NEED one now.

Any suggestions?

------------------------------------------------------------------------

[2007-11-12 08:00:40] castel

I could also need an ODBC driver, or even an OLE driver as there don't
exist a Pervasive driver.

------------------------------------------------------------------------

[2006-08-18 03:09:31] kellerkind018 at web dot de

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.

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://pear.php.net/bugs/bug.php?id=8413

-- 
Edit this bug report at http://pear.php.net/bugs/bug.php?id=8413&edit=1