This is an independent application using a local DB file. I am trying to package it so that it can be installed on other computers. I created a 'Database' folder within the application folder. I have put my access .mdb file inside the 'database' folder. In the connectionstring I changed "C:\MyApplicationFolder\database\MyAccessDB.mdb" to the following "..\database\MyAccessDB.mdb" so that when the application is installed on another computer it will know where to get the database file no matter in which directory path the application is installed. However when I make such a change to the connectionstring the application fails to build. Therefore I am of the opinion that I need to give the path to the DB using a registry key. I am exploring this possibility. I cant think of any other.
Anu Rang, totallyfreeenergy http://totallyfreeenergy.freehoxt.com --- In [email protected], Marselle <[EMAIL PROTECTED]> wrote: > > relative path on a server must be something like //path/filename > hard drive / local must be where the file resides > where is the file..? on a server...? if so put the server name and qualified path.. > > > --- On Thu, 5/1/08, Anu Rang <[EMAIL PROTECTED]> wrote: > > > From: Anu Rang <[EMAIL PROTECTED]> > > Subject: [delphi-en] Re: Deployment of a Access DB based application using installshield express > > To: [email protected] > > Date: Thursday, May 1, 2008, 10:16 AM > > If I put in a relative path in the ConnectionString the > > application > > fails to build. It comes up with Unable to locate database > > file or > > something to that effect. I think may be some kind of > > registry key > > with the path entered at the installation time may have to > > be used. I > > just dont know how to do this. Hope I find something on the > > internet. > > > > Anu Rang, TotallyFreeEnergy > > http://totallyfreeenergy.freehoxt.com > > > > > > --- In [email protected], Zoran Milenkovic > > <deusdino@> > > wrote: > > > > > > If the data is located in the same directory as your > > EXE file, then > > you can remove the path from connection string leaving only > > the > > database name. In that case the application will look for > > your > > database in the current directory. > > > > > > If you need to have data in separate directory, it > > should still be > > easy to manipulate the connection string, provided that > > these two > > directories are related. > > > > > > For instance: > > > > > > const > > > cs: String = > > > 'Provider=Microsoft.Jet.OLEDB.4.0;'+ > > > 'Jet OLEDB:Engine Type=5;'+ > > > 'Data Source='; > > > > > > implementation > > > > > > ADOConnection1.ConnectionString := > > cs+'..\Data\MyDataBase.mdb'; > > > > > > > > > Anu Rang <totallyfreeenergy@> wrote: > > > > Hi, > > > Having built my application using a local Access > > database, I was > > trying > > > to deploy my application using Installshield express. > > The thing > > about > > > deployment on target computer is that normally where > > the > > application is > > > installed is decided by the user. Ofcourse it is > > possible to > > enforce a > > > particular directory path for installation. Still it > > is tricky to > > get a > > > relative path mapped in the ADOConnection object. I > > just used use > > > connection string and built it using the > > ADOConnection wizard. If > > > anyone has more info or knowledge I would really > > appreciate it > > since > > > this path to the .mdb file really has to be relative > > and not hard > > coded. > > > > > > Anu Rang, TotallyFreeEnergy > > > http://totallyfreeenergy.freehoxt.com > > > > > > > > > > > > > > > > > > > > > --------------------------------- > > > Be a better friend, newshound, and know-it-all with > > Yahoo! Mobile. > > Try it now. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > ------------------------------------ > > > > ----------------------------------------------------- > > Home page: http://groups.yahoo.com/group/delphi-en/ > > To unsubscribe: [EMAIL PROTECTED] > > Groups Links > > > > > > > > ______________________________________________________________________ ______________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >
