Where is MDB2 odbc driver

[JormaH]

I have used PEAR DB to connect MS Access database. But now it says:
"This package has been superseded, but is still maintained for bugs and security fixes. Use MDB2 instead."

But there is no MDB2_Driver for ODBC connection.

Does anyone knows is there soon comming some driver, like DB package?
_________________
--- Jormah ---

[mrsocks]

JormaH

Did you ever find an ODBC driver for MDB2?

I NEED one and have been looking around.

What did you end up doing to?

Thanks.

[mark]

mrsocks, if you need the driver so much, why don't you write it yourself and contribute it back to the community?

[mrsocks]

[JormaH]

No, same problem continues.
And some other PHP forums I find almost same "answer":
You can add this function, just write it for yourself and for all users.
It will be cool.

I now looking third party solution and testing package like:
http://phpbuilder.blogspot.com/
This is for datagrid solution, but it use PEAR:DB as well.

[mrsocks]

[JormaH]

Ok, it would be nice.
I continue my testing with PHP Builder datagrid.

I have little holiday cottage booking software my to do list. My main problem is that their ISP supports only IIS/Access and therefore I must rewrite a lot of DB code if I can't find other solution.
I try Solunas Booking Engine, but new version is build with Ruby/Rails and old PHP Api supports only mysql functions, so mission impossible?

I look aroud about PHP Builder, I test it today with Access ODBC and keep you up to date.
_________________
--- Jormah ---

[JormaH]

Hi,
I found two interesting things

1) MDB2-2.4.1.tgz
-- I upload this to my web-server /files directory. You can download it there. Site lang is finnish, but filenames are universal
http://datatuki.sicom.fi/files --> PEAR-DB

2) DB_odbtp - this is included PHP Builder PEAR class - they says:
http://odbtp.sourceforge.net/

DB_odbtp is a PEAR DB driver that connects to a database using ODBTP (Open Database Transport Protocol). ODBTP allows any platform to remotely access the ODBC facilities on a Win32 host to connect to a database. A PHP application on a Linux, UNIX or Novell platform will be able to access a Microsoft SQL Server, Microsoft Access, Visual FoxPro, or any other database residing on a Win32 platform.

PHP developers on Windows can use the odbtp driver instead of the odbc, ado and mssql drivers. The odbtp extension provides better performance and more capabities than the extensions used by the other drivers. For example, Microsoft Access and Microsoft SQL Server can store UNICODE text data. However, the odbtp driver is the only one that provides full support for UNICODE text data and queries. The odbtp driver also has the exact behaviour on both Win32 and non-Win32 installations.


I hope this help you for MDB2 development. I'll wait for comments.
_________________
--- Jormah ---

[mrsocks]

Yeah, I had both of them open today looking at what it would take to get this working, but not sure if timing will allow me to get this driver working reliably.

Thanks for the info and I will let you know what I hear (if anything), or tell you what my result is (my own class to mimic the methods or change all the sql to php odbc_connect functions)

[JormaH]

Hi, one tiny question:
What kind of syntax you use to connect MS-Access with ODBC??

I can't get it working, I try:

[mrsocks]

I am not really sure. I havent used Access as a DB in years.
Sorry.

... as an update...
It looks like I wil be switching to Pear:B for now, but will let you know for sure soon.

[JormaH]

Ok.
That's the wild question.
I'm now really satisfied to mysql connection + PHP Builer Grid
It's totally cool!

But I'm still looking for MS-Access connection for reason that my customers ISP settings.

Waiting for.... some testing.

----
_________________
--- Jormah ---