Portable databases

Craig Reynolds

Delphi Developer

Sun, 12 Oct 2003 10:52:28 GMT

Portable databases

Is it possible with any of the DB formats available to delphi to make a
program that anables you to simply carry around a copy of the program, the
DB, and Whatever DLL's it may need?

This would probvably involve creating whatever connections are necessary
when the program starts and destroying them at close, and not needing to
have anything preinstalled on the computer that the program is on.

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

M.H. Avegaar

Delphi Developer

Sun, 12 Oct 2003 15:11:15 GMT

Re:Portable databases

The default database support for Delphi is provided by the BDE, which can
not be easily moved. Try a BDE replacement like DBISAM instead (for a list
see http://www.kylecordes.com/bag/index.html).

ps. If you only want to use a simple table you can use the TClientDataSet
from Delphi 4 C/S or Delphi 5 Enterprise.

"Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
news:3ae63bde$0$18709@echo-01.iinet.net.au...

Quote

> Is it possible with any of the DB formats available to delphi to make a
> program that anables you to simply carry around a copy of the program, the
> DB, and Whatever DLL's it may need?

> This would probvably involve creating whatever connections are necessary
> when the program starts and destroying them at close, and not needing to
> have anything preinstalled on the computer that the program is on.

> --
> ~~~~~~~~~~~~~
> ?raig ?eynolds
> ~~~~~~~~~~~~~
> Just becuase this is never going to work is no reason to be negative!

Craig Reynold

Delphi Developer

Sun, 12 Oct 2003 16:20:27 GMT

Re:Portable databases

Do you happen to know of any free alternatives to the BDE?

The reason I want to do this is that I have a small application that I have
written to track all of my books, and novels. It was originally in VB,using
Access DB. I have decided to switch my programming efforts to delphi, and
all has gone well. I would like to be able to tke this program with me and
not worry about whether the DB support will be there. I am willing to change
DB formats if necessary.
--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message

news:9c5tck$jnb$1@porthos.nl.uu.net...

Quote

> The default database support for Delphi is provided by the BDE, which can
> not be easily moved. Try a BDE replacement like DBISAM instead (for a list
> see http://www.kylecordes.com/bag/index.html).

> ps. If you only want to use a simple table you can use the TClientDataSet
> from Delphi 4 C/S or Delphi 5 Enterprise.

> "Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
> news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > Is it possible with any of the DB formats available to delphi to make a
> > program that anables you to simply carry around a copy of the program,
the
> > DB, and Whatever DLL's it may need?

> > This would probvably involve creating whatever connections are necessary
> > when the program starts and destroying them at close, and not needing to
> > have anything preinstalled on the computer that the program is on.

> > --
> > ~~~~~~~~~~~~~
> > ?raig ?eynolds
> > ~~~~~~~~~~~~~
> > Just becuase this is never going to work is no reason to be negative!

M.H. Avegaar

Delphi Developer

Sun, 12 Oct 2003 16:52:05 GMT

Re:Portable databases

If you want to keep using the MS Access database you should use a DAO or ADO
BDE replacement (still requires DAO or ADO and the MS Jet drivers to be
installed on the target PC !).
There is no freeware DAO TDataSet component available. For ADO, Delphi 5
Enterprise includes ADOExpress and for other versions you can try the
freeware ADO DataSet from http://www.agric.za/freeway/ADOds.htm.

"Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
news:3ae688bc$0$18679@echo-01.iinet.net.au...

Quote

> Do you happen to know of any free alternatives to the BDE?

> The reason I want to do this is that I have a small application that I
have
> written to track all of my books, and novels. It was originally in
VB,using
> Access DB. I have decided to switch my programming efforts to delphi, and
> all has gone well. I would like to be able to tke this program with me and
> not worry about whether the DB support will be there. I am willing to
change
> DB formats if necessary.
> --
> ~~~~~~~~~~~~~
> ?raig ?eynolds
> ~~~~~~~~~~~~~
> Just becuase this is never going to work is no reason to be negative!
> "M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message
> news:9c5tck$jnb$1@porthos.nl.uu.net...
> > The default database support for Delphi is provided by the BDE, which
can
> > not be easily moved. Try a BDE replacement like DBISAM instead (for a
list
> > see http://www.kylecordes.com/bag/index.html).

> > ps. If you only want to use a simple table you can use the
TClientDataSet
> > from Delphi 4 C/S or Delphi 5 Enterprise.

> > "Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
> > news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > > Is it possible with any of the DB formats available to delphi to make
a
> > > program that anables you to simply carry around a copy of the program,
> the
> > > DB, and Whatever DLL's it may need?

> > > This would probvably involve creating whatever connections are
necessary
> > > when the program starts and destroying them at close, and not needing
to
> > > have anything preinstalled on the computer that the program is on.

> > > --
> > > ~~~~~~~~~~~~~
> > > ?raig ?eynolds
> > > ~~~~~~~~~~~~~
> > > Just becuase this is never going to work is no reason to be negative!

Craig Reynold

Delphi Developer

Sun, 12 Oct 2003 17:04:51 GMT

Re:Portable databases

Unfortunatley I am stuck with Delphi 4 std

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message

news:9c639n$n7s$1@porthos.nl.uu.net...

Quote

> If you want to keep using the MS Access database you should use a DAO or
ADO
> BDE replacement (still requires DAO or ADO and the MS Jet drivers to be
> installed on the target PC !).
> There is no freeware DAO TDataSet component available. For ADO, Delphi 5
> Enterprise includes ADOExpress and for other versions you can try the
> freeware ADO DataSet from http://www.agric.za/freeway/ADOds.htm.

> "Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
> news:3ae688bc$0$18679@echo-01.iinet.net.au...
> > Do you happen to know of any free alternatives to the BDE?

> > The reason I want to do this is that I have a small application that I
> have
> > written to track all of my books, and novels. It was originally in
> VB,using
> > Access DB. I have decided to switch my programming efforts to delphi,
and
> > all has gone well. I would like to be able to tke this program with me
and
> > not worry about whether the DB support will be there. I am willing to
> change
> > DB formats if necessary.
> > --
> > ~~~~~~~~~~~~~
> > ?raig ?eynolds
> > ~~~~~~~~~~~~~
> > Just becuase this is never going to work is no reason to be negative!
> > "M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message
> > news:9c5tck$jnb$1@porthos.nl.uu.net...
> > > The default database support for Delphi is provided by the BDE, which
> can
> > > not be easily moved. Try a BDE replacement like DBISAM instead (for a
> list
> > > see http://www.kylecordes.com/bag/index.html).

> > > ps. If you only want to use a simple table you can use the
> TClientDataSet
> > > from Delphi 4 C/S or Delphi 5 Enterprise.

> > > "Craig Reynolds" <reynoldscra...@hotmail.com> schreef in bericht
> > > news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > > > Is it possible with any of the DB formats available to delphi to
make
> a
> > > > program that anables you to simply carry around a copy of the
program,
> > the
> > > > DB, and Whatever DLL's it may need?

> > > > This would probvably involve creating whatever connections are
> necessary
> > > > when the program starts and destroying them at close, and not
needing
> to
> > > > have anything preinstalled on the computer that the program is on.

> > > > --
> > > > ~~~~~~~~~~~~~
> > > > ?raig ?eynolds
> > > > ~~~~~~~~~~~~~
> > > > Just becuase this is never going to work is no reason to be
negative!

Bruce Biddl

Delphi Developer

Sun, 12 Oct 2003 21:30:41 GMT

Re:Portable databases

Hi Craig

Have a look at this

BDE32 component - freeware
The main feature of this component is the ability to run applications
without the BDE installed.
BUT !! the BDE files still need to be available somewhere on the PC or a
network
You can get it from
http://www.kestrelsoftware.co.uk

Regards

Bruce
--

Quote

"Craig Reynolds" <reynoldscra...@hotmail.com> wrote in message

news:3ae63bde$0$18709@echo-01.iinet.net.au...

Quote

> Is it possible with any of the DB formats available to delphi to make a
> program that anables you to simply carry around a copy of the program, the
> DB, and Whatever DLL's it may need?

> This would probvably involve creating whatever connections are necessary
> when the program starts and destroying them at close, and not needing to
> have anything preinstalled on the computer that the program is on.

> --
> ~~~~~~~~~~~~~
> ?raig ?eynolds
> ~~~~~~~~~~~~~
> Just becuase this is never going to work is no reason to be negative!

Dan Brenna

Delphi Developer

Sun, 12 Oct 2003 22:11:08 GMT

Re:Portable databases

On Wed, 25 Apr 2001 17:04:51 +0800, "Craig Reynolds"

Quote

<reynoldscra...@hotmail.com> wrote:
>Unfortunatley I am stuck with Delphi 4 std

How big is the database? If it is not more than several thousand
records, and if the manipulations are very simple, you might be able
to use a simple text file and make your own "engine" to find things.
If you need very complicated searches, for example, this probably
would be too much work to write. But if all you need is to filter on
dates, author, title, then it should be simple enough to just read
through a text file and do string comparisons. Slow, but works.

Dan
--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control:
visit us at www.cmdcsystems.com
[SPAM block: change at to @ in my e-mail address]

Craig Reynold

Delphi Developer

Sun, 12 Oct 2003 22:18:57 GMT

Re:Portable databases

It would be feasable at this stage I guess, but its a lot of work that I
would rather not do. Given that the DB is goinf to grow over the years, it's
also likely that this will become inefficient and unweildy eventually

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"Dan Brennand" <D...@CMDCsystems.com> wrote in message

news:3ae6d95f.69490625@news.dimensional.com...

Quote

> On Wed, 25 Apr 2001 17:04:51 +0800, "Craig Reynolds"
> <reynoldscra...@hotmail.com> wrote:

> >Unfortunatley I am stuck with Delphi 4 std

> How big is the database? If it is not more than several thousand
> records, and if the manipulations are very simple, you might be able
> to use a simple text file and make your own "engine" to find things.
> If you need very complicated searches, for example, this probably
> would be too much work to write. But if all you need is to filter on
> dates, author, title, then it should be simple enough to just read
> through a text file and do string comparisons. Slow, but works.

> Dan
> --
> Dan Brennand
> CMDC systems, inc.
> Configuration Management and Document Control:
> visit us at www.cmdcsystems.com
> [SPAM block: change at to @ in my e-mail address]

Craig Reynold

Delphi Developer

Sun, 12 Oct 2003 22:21:13 GMT

Re:Portable databases

looks good, but is not quite what I'm after. It seems that Delphi's DB
interfacing is not quite as free as what I have experienced when using VB,
but I guess it is something that I am going to have to deal with at some
stage. Hopefully I will eventually be able to use ADOExpress or something
simple.

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"Bruce Biddle" <bruce.bid...@ntlworld.comNO_SPAM> wrote in message

news:NmAF6.2067$lq1.108764@news6-win.server.ntlworld.com...

Quote

> Hi Craig

> Have a look at this

> BDE32 component - freeware
> The main feature of this component is the ability to run applications
> without the BDE installed.
> BUT !! the BDE files still need to be available somewhere on the PC or a
> network
> You can get it from
> http://www.kestrelsoftware.co.uk

> Regards

> Bruce
> --

> "Craig Reynolds" <reynoldscra...@hotmail.com> wrote in message
> news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > Is it possible with any of the DB formats available to delphi to make a
> > program that anables you to simply carry around a copy of the program,
the
> > DB, and Whatever DLL's it may need?

> > This would probvably involve creating whatever connections are necessary
> > when the program starts and destroying them at close, and not needing to
> > have anything preinstalled on the computer that the program is on.

> > --
> > ~~~~~~~~~~~~~
> > ?raig ?eynolds
> > ~~~~~~~~~~~~~
> > Just becuase this is never going to work is no reason to be negative!

Craig Reynold

Delphi Developer

Mon, 13 Oct 2003 17:04:34 GMT

Re:Portable databases

actually, having thought about it, I think that I will look into it.

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"Bruce Biddle" <bruce.bid...@ntlworld.comNO_SPAM> wrote in message

news:NmAF6.2067$lq1.108764@news6-win.server.ntlworld.com...

Quote

> Hi Craig

> Have a look at this

> BDE32 component - freeware
> The main feature of this component is the ability to run applications
> without the BDE installed.
> BUT !! the BDE files still need to be available somewhere on the PC or a
> network
> You can get it from
> http://www.kestrelsoftware.co.uk

> Regards

> Bruce
> --

> "Craig Reynolds" <reynoldscra...@hotmail.com> wrote in message
> news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > Is it possible with any of the DB formats available to delphi to make a
> > program that anables you to simply carry around a copy of the program,
the
> > DB, and Whatever DLL's it may need?

> > This would probvably involve creating whatever connections are necessary
> > when the program starts and destroying them at close, and not needing to
> > have anything preinstalled on the computer that the program is on.

> > --
> > ~~~~~~~~~~~~~
> > ?raig ?eynolds
> > ~~~~~~~~~~~~~
> > Just becuase this is never going to work is no reason to be negative!

Craig Reynold

Delphi Developer

Mon, 13 Oct 2003 22:15:13 GMT

Re:Portable databases

You wouldn't happen to know what files I need to make this work with access
by any chance.

--
~~~~~~~~~~~~~
?raig ?eynolds
~~~~~~~~~~~~~
Just becuase this is never going to work is no reason to be negative!

Quote

"Bruce Biddle" <bruce.bid...@ntlworld.comNO_SPAM> wrote in message

news:NmAF6.2067$lq1.108764@news6-win.server.ntlworld.com...

Quote

> Hi Craig

> Have a look at this

> BDE32 component - freeware
> The main feature of this component is the ability to run applications
> without the BDE installed.
> BUT !! the BDE files still need to be available somewhere on the PC or a
> network
> You can get it from
> http://www.kestrelsoftware.co.uk

> Regards

> Bruce
> --

> "Craig Reynolds" <reynoldscra...@hotmail.com> wrote in message
> news:3ae63bde$0$18709@echo-01.iinet.net.au...
> > Is it possible with any of the DB formats available to delphi to make a
> > program that anables you to simply carry around a copy of the program,
the
> > DB, and Whatever DLL's it may need?

> > This would probvably involve creating whatever connections are necessary
> > when the program starts and destroying them at close, and not needing to
> > have anything preinstalled on the computer that the program is on.

> > --
> > ~~~~~~~~~~~~~
> > ?raig ?eynolds
> > ~~~~~~~~~~~~~
> > Just becuase this is never going to work is no reason to be negative!

Other Threads

1. Portable databases

2. Portable database

3. Using SQl to be portable to any database

4. more than 640K of memory -- portable solution

5. Communications with Portable Terminals

6. 12V portable electronic Cooler/warmers

7. portable stored procedure: How?

8. delphi/sql apps portable (stringtables)?

9. portable source (from Borland to GPC, FPC...)

10. How to keep the code portable? (FPC)