Oracle connection Problem ASP.net

Question

naveedqadri 0 Junior Poster in Training

13 Years Ago

I need urgent Help plz.
scenario: Oracle Database and Client 10g are installed on same system.
I want to connect my website with database ( i am new to oracle and ASP.Net)
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
My web.config file contains code

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="MM_CONNECTION_HANDLER_ictmdb" value="default_oledb.htm" />
  <add key="MM_CONNECTION_STRING_ictmdb" value="Provider=MSDAORA.1;User ID=ictm;Password=ictm;data source=orcl"/>
  <add key="MM_CONNECTION_DATABASETYPE_ictmdb" value="OleDb" />
  <add key="MM_CONNECTION_SCHEMA_ictmdb" value="" />
  <add key="MM_CONNECTION_CATALOG_ictmdb" value="" />
  <add key="CSS_PATH" value="/ictm/css" />
  <add key="IMG_PATH" value="/ictm/soft/tmp/" />
 </appSettings>
	<connectionStrings/>

tnsnames.ora

# tnsnames.ora Network Configuration File: e:\oracle\database\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ICTMUSER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Demo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

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

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

It will be kindness if help me step by step I am trying to connect my database on same machine

asp.net oracle

1 Contributor
1 Reply
328 Views
7 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by naveedqadri

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

naveedqadri 0 Junior Poster in Training · Answer 1 · 2011-06-09T12:55:02+00:00

Hi every Body, Problem is solved by my self,

I jut delete the "data source=orcl" from my web.config file
its running now

I need urgent Help plz.
scenario: Oracle Database and Client 10g are installed on same system.
I want to connect my website with database ( i am new to oracle and ASP.Net)
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
My web.config file contains code

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="MM_CONNECTION_HANDLER_ictmdb" value="default_oledb.htm" />
  <add key="MM_CONNECTION_STRING_ictmdb" value="Provider=MSDAORA.1;User ID=ictm;Password=ictm;data source=orcl"/>
  <add key="MM_CONNECTION_DATABASETYPE_ictmdb" value="OleDb" />
  <add key="MM_CONNECTION_SCHEMA_ictmdb" value="" />
  <add key="MM_CONNECTION_CATALOG_ictmdb" value="" />
  <add key="CSS_PATH" value="/ictm/css" />
  <add key="IMG_PATH" value="/ictm/soft/tmp/" />
 </appSettings>
	<connectionStrings/>

tnsnames.ora

# tnsnames.ora Network Configuration File: e:\oracle\database\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ICTMUSER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Demo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

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

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

It will be kindness if help me step by step I am trying to connect my database on same machine