Board index » delphi » Access to Oracle ServerName in BDE

Access to Oracle ServerName in BDE

Hi,

i'm using Crystal Reports 7 and D5 and Oracle.
When i want to print a report i make a Connection like

Connection.UserID := username
Connection.password := password
Connection.serverName := xpto (.world)

The problem is that this works only for my computer because i have an Oracle
alias named xpto. When i try to print a report in other computer with
another Oracle alias (for instance xxx) i can't make a connection because
the alias xpto doesn't exists.
How can i have access to the Oracle alias from Delphi?
(My app uses a DataBase component with the property AliasName linked to the
BDE. In the BDE this alias has a parameter ServerName wich is the Oracle
alias i'm using.) The problem is that i don't know how to retrieve this
serverName.
I know this information is in the file idapi.cfg in the BDE directory (maybe
this helps)
Please help me!

Best regards,
Bruno Martins

 

Re:Access to Oracle ServerName in BDE


Quote
> How can i have access to the Oracle alias from Delphi?
> (My app uses a DataBase component with the property AliasName linked to
the
> BDE. In the BDE this alias has a parameter ServerName wich is the Oracle
> alias i'm using.) The problem is that i don't know how to retrieve this
> serverName.

You should have the utility called EasyConfig in your Oracle Menu. It will
allow you to add the Oracle alias that points to the server that you want.
This is the only utility you should use to access that file. I am sure that
it is tempting to open using a text editor but the Oracle config tools may
overwrite it if you do. After you add your new Oracle Alias then you can go
into the BDE and it will be available or you can specify it at runtime if
needed.

--
Good Luck
stim...@linkline.com  (remove _ to send nospam)

Other Threads