Solved

Changing Alias pathing

Posted on 1998-05-20
5
290 Views
Last Modified: 2010-04-03
Need to know how to change BDE ALIAS path during runtime
Thanks,

Ken Orlikowski
0
Comment
Question by:kenno
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 

Expert Comment

by:westy100697
ID: 1346827
kenno,
          I am also trying to do the same thing at the moment. Now what I have come up with so far is if you look at the bde.int file in the borland\docs directory (I presume you are using Delphi 3 ?) there is a structure defined called pDBDesc. Now there is also a function called DbiGetDatabaseDesc and will return the logical ALIAS and also the pathname and is stored in the pDBDesc record structure. I am trying this at the moment but just thought I would let you know as you are encountering a similar problem.

Regards
WESTY
0
 

Expert Comment

by:westy100697
ID: 1346828
kenno,
          Meant to put this above but if you type in dbiGetDatabaseDesc in your Code somewhere and just Ctrl-F1 that word you will be taken to the description and are given 2 examples one for C++ and the other for Delphi . These may help you.

Regards
WESTY
0
 

Expert Comment

by:westy100697
ID: 1346829
kenno,
          Also remember to add BDE to your uses clause as this is the unit the dbi...
functions access. Putting this up as I am testing it.

regards
WESTY
0
 

Expert Comment

by:westy100697
ID: 1346830
kenno,
          Another couple of functions I would look at seeing as though you want to change the ALias path at run time is dbiGetProp and dbiSetProp these are more applicable probably seeing as though you want to actually change the values. Anyway hope these comments help.

WESTY
0
 

Accepted Solution

by:
lucab earned 50 total points
ID: 1346831
You must use a TSession in this way:

      lt1:=TStringList.Create;
      Session1.GetAliasParams( ALIASNAME, lt1);

in lt1 you'll have an item like this
     
        PATH= Mydirectory
and
        SERVER NAME= MyServer name \ my databasename

you can modify these values as you like and with

        Session1.ModifyAlias( ALIASNAME, lt1);
 
you can save your temporary changes.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question