Zend_Db adapter for ODBC

[phpoptimizer]

I want to connect to MS Access database using ZF components but I
haven't found Zend_Db adapter for ODBC. Does ZF have this kind of
adapter or I need to use a third party one?

[tfk]

On Mon, May 11, 2009 at 5:28 PM, Kostyantyn Shakhov <[hidden email]> wrote:
> I want to connect to MS Access database using ZF components but I
> haven't found Zend_Db adapter for ODBC. Does ZF have this kind of
> adapter or I need to use a third party one?
>

There's none in trunk. No idea if someone started working on one though:
http://framework.zend.com/svn/framework/standard/trunk/library/Zend/Db/Adapter/

Might double-check the wiki and open issues in Jira if there is work.
Otherwise, I'm sure it would be awesome if you could contribute one.

Till

[janpolsen]

phpoptimizer wrote:

I want to connect to MS Access database using ZF components but I
haven't found Zend_Db adapter for ODBC. Does ZF have this kind of
adapter or I need to use a third party one?

You might want to take a look at http://framework.zend.com/issues/browse/ZF-3493, which has a tiny patch for "implementing" ODBC through PDO.

[vinnybozz]

The ticket seems to be closed and not in any future plans.

I needed those classes to work with an ODBC Adapter, so I tried my hand at creating one, and it seems to work okay...

I made a github project out of it if anyone is interested:
http://github.com/vinnybozz/Zend_Db_Adapter_Odbc

janpolsen wrote:

phpoptimizer wrote:

I want to connect to MS Access database using ZF components but I
haven't found Zend_Db adapter for ODBC. Does ZF have this kind of
adapter or I need to use a third party one?

You might want to take a look at http://framework.zend.com/issues/browse/ZF-3493, which has a tiny patch for "implementing" ODBC through PDO.

[janpolsen]

vinnybozz wrote:

The ticket seems to be closed and not in any future plans.

I needed those classes to work with an ODBC Adapter, so I tried my hand at creating one, and it seems to work okay...

I am still (sadly) manually editing a few files every time I update the Zend Framework in order to get the ODBC functionality.

Those changes are based on Bart McLeod (http://framework.zend.com/issues/browse/ZF-3493) and some additional changes in order to give "trusted connection" functionality (http://framework.zend.com/issues/browse/ZF-6739).

My qustion is: Does your changes provide the same and/or additional functionality?

It's a PITA to manually edit the files on each update :(.