Do i need to install the client onto the same computer as Oracle Database 10g Express Edition to work fine whith DOA?

The TOracleSession connect but i have the error ORA-12154. Why?

Thanks and regards.

Can you connect to the same database from the same machine with SQL*Plus?

yes perfectly.

This is the Oracle information :

-Oracle Database 10g Express Edition (Universal)
OracleXEUniv.exe (216,933,372 bytes)

-Oracle Database 10g Express Client
OracleXEClient.exe (30,943,220 bytes)

Client software to be installed on client systems for remotely accessing Oracle Database 10g Express Edition. You do not need to install the client onto the same computer as Oracle Database 10g Express Edition.

Did you have an earlier client installed on the same machine where you installed 10g express client? I had something similar recently. I had the 8i client installed on my laptop and installed 10g express server (including client) but forgetting to uninstall the 8i client first.

This left registry entries still pointing to the 8i client and uninstalling 8i didn't fix it. I ended up looking in the registry and replaced the 8i paths with the 10 XE versions. The problem was DOA was looking for the old 8i tnsnames.ora.

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"
"ORACLE_HOME"="C:\\oraclexe\\app\\oracle\\product\\10.2.0\\server"
"ORACLE_HOME_NAME"="XE"
"API"="C:\\oraclexe\\app\\oracle\\product\\10.2.0\\server\\BIN"
"ORACLE_GROUP_NAME"="Oracle - XE"
"NLS_LANG"="NA"
@=""

I'm getting the same problem. I've succesfully managed to connect once before to 10g. The difference I've got this time is that (a) it's Windows 2000 and (b) it previously almost had Oracle 8i on, but the installation failed because the CPU was faster than it was expecting.

I've been through the regsitry and removed all Oracle8 references that I could find before installation.

The installation went fine, I've been able to run SqlPlus and IMP to load a database.

Any ideas ? You can save me a 700Km drive if you can spot whats wrong.

Thanks

Mark

As additional information the same application works ok with 10g XE on an XP machine, 8i on Win2000 machine.

The OracleAliasList has all the SIDs, the failure is at TOracleLogon.Execute.

Delphi7, Direct Oracle Access 4.0.7.1

Query Reporter also connects fine to the database. It's showing the tables, columns, allows me to pick the user name....

It's only my application which won't connect, and it has been rebuilt (cleared out all the DCUs) with the very latest Delphi 7 DOA...

You probably want to check the registry (hkey_local_machine\software\oracle) to verify if it has more than one Oracle Home. It may be that the Query Reporter selects a different home than your application.

No. I've been through the registry very carefully. There are no references to the old Oracle path or version. I've also used a registry cleaner that removes any references to folders and files that no longer exist.

The code to connect to the database has been the same code since we implemented DOA around 6 years ago, and has happily worked through the different versions of Delphi, Windows and DOA.

(the name and password have been set at design time for K2.dbK2, but also tried explictly, DBSid is set from a list and has
the correct value K2.dbK2 is TOracleSession)

K2.dbK2.Connected := false;
K2.dbK2.LogonDatabase := DBSid;
Logon := TOracleLogon.Create(nil);
Logon.Session := K2.dbK2;
if not Logon.Execute then
begin
ok := false;
end
else if not K2.dbK2.Connected then
begin
ok := false;
end