-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: dnetjockey
Message 6 in Discussion
Hi baburaj,
i guess u must check with the following
value="Provider=MSDAORA.1;User ID=<userid>;Password=<password>;Data
Source=<service_name>; pooling=yes; Connection LifeTime=20;Max Pool Size=20;
Min Pool Size=5;"
listner name is the DNS name u use. i guess it is TOOLDB01 in your case
and i too faced a problem priveously i checked the
D:\oracle\ora81\network\admin\tnsnames.ora and made some changes not very sure
what i did please check that one also
but please add that 'Provider=MSDAORA' and make necesary changes in
D:\oracle\ora81\network\admin\tnsnames.ora file
hope this one helps you
regards
shashi
"DotNetSaavy (Mr.BabuRaj)" <[EMAIL PROTECTED]> wrote:
New Message on BDOTNET
While Connecting to Oracle I get an error
Reply
Reply to Sender Recommend
Message 1 in Discussion
From: DotNetSaavy (Mr.BabuRaj)
Hi,
I am developing an ASP.Net application in which I am trying to connect to a
ORACLE database.
I am using the .NET Framework Provider for Oracle , the code in my ASP page is
as shown below.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim oracleConn As New OracleConnection
oracleConn.ConnectionString = "user id=featuredb;data
source=TOOLDB01;password=featuredb"
oracleConn.Open()
Response.Write("Connection opened")
Response.End()
End Sub
When I run this page I get the following error
ORA-12154: TNS:could not resolve the connect identifier specified
What is the reason for this error ?
I have the TNSNAMES.ORA and SQLNET.ORA in the Oracle root directory.
The TNSNAMES.ORA file has the following contents
# TNSNAMES.ORA Network Configuration File:
D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TOOLDB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bumblebee1.pcs.mot.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TOOLDB01)
)
)
View other groups in this category.
Yahoo! India Matrimony: Find your life partner
online.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
