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

I've done that, it doesn't fix my problem. I have an application on my
computer that uses asp.net 2.0 and the enterprise library and it works
fine. This one doesn't. The only important difference I can think of is
that this one runs against IIS.

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

Hrm,
Try this recipe:

To give the Authenticated Users group privilege to the Oracle Home
directory.

    * Log on to Windows as a user with Administrator privileges.
    * Start Window Explorer and navigate to the ORACLE_HOME folder.
    * Choose properties on the ORACLE_HOME folder.
    * Click the "Security" tab of the "Properties" window.
    * Click on "Authenticated Users" item in the "Name" list.
    * Uncheck the "Read and Execute" box in the "Permissions" list under
the "Allow" column.
    * Re-check the "Read and Execute" box under the "Allow" column
    * Click the "Advanced" button and in the "Permission Entries" verify
that "Authenticated Users" are listed with permission = "Read &
Execute", and Apply To = "This folder, subfolders and files". If not,
edit that line and make sure that "Apply To" drop-down box is set to
"This folder, subfolders and files". This should already be set properly
but it is important that you verify it.
    * Click the "Ok" button until you close out all of the security
properties windows. The cursor may present the hour glass for a few
seconds as it applies the permissions you just changed to all subfolders
and files.
    * Reboot, to assure that the changes have taken effect.

Try your application again. It seems that the ASP.NET account already
has permissions if your web application works fine without the EL 2.0.






-----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 3:29 PM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

I think it may be an IIS problem because a big difference between my
test asp.net app and the one that matters is that the one that matters
is running against IIS.

-----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 2:26 PM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

I don't think it's an oracle client problem. I've created 2 test apps in
winforms 2.0 and (asp.net 2.0 with connection string in web.config and
using daab) they get data from oracle no problem. I'm having the problem
with an asp.net 2.0 app that I upgraded from 1.1.


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

How about trying with the classes in System.data.Oracleclient namespace
directly or with the ODP.NET?


-----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:51 PM
To: [email protected]
Subject: Re: [DOTNET-WEB] Enterprise Library January 2006 Data Access
Application Block and Oracle

Nod. When I saw the subsequent post showing you were able to connect via
sql*plus, it eliminated a tnsnames.ora issue.

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 11:46 AM
To: [email protected]
Subject: Re: [DOTNET-WEB] 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(r)  http://www.develop.com

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

===================================
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(r)  http://www.develop.com

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

===================================
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(r)  http://www.develop.com

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

===================================
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