Correct Idapi.cfg by hand
Antonis Tsourinakis
(see
Newsgroups: borland.public.bde
Subject: Idapi.cfg limitation
Message-ID: <4476...@newsgroups.borland.com>
)
I am try to eliminate the number of aliases deleting some of them, but
I am geting the same error as trying to add a new one.
Is there any other way to edit this Idapi.cfg file or how can I edit
it by hand? Is there any info about it's format?
Thanks a lot
Stephen M
- Τί μήνυμα λάθους εμφανίζει (έχει κωδικό λάθους);
- Έχεις εγκαταστήσει ODBC DSN Data sources;
Antonis Tsourinakis
wrote:
Thanks for your answer
As it was described the error was full described in the discusion of
the Subject: Idapi.cfg limitation in the same newsgroup.
The error is "Cannot write to Engine configuration file",
BDE error 8453.
And Yes are installed ODBC DSN Data sources.
I prefer to answer in english because I don't think others can follow
as.
Stephen M
Check if idapi32.cfg has 'Read Only' file attribute enabled.
Antonis Tsourinakis
wrote:
>Hi,
>Check if idapi32.cfg has 'Read Only' file attribute enabled.
No it isn't. I know that I touch it's limit, that's why I asked help
for edit it "by hand" because I cannot even delete any alias.
The reason for so many alias is that we have for every company that
uses our programs we have a different bde alias so we catch the limit
Leslie Milburn
"Antonis Tsourinakis" <tso...@otenet.gr> wrote in message
news:7vg534d8qvufhuq31...@4ax.com...
Well you have your answer right there - reduce your aliases. I fail to
understand why you need a separate alias for each company unless this is
running on your own server or something. Regardless, you are not catering
for other applications that might also want to use the BDE and hence share
the cfg file, this is poor design.
Leslie.
Steven Green
> this is running on your own server or something.
if that *is* what you're doing, you can put all the companies in a table,
pick from the list or a menu at startup, and set the alias on-the-fly..
--
Steven Green - Myrtle Beach, South Carolina USA
Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Leslie Milburn" <CD...@NOSPAM.bigpond.com> wrote in message
news:4833...@newsgroups.borland.com...
Antonis Tsourinakis
<CD...@NOSPAM.bigpond.com> wrote:
>
>Well you have your answer right there - reduce your aliases. I fail to
>understand why you need a separate alias for each company unless this is
>running on your own server or something. Regardless, you are not catering
>for other applications that might also want to use the BDE and hence share
>the cfg file, this is poor design.
>
>Leslie.
>
Okay I wish it could be so easy.
There are 92 different databases in 16 (IBM AS400) different machines
(10 in our offices and the other spread all over Greece) plus 3
Firebird databases for testing purposes. All these are accessed by
4000 users all over the world either directly, either via Remote
control.
Every RDBMS is for one company only so we can have one Alias per
client machine, but the development team must have access to every
one.
So the problem is for us not for our users.
Okay we can solve it having different .cfg files with some of the
alias in any of them, but I was thinking if there are other solutions
(as a developer it is difficult to believe that "I can use it only as
Is") The strange thing is that I cannot also delete any alias (I am
getting the same error). In 3 also of our machines we cannot ols
switch (open) to other cfg files. I would try to make a program to
manipulate the cfg file If I knew its format but in our case no news
bad news. The complexity of all above is the reason that we didn't
switch to any other connection layer till now (is a 2 years planed)
project.
So I insist to my question if there is any way to "edit" the cfg files
outside the Bde admin.
Steven Green
again.. the aliases don't have to be hard-coded in the BDE.. that is far too
many, as you have seen.. change the way you control it.. make it
table-based.. your person selects a company from a table or menu, and the
appropriate alias is set..
--
Steven Green - Myrtle Beach, South Carolina USA
Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Antonis Tsourinakis" <tso...@otenet.gr> wrote in message
news:1f3834ttme059cd9l...@4ax.com...
Rick Rans
select alias configurtion information from a table and use "AddAlias" to
create the alias for the session, not store all of the aliases in the config
file.
HTH - Rick
"Steven Green" <gre...@diamondsg.com> wrote in message
news:483426c5$1...@newsgroups.borland.com...
![Bill Todd [TeamB]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjWCsgxmldb_86qScxWLohQRsXwmDfg_NwjwQAFKFefVLRVoLw=s40-c)
Bill Todd [TeamB]
> So I insist to my question if there is any way to "edit" the cfg files
> outside the Bde admin.
There is no way to edit the BDE config file that is not going to
encounter the same limits. You could write your own config file editor
using the BDE API but BDE Admin uses the BDE API functions so you will
encounter the same problem.
--
Bill Todd (TeamB)
Leslie Milburn
Again, you have already answered your question, why on earth do you want to
have identical config files on each server, who thought that was a good idea
?
You should have a config file for each "server" and then use Steven's
suggestion as the way for your own guys to connect to the database of choice
except you go one step further by adding a dropdown list of the 16 machines
as well as the available aliases in the config file of that machine.
Leslie.
Antonis Tsourinakis
>There is no way to edit the BDE config file that is not going to
>encounter the same limits. You could write your own config file editor
>using the BDE API but BDE Admin uses the BDE API functions so you will
>encounter the same problem.
Thanks a lot all of you for you tries to help me.
I solved my problem with the help of an utility I found in internet
named AliasBDE.exe (I would like to see the source, I think that it is
very interesting) that transforms any cfg to ini and the opposite.
I never tried to add more than the limit. I had a cfg that either I
couldn't edit, add or delete anything.
My solutions was (as some of you suggested) to build the alias
internal in my code. Even this is not safe (in the way we see the
problem) it works, so we can continue our tries to leave BDE.
Thank's again.
