954,574 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Oracle connection Problem ASP.net

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

naveedqadri
Junior Poster in Training
60 posts since Nov 2010
Reputation Points: 10
Solved Threads: 0
 

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

naveedqadri
Junior Poster in Training
60 posts since Nov 2010
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: