i have an asp site working with oracle 9.2 with oracle data provider (oracle.dataaccess.dll)

now i want to upgrade to oracle 10g 

i have oracle 10g installed ODAC installed

i Have my database working on 10g and can connect thought SQLPlus 

but if i try to connect with my asp app it show as error 

ORA-12154: TNS:could not resolve service name 

what else do i need to do to connect to 10g from my app

I would recommend to use managed provider such as System.Data.OracleClient

 Are you able to do this?

tnsping your_10g_db_tns_name

1.  If you can connect using sqlPlus but not with your application then the problem is on your connection making.

2. You have to use

using Oracle.DataAccess.Client;

3. The connection shoud make like this

OracleConnection con = new OracleConnection();

con.ConnectionString = "User Id="abc";Password="abc";Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" localhost")(PORT=" 1521")))(CONNECT_DATA=(SID="test db")));";

con.Open();

OracleCommand cmd = new OracleCommand("", con);
cmd.CommandText = "select * form xyz";
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Dispose();

Thanks for your replay

i can

using Oracle.DataAccess.Client

and also can use oracleConnection and oracle command

i have discovered the problem 

here is the 9i connection string

<add name="ConnectionString1" connectionString="Data Source=orcl;User ID=xxxx; Password=xxxx" providerName="System.Data.OracleClient" />

this works with 9i

in 10g i must include the computer name (server name)

<add name="ConnectionString1" connectionString="Data Source=mas-2009/orcl;User ID=xxxxx; Password=xxx" providerName="System.Data.OracleClient" />

that works with 10g

is there any solution for that 

can't i make the connection independant from the computer

Are you connecting to it by another machine? What's your problem now with 10g?

my problem is that i have to include the computer name before the service

i want some way to connect without specifing the computer name in the connection string

suppose i changed my server i have to  edit the web.config to change the server name in the connectin string

i don't have to do that in 9i

Connection String should be same for all machine. Whether it is server or local machine. You have to change providerName="System.Data.OracleClient" to Oracle.DataAccess.Client

mamun22s:

Connection String should be same for all machine. Whether it is server or local machine

it is loacl machine named X the connectin string is Data Source=x/service name

if it changed to y the connectin string is Data Source=y/service name

if i tried Data Source=service name it does not connect

i want to connect without the machine name in the data source

mamun22s:

 You have to change providerName="System.Data.OracleClient" to Oracle.DataAccess.Client

when i did that if shows error

Unable to find the requested .Net Framework Data Provider.  It may not be installed

So far from your explanation I have realized that your problem is on connection or in ODAC. My suggestion is please review the connection string. There is several ways to connect with oracle. Secondly you have to check is ODAC installed properly

Hello, is on your IIS the tnsnames.ora set or a environment variable to the tnsnames.ora? When this is set, you can connect to the database with the name you give in the tnsnames.ora for the service. A tnsnames.ora looks like

net_service_name=
(DESCRIPTION=
(ADDRESS=(protocol_address_information))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))

and then you can connect with the net_service_name