OracleAliasList is empty

[jimpoe]

This is bazaar.

function TAMSBusinessServer.DBNameIsValid(
const DBName: WideString): WordBool;
begin
Result := OracleCI.OracleAliasList.IndexOf( UpperCase( DBName )) -1;
end;

This function is failing on a single W2K machine located at one of our customer sites. The OracleAliasList is empty. The site has two entries in its TNSNAMES.ORA file. The function is working on all other workstations. The W2K machine has a working Oracle client. We can connect using SQL PLUS.

Any idea what would cause this to fail?

 

[Marco Kalter]

Perhaps you can verify what filename is returned by the TNSNames function (located in the OracleCI unit)? Maybe this workstation has multiple Oracle Homes. Direct Oracle Access will use the Primary Oracle Home.

------------------
Marco Kalter
Allround Automations

 

[jimpoe]

Hi,

There was a previous Oracle server installation that was not uninstalled completely. We uninstalled the current Oracle client, deleted anything left over and reinstalled the client. It now works.

Thanks.