Difference of SQLdb and Zeos

[JD]

SQLdb also supports many databases protocols: Firebird/Interbase, MySQL, SQLite3, PostgreSQL, Oracle & has ODBC support.

But Zeos supports all that (except ODBC AFAIK) & even more. 

[Dibo]

And I remember, ZEOS probably have component specialy for FireBird Events

[marcov]

I think major diference is that ZEOS have support for multiple database types. Company can write base framework on ZEOS and is not restricted to only one database. If client have MSSQL, they just switch ZEOS "Protocol" property to MSSQL, if client want Oracle, they switch to Oracle protocol and so on. Of course, this dosn't solve problems with SQL syntax.

Interesting, you got this to work with Lazarus? Afaik OLEDB is not supported with Lazarus.

[Dibo]

No, this was only example of ZEOS idea

[xenblaise]

I think sqlDb and Zeos differ in properties

I have NOT use Zeos, But if Zeos has a feature of

you don't to change anything in your configuration property if you want to switch from mysql to mssql or sqlite or msaccess connection, then bravo, the best.

using sqlDb has to change some properties if using different data models or sql connection.

eq.,
if wanna use mysql, we have to do like this;
mysqldbconnection._the_Here_property_not_in_msSQL_or_MsSQLite := ? then its normal

but if Zeos has;
mysqldbconnection._the__Here_property_iS_the_same_with_msSQL_or_MsSQLite := ? then the best. ( i doubt is not like this)