Oracle

Re: ORA-12154: TNS:could not resolve service name

dantheman13 — Mon, 04 Jul 2005 13:37:53 GMT

It works!!
What was missing was giving the permissions to the tnsnames.ora file because even though I gave the proper permissions to the whole oracle file you still have to add permissions to this file individually as well. After I added permissions to that file no more errors! Hooray!
Thanks to everyone who helped me!

DAN

Re: ORA-12154: TNS:could not resolve service name

rponton — Thu, 30 Jun 2005 21:56:42 GMT

The Oracle Universal(ly hated) Installer does stupid things with the permissions on the folders.

Verify that the local ASPNET account (might as well just give it to Everyone, IMHO) has Read/List/Execute permission on ORACLE_HOME, ORACLE_HOME/bin, *and* ORACLE_HOME/network/admin. Somehow, all of those folders can end up with seperate permissions. Further, depending on how you copy the TNSNAMES.ORA file around, it can end up with its own unique set of permissions, so check that too.

Re: ORA-12154: TNS:could not resolve service name

dweezil — Thu, 30 Jun 2005 18:34:56 GMT

dantheman13 wrote:
Hi,
To the oracle folder I added asp.net, authenticated users, Internet Guest Account and Launch IIS Process Account users and gave them all full control. But I still get the same error. Also I took the same code I mentioned above and used it in a Windows application instead of a ASP.NET Web Application and I accessed the database with no problems...
So does anyone have any suggestions on what to do now?
Thanks.

DAN

Make sure ASPNET and Authernicated Users permissions are propagating down to the BIN folder.

If this doesn't fix the problem post your tnsnames.ora file.

Re: ORA-12154: TNS:could not resolve service name

dantheman13 — Thu, 30 Jun 2005 16:17:56 GMT

Hi,
To the oracle folder I added asp.net, authenticated users, Internet Guest Account and Launch IIS Process Account users and gave them all full control. But I still get the same error. Also I took the same code I mentioned above and used it in a Windows application instead of a ASP.NET Web Application and I accessed the database with no problems...
So does anyone have any suggestions on what to do now?
Thanks.

DAN

Re: ORA-12154: TNS:could not resolve service name

dweezil — Thu, 30 Jun 2005 14:18:10 GMT

dantheman13 wrote:
Hi,
from what I have been reading here and elsewhere I think there might be a problem with my permissions with asp.net and oracle. Where do I go on my computer to find this information and how would I go about changing the permissions if that is indeed the problem.
I am using Oracle 8.1.7 and Visual Studio .NET 2003 on a Windows 2000 system.
Thanks

DAN

Check that the ASPNET account and the Authenicated Users group both have Read & Execute permissions on the Oracle directory.
Right click the Oracle directory and select Properties, then click on the Security tab to view the permissions.

Re: ORA-12154: TNS:could not resolve service name

dantheman13 — Thu, 30 Jun 2005 13:04:24 GMT

Hi,
from what I have been reading here and elsewhere I think there might be a problem with my permissions with asp.net and oracle. Where do I go on my computer to find this information and how would I go about changing the permissions if that is indeed the problem.
I am using Oracle 8.1.7 and Visual Studio .NET 2003 on a Windows 2000 system.
Thanks

DAN

Re: ORA-12154: TNS:could not resolve service name

Caddre — Wed, 29 Jun 2005 21:20:19 GMT

I also don't think you can use OracleDataAdapter to connect to Oracle 8.1.7, you have to use Microsoft OracleAdapter because OracleDataAdapter can only be used by Oracle 9i. Try the links below for connectionstring. Hope this helps

http://www.carlprothman.net/Default.aspx?tabid=86#OracleNETDataProvider

Re: ORA-12154: TNS:could not resolve service name

dweezil — Wed, 29 Jun 2005 21:04:14 GMT

I don't see a connection in string your code.

You have to pass the connection string as an argument to the connection object, or else it does not know what Oracle instance to open.

ORA-12154: TNS:could not resolve service name

dantheman13 — Wed, 29 Jun 2005 19:40:38 GMT

Hello all,
I am very new to Oracle and I keep getting this error in .Net and I don't know why...
I am using Oracle 8.1.7, C# and using System.Data.OracleClient
I selected OracleDataAdaptor from the toolbox and created a new connection and tested it and it was successful.
I built my program and there are no errors but when the page loads I get the error mentioned in the subject heading.
It says the error occurs at conn.Open();
Does anyone know how to go about and try to fix this error?
By the way here is that section of code:

protected System.Data.OracleClient.OracleDataAdapter oracleDataAdapter1;
protected System.Data.OracleClient.OracleCommand oracleSelectCommand1; // Selects all the columns in the db
protected System.Data.OracleClient.OracleCommand oracleInsertCommand1;
protected System.Data.OracleClient.OracleConnection conn; // Tested connection and it worked
protected System.Web.UI.WebControls.ListBox nameListBox;

private void Page_Load(object sender, System.EventArgs e)

{

using(conn)
using(oracleSelectCommand1)

{

oracleSelectCommand1.Connection = conn;

conn.Open();

OracleDataReader reader = oracleSelectCommand1.ExecuteReader();

while(reader.Read())
nameListBox.Items.Add(new ListItem(reader.GetString(0)));

reader.Close();

}

Thanks.

DAN