How to specify the database path dynamically? 1

[sanjna000]

Hi,
i've got 6 tables in a database and currently i have specified the path by using tablename.DatabaseName property. But the problem is whenever the time i change the location of my database i have to change the database path in my code.This is so inconvenient for me. Can any one help me to solve this problem please?

Many Thanks for u r help in advance,
Sanjna...

 

[rrrrrrichie]

I've had that problem before. There are two solutions i thought of 1) read the database path from the registry 2) create a simple .txt file with the path and read from that in your app. I use the 2nd solution.

 

[LucieLastic]

hi

Use an ini file and the ReadString etc calls.

lou

 

[sanjna000]

Hi rrrrrrichie,

Can u let me know the way where u can read the database path from the registry ? I need a good way of doing this since i have to distribute my database along with my tool to the client. What is the best way of doing this. I am waiting for u r reply..........

Many Thanks,
Sanjna...

 

[rrrrrrichie]

Ummmmmmmm, the reason i went down the path of a txt file was that i knew how to do that!! If you are using an installation tool such as InstallShield then you can use that to add the database path to the registry upon installation. Then you could just read from the registry when your program starts. Using a quick google i found this:

http://delphi.about.com/gi/dynamic/...ies.com/SiliconValley/Lakes/1636/registry.htm

Any good to ya?

 

[LucieLastic]

hi

Personally, I would recommend using an .ini file rather than the registry as it's a lot easier to maintain when the databasename changes. It also doesn't start configuring the users' machines and the users are able to run the app from anywhere(other PCs). Overall, I just think it's an easier and cleaner way and doesn't leave entries in registries when the app is no longer used. Other people may disagree with me, though.


Is there a reason why you want to use the registry rather than an .ini file?

lou

 

[rrrrrrichie]

and some more links:

http://www.latiumsoftware.com/en/delphi/00004.php

http://www.marcocantu.com/code/md6htm/UpdSql2.htm

 

[rrrrrrichie]

and me being devil's advocate, here's a link to show how you do it with ini files!

http://delphi.about.com/library/weekly/aa120401a.htm

 

[sanjna000]

Hi rrrrrrichie And Anna,
Thank you so much for both of u r guys help. Since i am new to Delphi i didn't have any idea of doing it. Many Thanks for all the help u 'll given to me. I will try it in both ways and would let u know if i need any more help......

Thanks again,
Sanjna...