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

Do you have a tool such as SQL Navigator (by Quest Software) that will
allow you to connect to the Oracle database? This tool uses the oracle
client, if there is any configuration issue in the Oracle client, SQL
navigator will certainly not work. We use it all the time to run the
Oracle sprocs and troubleshoot any tnsnames.ora problem, before adding
any extra data access layer. 
You can also try directly with the Microsoft Data Provider for Oracle or
ODP.NET. We couldn't use the EL 1.1, or the MS data provider in the past
with Oracle, mainly because of this bug (should be fixed in EL 2.0)
 
system.Data.OracleClient.dll 1.0.5 and TNSNAME longer than 16 char
http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.ado
net/topic3888.aspx



-----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 2: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