Subject | ADO |
---|---|
Author | perryj313 |
Post date | 2002-02-18T18:08:23Z |
We recently converted our app from BDE to ADO so we could connect to
MS/SQL and Interbase. The MS/SQL connection is working great. My
problem is that I can not find an Interbase OLE/DB Provider that will
work. Our app is data entry and reporting programs written in Delphi
6 and is built around data-aware components. All data access
components are TADOQuery and TwwDataSource. I have tried EasySoft
ODBC and that seems slower than BDE. I have tried OLEDB.Net, Free
IBProvider, SIBProvider and ZStyle IB Provider each of them have
various problems. They all seem to be written for read only access.
Can you suggest the best method to connect to Interbase using ADO?
Or, tell me that it is hopeless and to go with Interbase specific
data access components.
Thanks
MS/SQL and Interbase. The MS/SQL connection is working great. My
problem is that I can not find an Interbase OLE/DB Provider that will
work. Our app is data entry and reporting programs written in Delphi
6 and is built around data-aware components. All data access
components are TADOQuery and TwwDataSource. I have tried EasySoft
ODBC and that seems slower than BDE. I have tried OLEDB.Net, Free
IBProvider, SIBProvider and ZStyle IB Provider each of them have
various problems. They all seem to be written for read only access.
Can you suggest the best method to connect to Interbase using ADO?
Or, tell me that it is hopeless and to go with Interbase specific
data access components.
Thanks