Board index » delphi » Distributing Interbase Database Appplication

Distributing Interbase Database Appplication

Hi gang,

I have wrote a program that uses a interbase database backened.  I am usign
the interbase componenets that come with Delphi 5.  I would like to
distribute the application so it can run directly off the CD.

Thanks in advace

 

Re:Distributing Interbase Database Appplication


Quote
In article <3b04f242_1@dnews>, juli...@bellsouth.net wrote...

Hi,

Quote
> I have wrote a program that uses a interbase database backened.  I am usign
> the interbase componenets that come with Delphi 5.  I would like to
> distribute the application so it can run directly off the CD.

Whilst it is possible in FB/IB6 to create a read-only database that can
be used directly off the CD, you will need to install the server on the
client machine.

Cheers

Phil

Re:Distributing Interbase Database Appplication


I have 5.5 running.  What process do I take to install Firebrid.   Once
Firebird is installed what steps do I have to take to distribute my
application on cd
so it can be raned off my cd. Thanks.
Quote
"Phil Shrimpton" <p...@nospam.co.uk> wrote in message

news:MPG.156f15a0eb852bfd9896ed@newsgroups.borland.com...
Quote
> In article <3b04f242_1@dnews>, juli...@bellsouth.net wrote...

> Hi,

> > I have wrote a program that uses a interbase database backened.  I am
usign
> > the interbase componenets that come with Delphi 5.  I would like to
> > distribute the application so it can run directly off the CD.

> Whilst it is possible in FB/IB6 to create a read-only database that can
> be used directly off the CD, you will need to install the server on the
> client machine.

> Cheers

> Phil

Re:Distributing Interbase Database Appplication


Quote
In article <3b0515aa$1_1@dnews>, jbl...@aamsi.com wrote...

Hi,

Quote
> I have 5.5 running.  

Version 5.5 has serious problems, you should upgrade to 5.6 (free).

Quote
> What process do I take to install Firebrid.

