Re: PEAR DB and DB_ado

Jonas Koch Bentzen said: > I'm confused... I thought the idea behind PEAR DB was to solve the > problem of having 100 different database APIs for PHP. PEAR DB > should provide us with a common way of accessing different > databases. But here comes DB_ado - doesn't that give us yet > another way of accessing > databases? Nope, DB_ado is just yet another driver class that makes use of the COM extension, so you can only use it on Windows systems. As it inherits from DB_common, it offers the same API as all DB driver classes do. DB_ado uses calls to Microsoft´s ADO interface, which makes it possible to connect to many different datasources, like MSSQL, Access or even Excel spreadsheets. You could of course also use ODBC for that, but so far DB_ado seems to be a more flexible choice, and also seems to be more feature-complete than the DB_odbc driver (ie. tableInfo). > retorical question. Like I said, I can't really figure out from > looking at the source code whether DB_ado requires a new syntax or > not. Why not just try it out? ;-) Regards, Markus -- *21st Media* | Consulting, Konzeption, Produktion für die Bereiche: Markus Wolff | Internet, Intranet, eCommerce, Content Management, Hamburg,Germany | Softwareentwicklung, 3D-Animation, Videostreaming http://21st.de | Tel. [+49](0)40/6887949-0, Fax: [+49](0)40/6887949-1