Subject | Re: OLEDB Provider for Firebird |
---|---|
Author | lysander4444 |
Post date | 2004-05-06T11:10:31Z |
--- In firebird-support@yahoogroups.com, Anand <akashelkar@y...> wrote:
starting with firebird/delphi7 myself.
In Delphi-ADO you have access to provider "MS for ODBC" (MSDASQL.1).
If you also will install the firebird-odbc-driver by IBPhoenix, you
can use ADO-components to access your firebird-databases.
Using IBx-components, which also ship with delphi7 (component page
'Interbase'), you can also connect to Firebird. Working with security
topics (usernames and so on...) or with transactions is much better
with IBx than with ADO-components.
But I had some unexpected issues of "rowset read only" where it
definitely shouldn't be, and I did not have the time to pin it down,
or to look for a solution.
Using ADO-components with ODBC-driver works fine enough for me. Most
likely it can easily be changed later, when the application is bigger,
without making changes to essential code or to the database.
ciao,
André
> Does any OLEDB provider ship with the Delphi 7 CD? A casualI'm not sure if this is the best way to go, since I am just now
> search didn't
> yield anything. If a provider ships with Delphi 7 and works
> with IB6.0,
> probably it would also work with FB1.5?
starting with firebird/delphi7 myself.
In Delphi-ADO you have access to provider "MS for ODBC" (MSDASQL.1).
If you also will install the firebird-odbc-driver by IBPhoenix, you
can use ADO-components to access your firebird-databases.
Using IBx-components, which also ship with delphi7 (component page
'Interbase'), you can also connect to Firebird. Working with security
topics (usernames and so on...) or with transactions is much better
with IBx than with ADO-components.
But I had some unexpected issues of "rowset read only" where it
definitely shouldn't be, and I did not have the time to pin it down,
or to look for a solution.
Using ADO-components with ODBC-driver works fine enough for me. Most
likely it can easily be changed later, when the application is bigger,
without making changes to essential code or to the database.
ciao,
André