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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Lizet Pena de Sola
Sent: Monday, April 09, 2007 2:37 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Monday, April 09, 2007 3:29 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Monday, April 09, 2007 2:26 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Lizet Pena de Sola
Sent: Monday, April 09, 2007 2:13 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Tim Royal
Sent: Monday, April 09, 2007 2:51 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Monday, April 09, 2007 11:46 AM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Tim Royal
Sent: Monday, April 09, 2007 1:11 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Monday, April 09, 2007 6:01 AM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Bob Franken
Sent: Saturday, April 07, 2007 3:12 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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" <***@GHC.ORG>
Date: Sat, 7 Apr 2007 07:09:09
To:DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Friday, April 06, 2007 10:11 AM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Smotritsky, Alex
Sent: Friday, April 06, 2007 12:00 PM
To: DOTNET-***@DISCUSS.DEVELOP.COM
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