Deploying my database

[yomyom]

Hi all, long time.
I'm feeling rusty and need a jolt!!! I've written my killer app and it is driven by delphi as a front end, and ms-acess as the database (back end - single user!!!). My problem now, is that because I'm using the installer bundled with delphi, i'm not sure how to setup my ADO connection string so as to point to the table at all times.
When I pre-determine where to find the table (database) after installation it works fine, but if the user should select a different default for setup, my prog will not run well since the database will not be located.
I tried using [default\\, [..\\], [\\] etc, as part of the pathname in the setting up of the 'Adotable1.connectionString1' and none seems to work.
Can someone pls help solve my problem?
Thanks in advance.

 

[whosrdaddy]

Hi,

why not store the installation directory in registry? this value can be set by the installer app (installshield, wise, ...)
at application startup you read the instaldir reg value and use this in the connectionstring

cheers,
Daddy

--------------------------------------
What You See Is What You Get

 

[yomyom]

I partially understand what you mean, and I'll try it, but an example would help. I'll be back in touch.
installshield does not explain the registry stuff too well, but I'll delve into it anyway. Thank you V. much.
yomi.

 

[TonHu]

What you need InstallSh.. for?

http://www.innosetup.com

(Just a fan)
HTH
TonHu

 

[delphiman]

>What you need InstallSh.. for?

http://www.innosetup.com

Hear hear! If you can get to grips with this (not too difficult) all your problems should go away.

 

[yomyom]

I actually have a copy I downloaded last year, but I found Installshield easier to use. Now that I know that inno can solve my problems, I'll take the time to go through and learn how to use it. Please inform me of any site(s) with tips or howto for inno installer. Thank you V.much.
Yomi.

 

[yomyom]

Inno know why I've not been using inno since. Its fantastic.
However, how do I create a short cut on the desk top?
Can it be used to limit number of installations?