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

Actually, with sql*plus that was just a temporary issue. Capitalization
of the user name, password and host string solved it and subsequently I
could connect without capitalization. Capitalization in the web.config
for my app hasn't helped yet.


-----Original Message-----
From: Smotritsky, Alex
Sent: Monday, April 09, 2007 9:01 AM
To: 'Discussion of building .NET applications targeted for the Web'
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>



<connectionStrings>

      <add name="GAP"

            connectionString="server=bla.bla.bla;uid=bla;pwd=bla;"

            providerName="System.Data.OracleClient"/>

</connectionStrings>



Any thoughts on this or how to connect to oracle with this version of
the enterprise library and asp.net 2.0 in general?






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