dbExpresse & access in Delphi 2007

[Koen]

It seems there is no MS Access driver in dbexpress that comes with Delphi
2007 (WIN32)?
Do I need to download it separately?
Regards Koen

[Casper Kirkegaard]

Hi Koen.

Im looking for the same driver and I can tell you it is not exactly easy to
find. I have been surfing the web for an entire day now without finding one
...

They have some open source drivers at sourceforge written for D7, but they
are not exactly easy to compile under 2007 ... I gave up, anyway ...

Let me know if you find something ...

Regards,

Casper

Post by Koen
It seems there is no MS Access driver in dbexpress that comes with Delphi
2007 (WIN32)?
Do I need to download it separately?
Regards Koen

[pp]

Hi,

Even I looking for the same. Please let me know if you find such
driver.

Thanks,

pp

Post by Casper Kirkegaard
Hi Koen.
Im looking for the same driver and I can tell you it is not exactly easy to
find. I have been surfing the web for an entire day now without finding one
...
They have some open source drivers at sourceforge written for D7, but they
are not exactly easy to compile under 2007 ... I gave up, anyway ...
Let me know if you find something ...
Regards,
Casper

Post by Koen
It seems there is no MS Access driver in dbexpress that comes with Delphi
2007 (WIN32)?
Do I need to download it separately?
Regards Koen- Hide quoted text -

- Show quoted text -

[Gerald Ebner]

Dear all,

we are also desperately looking for a way to connect to a Access DB using
DBX4. There isn't even a ODBC Bridge available for DBX4.
Im wondering if Borland is still serious about supporting DBX in the future.
It is strange that we have to beg for drivers from 3rd parties as Boralnd
either
* provides poor drivers (e.g. the DBX2 drivers for Oracle have been
incredibly buggy, in fact you have to buy the drivers developed)
* or no drivers at all (PG, Informix, ODBC, ...)

How should we interpret Borlands DBX policy ???

best regards
Gerald

Post by Casper Kirkegaard
Hi Koen.
Im looking for the same driver and I can tell you it is not exactly easy
to find. I have been surfing the web for an entire day now without finding
one ...
They have some open source drivers at sourceforge written for D7, but they
are not exactly easy to compile under 2007 ... I gave up, anyway ...
Let me know if you find something ...
Regards,
Casper

Post by Koen
It seems there is no MS Access driver in dbexpress that comes with Delphi
2007 (WIN32)?
Do I need to download it separately?
Regards Koen

[pp]

Hi All,

After lots of discussion and research it is been found that the only
way to connect MS Access and Delphi 2007 is using ADO connection.

Regards,

pp

Post by Gerald Ebner
Dear all,
we are also desperately looking for a way to connect to a Access DB using
DBX4. There isn't even a ODBC Bridge available for DBX4.
Im wondering if Borland is still serious about supporting DBX in the future.
It is strange that we have to beg for drivers from 3rd parties as Boralnd
either
* provides poor drivers (e.g. the DBX2 drivers for Oracle have been
incredibly buggy, in fact you have to buy the drivers developed)
* or no drivers at all (PG, Informix, ODBC, ...)
How should we interpret Borlands DBX policy ???
best regards
Gerald

Post by Casper Kirkegaard
Hi Koen.
Im looking for the same driver and I can tell you it is not exactly easy
to find. I have been surfing the web for an entire day now without finding
one ...
They have some open source drivers at sourceforge written for D7, but they
are not exactly easy to compile under 2007 ... I gave up, anyway ...
Let me know if you find something ...
Regards,
Casper

Post by Koen
It seems there is no MS Access driver in dbexpress that comes with Delphi
2007 (WIN32)?
Do I need to download it separately?
Regards Koen

[Markus.Humm]

Hello,

first: dbExpress is the current and afaik the furture access
technology for databases in Delphi.

CG only provides some drivers for the most used databases
(in their eyes most used). The current version supports dbx3 drivers via
some bridge machanism. If the ODBC driver which is in the public
somewhere is already a dbx3 driver it should work.

Many 3rd party vendord do develop dbExpress drivers, but obviously none
of them had any interest in a access driver. I'd rather suggest to
migrate those access databases to one of the available open source
databases if one doesn't need access specific features (like forms in a
database). For most popular open source databases (FireBird, MySQL,
PostgreSQL and others) there are divers already included or available
from 3rd parties.

Greetings

Markus

[Koen]

