Solved

Changing Alias pathing

Posted on 1998-05-20
5
284 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
  • 4
5 Comments
 

Expert Comment

by:westy100697
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now