connecting to oracle database in asp.net

Question

It's pretty confusing task to connect to oracle database. There are many steps to follow and I guess I followed almost everything and solved too many errors on the way. Now I'm stuck at this stage with the error

Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

my tnsnames.ora file

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
  )
)

my ORACLE_HOME path specified in environment variable

F:\app\Shuvro\product\12.1.0\dbhome_1\BIN;

my connectionstring in web.config

Data Source=ORCL;User Id=c##shuvro;Password=admin;Persist Security Info=True;

tnsping ORCL returned OK.

I'm using Visual Studio 2013 and Oracle 12c Enterprise Database. I installed ODP.NET and ODAC. Now what I'm missing here? Any help much appreciated.

All seems ok, try to connect via sqlplus. You have only one oracle client installed? — bdn02
– bdn02, Commented Feb 17, 2014 at 13:09
so you trying to connect to Oracle Installed on same machine? — user275683
– user275683, Commented Feb 17, 2014 at 13:40
@OuSs I went through that too many times before posting question here, no luck. thanks for suggesting anyway — Shuvro
– Shuvro, Commented Feb 17, 2014 at 16:20

user275683 · Accepted Answer · 2014-02-17 18:00:13Z

1

modify tnsnames file to include name of your machine or IP address instead of localhost you can't rely for it to be translated correctly.

answered Feb 17, 2014 at 18:00

user275683

Sign up to request clarification or add additional context in comments.

1 Comment

Shuvro Over a year ago

thanks a lot man! I just changed the host name from localhost to 127.0.0.1 and that solved it.

christof13 · Accepted Answer · 2014-02-17 14:36:02Z

0

Try this (server instead of data source)

Server=ORCL;User Id=c##shuvro;Password=admin;Persist Security Info=True;

answered Feb 17, 2014 at 14:36

christof13

3291 silver badge10 bronze badges

1 Comment

Shuvro Over a year ago

this throws ArgumentException with message 'Server' is an invalid connection string attribute.

Ali · Accepted Answer · 2014-04-08 07:04:00Z

0

You should download and install Oracle Developer Tools for Visual Studio to connect to oracle database

answered Apr 8, 2014 at 7:04

Ali

6943 gold badges13 silver badges22 bronze badges

Collectives™ on Stack Overflow

connecting to oracle database in asp.net

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related