Past versions of Delphi natively supported DBase, Paradox & Access.. (tru
the BDE)
Keeping this in mind I assumed DBX4 would at least support these three..
Regards,
Koen

Post by Markus.Humm
Hello,
first: dbExpress is the current and afaik the furture access
technology for databases in Delphi.
CG only provides some drivers for the most used databases
(in their eyes most used). The current version supports dbx3 drivers via
some bridge machanism. If the ODBC driver which is in the public somewhere
is already a dbx3 driver it should work.
Many 3rd party vendord do develop dbExpress drivers, but obviously none of
them had any interest in a access driver. I'd rather suggest to migrate
those access databases to one of the available open source databases if
one doesn't need access specific features (like forms in a database). For
most popular open source databases (FireBird, MySQL, PostgreSQL and
others) there are divers already included or available from 3rd parties.
Greetings
Markus

[Bill Todd [TeamB]]

Post by Koen
Past versions of Delphi natively supported DBase, Paradox & Access..
(tru the BDE)

The Paradox and dBase DBMS is built into the BDE. There is no separate
database engine for connectivity layer such as dbExpress to connect to.
That is why CodeGear still distributes the BDE with RAD Studio 2007.

Post by Koen
Keeping this in mind I assumed DBX4 would at least
support these three..

DBX3 did not support them.

[Koen]

I do NOT want to use the BDE..

Post by Bill Todd [TeamB]

Post by Koen
Past versions of Delphi natively supported DBase, Paradox & Access..
(tru the BDE)

The Paradox and dBase DBMS is built into the BDE. There is no separate
database engine for connectivity layer such as dbExpress to connect to.
That is why CodeGear still distributes the BDE with RAD Studio 2007.

Post by Koen
Keeping this in mind I assumed DBX4 would at least
support these three..

DBX3 did not support them.
--
Bill Todd (TeamB)

[yannis]

Post by Koen
I do NOT want to use the BDE..

That does not make it more likely that CodeGear will deliver the
Paradox and DBase enginees as drivers for DBX4, on the contrary I would
expect.

regards
Yannis.

[Bill Todd [TeamB]]

Post by Koen
I do NOT want to use the BDE..

Then you cannot use Paradox tables. The only way you can use dBase
tables is with a third party dBase engine. The best way to work with
Access has always been the ADO components.

dbExpress is and always has been a connectivity layer for SQL database
servers.

[Gerald Ebner]

Post by Bill Todd [TeamB]
dbExpress is and always has been a connectivity layer for SQL database
servers.

I cannot agree to this policy, not at all.

There are n+1 SQL servers on the market and Borland cannot assume that the
3rd market will develop reliable drivers for all these servers (e.g.
postgresql). So why not simply provide a DBX-ODBC bridge for dbx4 (there is
just a old dbx2 solution on sourceforge)? so at least basic support for
almost any database would be given.

otherwise many companies (like us) will never upgrade to dbx4 ...

best regards
Gerald

Post by Bill Todd [TeamB]

Post by Koen
I do NOT want to use the BDE..

Then you cannot use Paradox tables. The only way you can use dBase
tables is with a third party dBase engine. The best way to work with
Access has always been the ADO components.
dbExpress is and always has been a connectivity layer for SQL database
servers.
--
Bill Todd (TeamB)

[Bill Todd [TeamB]]

Post by Gerald Ebner
There are n+1 SQL servers on the market and Borland cannot assume
that the 3rd market will develop reliable drivers for all these
servers (e.g. postgresql). So why not simply provide a DBX-ODBC
bridge for dbx4 (there is just a old dbx2 solution on sourceforge)?
so at least basic support for almost any database would be given.

I could not agree with you more. Why not enter this as a feature
request in QC, or, if it is already there, vote for it.

[Gerald Ebner]

thanks for the hint:

the feature request is:
http://qc.codegear.com/wc/qcmain.aspx?d=57783

please vote for it !!!

Post by Bill Todd [TeamB]

Post by Gerald Ebner
There are n+1 SQL servers on the market and Borland cannot assume
that the 3rd market will develop reliable drivers for all these
servers (e.g. postgresql). So why not simply provide a DBX-ODBC
bridge for dbx4 (there is just a old dbx2 solution on sourceforge)?
so at least basic support for almost any database would be given.

I could not agree with you more. Why not enter this as a feature
request in QC, or, if it is already there, vote for it.
--
Bill Todd (TeamB)