Could not connect to Oracle9i Release 2 db using .NET COM+

[Guest]

Hi,
I've problem connecting Oracle9i using COM+. My program is written in
VS.NET2003 C#. It always give me the error message : Unable to Load DLL
(oramts.dll). I am using System.Data.OracleClient.dll library to make a
connection to Oracle9i.

I've installed the Oracle Client in my PC. The oracle_home/bin path has been
set in system path and the oramts.dll did exists in the oracle_home/bin
folder. I've set the registry in
HCKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI as follow:-
OracleOciLib oci.dll
OracleSqlLib ORASQL9.DLL
OracleXaLib oraclient9.dll

Note: The Oracle Database is resided in another machine.

What other configurations/steps that I've miss out in order for me to
connect to Oracle successfully? Appreciate your help as I am new to Oracle.

Thank you.

Jo

 

[Peter van der Goes]

Hi,
I've problem connecting Oracle9i using COM+. My program is written in
VS.NET2003 C#. It always give me the error message : Unable to Load DLL
(oramts.dll). I am using System.Data.OracleClient.dll library to make a
connection to Oracle9i.

I've installed the Oracle Client in my PC. The oracle_home/bin path has been
set in system path and the oramts.dll did exists in the oracle_home/bin
folder. I've set the registry in
HCKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI as follow:-
OracleOciLib oci.dll
OracleSqlLib ORASQL9.DLL
OracleXaLib oraclient9.dll

Note: The Oracle Database is resided in another machine.

What other configurations/steps that I've miss out in order for me to
connect to Oracle successfully? Appreciate your help as I am new to Oracle.

Thank you.

Jo

I realize this is not an immediate fix, but have you discussed the problem
with your database administrator(s)? They should know how client PC's must
be set up to communicate with Oracle 9i.