Multiple Databases
Posted: 11.11.2005, 12:14
Hi
I am trying to test ZeosDBO to work with multiple databases. I started of with MSSQL, MySQL, Firebird and PostGresSQL.
I created domains and then some tables in all databases. Then I tried accessing a table from different database and soon found that MySQL 5 is not supported by ZeosDBO. So I ignored MySQL. Then I found for some reason all fields from table in PostgresSQL were not fetched. So I ignored it as well(I suspect that domains are causing this problem as the tables created without domain are working ok. Looks like a bug in ZeosDBO 6.5.1).
Then I tried Firebird and everything was ok until I added persistent fields to client dataset and then changed protocol to use MSSQL. The Autoinc field from Firebird is TLargeIntField and from MSSQL is TFloatField. So what it comes down to is I cannot use ZeosDBO to write application that can work with multiple databases. I may be wrong here, if I am I'll be glad and would like some guidelines on how to write the application so that I can switch from one database to another.
Regards
Sandeep
I am trying to test ZeosDBO to work with multiple databases. I started of with MSSQL, MySQL, Firebird and PostGresSQL.
I created domains and then some tables in all databases. Then I tried accessing a table from different database and soon found that MySQL 5 is not supported by ZeosDBO. So I ignored MySQL. Then I found for some reason all fields from table in PostgresSQL were not fetched. So I ignored it as well(I suspect that domains are causing this problem as the tables created without domain are working ok. Looks like a bug in ZeosDBO 6.5.1).
Then I tried Firebird and everything was ok until I added persistent fields to client dataset and then changed protocol to use MSSQL. The Autoinc field from Firebird is TLargeIntField and from MSSQL is TFloatField. So what it comes down to is I cannot use ZeosDBO to write application that can work with multiple databases. I may be wrong here, if I am I'll be glad and would like some guidelines on how to write the application so that I can switch from one database to another.
Regards
Sandeep