Aaaaarg. Why does Oracle make this so confusing!
I have a web appication that was working fine connecting to oracle using
System.Data.OracleClient.
I attempted to install a new version of the oracle client tools (10g) to get
a later version of the odbc drivers. I then uninstalled this version and reverted
to the 9i version.
Since then - my web application no longer works and gives me the 'ol TNS error.
I have tracked down all instances of tnsnames.ora and made sure they are the same.
I have successfully connected to the oracle database via odbc from within the web app,
tnsping resolves appropriately.
toad connects using the tns with no problem
It appears the error is caused when attempting to use the System.Data.OracleClient
as the provider.
The reference to this is: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.OracleClient.dll
Thanks..
Tom
This code does not work it fails on Execute.::CoInitialize(NULL);_ConnectionPtr m_Connection("ADODB....
By mayankjha
Is there a way to retrieve the KeyInfo using the Microsoft Data Access Application Block for .NET? I...
By anonymous
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="OK" CancelText="Cancel" EditText="Edit...
By pradeepkonda
Is there anyway to have an editcommand inside an <itemtemplate>? I would just use the edit comman...
By jgallen_23
I am trying to use the EditCommandColumn to edit data, but I am having problems getting the textbox ...
By dan_h, 2 Comments
Does anybody know why when connecting to an Oracle database from a ASP.NET web app running under Win...
By anonymous, 4 Comments
None of the schema filters such as OleDbSchemaGuid.Tables work when a database has a period "." in i...
By anonymous, 5 Comments
Hello: I'm creating and opening an OleDbConnection on the main thread of my application, but I ...
By anonymous, 4 Comments
Hi... I have an ASPX page which includes a CSS <meta http-equiv="Content-Type" content="text/html...
By anonymous, 4 Comments
My guess is that in switching to the 10g client, Oracle still thinks you are looking for the 9i TNSNAMES.ORA file... in the Windows version of Oracle Client(s) it uses a registry setting to tell all Oracle products which "Oracle Home" to use for tnsnames entries. I would check which client is in use. It's been a while since I've looked for it, but I seem to remember it to be here:
\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
I think the Key you are looking for is something like CURRENT_HOME or ORACLE_HOME... it should point to your 10g directory, not the 9i one...
Hopefully, this will help...
joebednarz | Sun, 06 Jan 2008 04:40:00 GMT |