The same as Interbase and 'commercial Interbase, they all allow 'read-
only' databases.  Each version has an installation program, but if you
want a 'silent' one, you can roll your own (take a look at
http://ibinstall.defined.net/)

Quote
> Once
> Firebird is installed what steps do I have to take to distribute my
> application on cd
> so it can be raned off my cd.

You would need to install the IB/FB server and client on the machine
that you want to run it from, and use the CDROM drive in the connection
string. (e.g.  LocalHost:\\D:\MyDatabase.gdb)

Cheers

Phil

Re:Distributing Interbase Database Appplication


Quote
In article <3b05276d_2@dnews>, jbl...@aamsi.com wrote...

Hi,

Quote
>     Phil.  Maybe I wasn't clear in my news post or maybe I do not understand
> your reply.  This cd will be distributed .  I just want the user to pop in
> the cd and run it off there without doing any installs.

Interbase is a database 'server', so the server needs to be installed
and running to be able to use a database file (which can live on a CD).

If you don't want to do any installs, you can't use Interbase (or any
other 'database' server).

Quote
>  It is a real simple
> database app.  It has only one form.  It just allows the users to just view
> the data and perfroms searches based on two fields.

>     Is it possible to load a text file into a table component, connect it to
> a grid via datasource, and  and view  the data and perfrom searches on it. I
> tried to do it but I am being prompt for a tablename in the properties tab.

Take a look at TClientDataset, that can work standalone and save/load
data to/from a 'file'

Quote
> I was thinking about using a msacess table.  What are you thoughts on that.

You would still need to install Access.

Quote
> I just want to make this as simple as possible.  I am looking into ASP but
> this current app must be out ASAP.

ASP is for developing Webpages, or does it mean something else today <g>

Cheers

Phil

Re:Distributing Interbase Database Appplication


    Phil.  Maybe I wasn't clear in my news post or maybe I do not understand
your reply.  This cd will be distributed .  I just want the user to pop in
the cd and run it off there without doing any installs.  It is a real simple
database app.  It has only one form.  It just allows the users to just view
the data and perfroms searches based on two fields.

    Is it possible to load a text file into a table component, connect it to
a grid via datasource, and  and view  the data and perfrom searches on it. I
tried to do it but I am being prompt for a tablename in the properties tab.

I was thinking about using a msacess table.  What are you thoughts on that.
I just want to make this as simple as possible.  I am looking into ASP but
this current app must be out ASAP.

Thanks.

Quote
"Phil Shrimpton" <p...@nospam.co.uk> wrote in message

news:MPG.156f2e08b17d553a9896ee@newsgroups.borland.com...
Quote
> In article <3b0515aa$1_1@dnews>, jbl...@aamsi.com wrote...

> Hi,

> > I have 5.5 running.

> Version 5.5 has serious problems, you should upgrade to 5.6 (free).

> > What process do I take to install Firebrid.

> The same as Interbase and 'commercial Interbase, they all allow 'read-
> only' databases.  Each version has an installation program, but if you
> want a 'silent' one, you can roll your own (take a look at
> http://ibinstall.defined.net/)

> > Once
> > Firebird is installed what steps do I have to take to distribute my
> > application on cd
> > so it can be raned off my cd.

> You would need to install the IB/FB server and client on the machine
> that you want to run it from, and use the CDROM drive in the connection
> string. (e.g.  LocalHost:\\D:\MyDatabase.gdb)

> Cheers

> Phil

Re:Distributing Interbase Database Appplication


Thanks friend. As you can see I am running around like a chicken with its
head cut off tyring to get this thing out. .  What you said makes plenty of
sense.  I started off intially using text files. But I was using the table
componet and that failed miserably.  I never delpoyed applications
externally only internally. So execuse if my questions are dumb

I will look into tcleintdataset.  If  it does what I want it to do, all I
would have to do is distribute my executable and the text file , correct ?

started of inI just have one other question about Tclientdataset.  I am
currently using that component for my midas application I had created.

Quote
"Phil Shrimpton" <p...@nospam.co.uk> wrote in message

news:MPG.156f3b0f3f531a809896f2@newsgroups.borland.com...
Quote
> In article <3b05276d_2@dnews>, jbl...@aamsi.com wrote...

> Hi,

> >     Phil.  Maybe I wasn't clear in my news post or maybe I do not
understand
> > your reply.  This cd will be distributed .  I just want the user to pop
in
> > the cd and run it off there without doing any installs.

> Interbase is a database 'server', so the server needs to be installed
> and running to be able to use a database file (which can live on a CD).

> If you don't want to do any installs, you can't use Interbase (or any
> other 'database' server).

> >  It is a real simple
> > database app.  It has only one form.  It just allows the users to just
view
> > the data and perfroms searches based on two fields.

> >     Is it possible to load a text file into a table component, connect
it to
> > a grid via datasource, and  and view  the data and perfrom searches on
it. I
> > tried to do it but I am being prompt for a tablename in the properties
tab.

> Take a look at TClientDataset, that can work standalone and save/load
> data to/from a 'file'

> > I was thinking about using a msacess table.  What are you thoughts on
that.

> You would still need to install Access.

> > I just want to make this as simple as possible.  I am looking into ASP
but
> > this current app must be out ASAP.

> ASP is for developing Webpages, or does it mean something else today <g>

> Cheers

> Phil

Re:Distributing Interbase Database Appplication


I am currently using midas at my company for an app I wrote for 30 users.  I
had no idea it can be used as a standalone.  Thanks.  "Phil Shrimpton"
Quote
<p...@nospam.co.uk> wrote in message

news:MPG.156f457b3b6152d89896f4@newsgroups.borland.com...
Quote
> In article <3b0532b5$1_2@dnews>, jbl...@aamsi.com wrote...

> Hi,

> > Thanks friend. As you can see I am running around like a chicken with
its
> > head cut off tyring to get this thing out.

> It happens to all of us <g>

> > I will look into tcleintdataset.  If  it does what I want it to do, all
I
> > would have to do is distribute my executable and the text file , correct
?

> I think you need to include the midas.dll as well, but it should work
> off the CD, but I have not tried it.

> You could always use Kim's TkbmMemTable which is an excellent free
> TClientDataset replacement that is 100% Delphi source so it can be
> compiled into your exe.  This might be the better option.

> You can down load it from .. http://www.optical.dk/Delphi/prod01.htm

> Cheers

> Phil

Re:Distributing Interbase Database Appplication


Quote
In article <3b0532b5$1_2@dnews>, jbl...@aamsi.com wrote...

Hi,

Quote
> Thanks friend. As you can see I am running around like a chicken with its
> head cut off tyring to get this thing out.

It happens to all of us <g>

Quote
> I will look into tcleintdataset.  If  it does what I want it to do, all I
> would have to do is distribute my executable and the text file , correct ?

I think you need to include the midas.dll as well, but it should work
off the CD, but I have not tried it.

You could always use Kim's TkbmMemTable which is an excellent free
TClientDataset replacement that is 100% Delphi source so it can be
compiled into your exe.  This might be the better option.

You can down load it from .. http://www.optical.dk/Delphi/prod01.htm

Cheers

Phil

Re:Distributing Interbase Database Appplication


TClientDataset would work nicely running from a CD.  The datasets can
be stored and accessed on the CD.  It also of course does not need the
BDE.

You will need to make sure midas.dll is is in the same dir as the
..exe.  Indicies will need to be created at runtime.

--
Reid Roman
Future Generation Software
http://www.futuregenerationsoftware.com

Re:Distributing Interbase Database Appplication


I tried to click on the hyperlink and the page didn't come up.  If you have
the zip file can you send it to me at my email: juli...@bellsouth.net
Thanks.

Quote
"Phil Shrimpton" <p...@nospam.co.uk> wrote in message

news:MPG.156f457b3b6152d89896f4@newsgroups.borland.com...
Quote
> In article <3b0532b5$1_2@dnews>, jbl...@aamsi.com wrote...

> Hi,

> > Thanks friend. As you can see I am running around like a chicken with
its
> > head cut off tyring to get this thing out.

> It happens to all of us <g>

> > I will look into tcleintdataset.  If  it does what I want it to do, all
I
> > would have to do is distribute my executable and the text file , correct
?

> I think you need to include the midas.dll as well, but it should work
> off the CD, but I have not tried it.

> You could always use Kim's TkbmMemTable which is an excellent free
> TClientDataset replacement that is 100% Delphi source so it can be
> compiled into your exe.  This might be the better option.

> You can down load it from .. http://www.optical.dk/Delphi/prod01.htm

> Cheers

> Phil

Re:Distributing Interbase Database Appplication


Hi,

That URL is pretty old.
You should check http://delphi.e-indexit.com
There you will find the latest version of kbmMemTable (2.52i beta), kbmWABD
(2.30), kbmMW (soon to be released) and kbmX10

best regards
Kim Madsen
k...@optical.dk

"Julian K. Black" <jbl...@aamsi.com> wrote in message
news:3b0554d9_1@dnews...

Quote
> I tried to click on the hyperlink and the page didn't come up.  If you
have
> the zip file can you send it to me at my email: juli...@bellsouth.net
> Thanks.

> "Phil Shrimpton" <p...@nospam.co.uk> wrote in message
> news:MPG.156f457b3b6152d89896f4@newsgroups.borland.com...
> > In article <3b0532b5$1_2@dnews>, jbl...@aamsi.com wrote...

> > Hi,

> > > Thanks friend. As you can see I am running around like a chicken with
> its
> > > head cut off tyring to get this thing out.

> > It happens to all of us <g>

> > > I will look into tcleintdataset.  If  it does what I want it to do,
all
> I
> > > would have to do is distribute my executable and the text file ,
correct
> ?

> > I think you need to include the midas.dll as well, but it should work
> > off the CD, but I have not tried it.

> > You could always use Kim's TkbmMemTable which is an excellent free
> > TClientDataset replacement that is 100% Delphi source so it can be
> > compiled into your exe.  This might be the better option.

> > You can down load it from .. http://www.optical.dk/Delphi/prod01.htm

> > Cheers

> > Phil

Re:Distributing Interbase Database Appplication


Hi,

you can also use the DBISAM database engine.
Look at www.elevatesoft.com
Then you have a database engine with SQL support,
and you don't have to install anything on the computer,
the engine is compiled in the exe.

greetings,

Rob

Quote
"Reid Roman" <re...@futuregenerationsoftware.com> wrote in message

news:3b054bb8$1_1@dnews...
Quote
> TClientDataset would work nicely running from a CD.  The datasets can
> be stored and accessed on the CD.  It also of course does not need the
> BDE.

> You will need to make sure midas.dll is is in the same dir as the
> .exe.  Indicies will need to be created at runtime.

> --
> Reid Roman
> Future Generation Software
> http://www.futuregenerationsoftware.com

Re:Distributing Interbase Database Appplication


Quote
In article <3b05afcc$1_1@dnews>, k...@optical.dk wrote...

Hi,

Quote
> That URL is pretty old.
> You should check http://delphi.e-indexit.com
> There you will find the latest version of kbmMemTable (2.52i beta), kbmWABD
> (2.30), kbmMW (soon to be released) and kbmX10

It is an old link, sorry, it must have been in my cache/proxy.

Cheers

Phil

Re:Distributing Interbase Database Appplication


Hi,

Or you could look at Topaz, a dbase engine that is compiled in the exe. You
don't need anything installed, only the exe to run. You can also get the
data of a CD, there is even an explanation in their faq. One disadvantage,
you can't use SQL with Topaz, but for the rest it is a fast and reliable
database enigne even with large tables.

Check out the manufacturers website and get a demo version. You can find it
at www.softsci.com

Greetz,

Benno Evers

Quote
"Rob Segerink" <r.seger...@hccnet.nl> wrote in message

news:3b066343_1@dnews...
Quote
> Hi,

> you can also use the DBISAM database engine.
> Look at www.elevatesoft.com
> Then you have a database engine with SQL support,
> and you don't have to install anything on the computer,
> the engine is compiled in the exe.

> greetings,

> Rob

> "Reid Roman" <re...@futuregenerationsoftware.com> wrote in message
> news:3b054bb8$1_1@dnews...
> > TClientDataset would work nicely running from a CD.  The datasets can
> > be stored and accessed on the CD.  It also of course does not need the
> > BDE.

> > You will need to make sure midas.dll is is in the same dir as the
> > .exe.  Indicies will need to be created at runtime.

> > --
> > Reid Roman
> > Future Generation Software
> > http://www.futuregenerationsoftware.com

Other Threads