Request #8413 :: ODBC driver

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	Your email:

Comments Add patch

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:		Check to remember your password for next time:

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:

New Comment:

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