[Firebird-odbc-devel] ADO or BDE connection to FireBird and Paradox tables?

[wei m. <wei...@ti...>]

Hi All, I'm currently using BDE, delphi7.0 and Interbase for my 
client-server application. Recently I'm thinking of replace Interbase 
with Firebird. Yet, I'm facing database connection problem with Firebird 
  via BDE, and as I read thru the forums, BDE is not the best tools to 
handling database connection between application and FireBird.

Hence I use ADO sets components to replace BDE set components, I still 
facing connection problem. My questions are as following:
1. Is there any precautions I should taking care before I start setting 
the properties in TADOConnection? Especially the ConnectionString, Can 
have a life example?

2. Can I use TADOConnection to start connection all the way to FireBird 
and PAradox just like what I did with TDatabase component, regardless to 
  set any DSN or Alias in neither BDE Administrator nor ODBC?

3. Is there any suggestion to migrate BDE based application to ADO 
architecture with minor migration?