Re: Enterprise Library January 2006 Data Access Application Block and Oracle

I don't think I have a problem with my tnsnames.ora file because I can
connect to the database with toad and sql*plus. I had an interesting
problem with sql*plus though. The first time I tried to connect with it
today it gave me the ORA-12154: TNS:could not resolve service name
error. That was weird.

-----Original Message-----
From: Discussion of building .NET applications targeted for the Web
[mailto:[email protected]] On Behalf Of Tim Royal
Sent: Monday, April 09, 2007 1:11 PM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

Whenever I've dealt with the "could not resolve service name error",
beyond permissions it almost always was the result of not having the
tnsnames.ora configuration file set up with a reference to the target
Oracle db server.

Tim





***************************************
Reading Lately? I Kings
Playing Lately? Roma, Supreme Commander (PC)
Watching Lately? The Passion For Kids, Star Wars
***************************************
-----Original Message-----
From: Discussion of building .NET applications targeted for the Web
[mailto:[email protected]] On Behalf Of Smotritsky, Alex
Sent: Monday, April 09, 2007 6:01 AM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

Thanks Bob, I'll check out sysmon.

Roy: I hadn't thought of testing with sql*plus. Interestingly it gives
me the same error: ORA-12154: TNS:could not resolve service name

I guess it's an oracle client issue.

-----Original Message-----
From: Discussion of building .NET applications targeted for the Web
[mailto:[email protected]] On Behalf Of Bob Franken
Sent: Saturday, April 07, 2007 3:12 PM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

It's almost always been a permissions issue for me when getting oracle
to work..  Get sysmon from sysinternals.com.  Look for access denied.
This tool has always helped me.

Sent from my BlackBerry(r) wireless handheld

-----Original Message-----
From:         "Pardee, Roy" <[email protected]>
Date:         Sat, 7 Apr 2007 07:09:09
To:[email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

You haven't said that you can connect fine from sql*plus--that's true,
right?

-----Original Message-----
From: Discussion of building .NET applications targeted for the Web
[mailto:[email protected]] On Behalf Of Smotritsky, Alex
Sent: Friday, April 06, 2007 10:11 AM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

I've made some progress.

I did this:

http://www.shinstudio.com/sh.kim/?p=108

and now I get this error:

ORA-12154: TNS:could not resolve service name


-----Original Message-----
From: Discussion of building .NET applications targeted for the Web
[mailto:[email protected]] On Behalf Of Smotritsky, Alex
Sent: Friday, April 06, 2007 12:00 PM
To: [email protected]
Subject: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

I have this code connecting to the db and trying to get a dataset:



//Connect to the datase specified

Database db =
DatabaseFactory.CreateDatabase(this.DefaultDatabase.DatabaseName);



System.Data.Common.DbCommand dbCommand =
db.GetSqlStringCommand(sqlquery);



//Enterprise library call to execute SQL Query specified

return db.ExecuteDataSet(dbCommand);



The last line throws an exception with message:



System.Data.OracleClient requires Oracle client software version 8.1.7
or greater.



I think the problem is what I currently have in Web.Config which is:



<configSections>

<section name="dataConfiguration"
type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseS
ettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=null" />

      <section name="oracleConnectionSettings"
type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.Configuration.Or
acleConnectionSettings,    Microsoft.Practices.EnterpriseLibrary.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />

</configSections>

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com

View archives and manage your subscription(s) at
http://discuss.develop.com

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com