Oracle with asp.net

Question

I am trying to connect dropdownlist to bound with oracle 10g when i run the page from VS it works fine but when i run it from IIS it give the following error

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

My connection string is

<add 
     name="ConnectionString" 
     connectionString="Data Source=sml2;Persist Security Info=True;User 
                       ID=sfpl;Password=a;Unicode=True" 
     providerName="System.Data.OracleClient" />

please solve my problem

My connection string is <add name="ConnectionString" connectionString="Data Source=sml2;Persist Security Info=True;User ID=sfpl;Password=a;Unicode=True" providerName="System.Data.OracleClient" /> — Adeel Aslam
– Adeel Aslam, Commented Nov 26, 2011 at 7:51
Read this article - blogs.msdn.com/b/fabdulwahab/archive/2011/11/13/… and social.msdn.microsoft.com/Forums/en-US/winformssetup/thread/… — KV Prajapati
– KV Prajapati, Commented Nov 26, 2011 at 7:57
No dear i already read these articles but the problem is same please tell me some thing else — Adeel Aslam
– Adeel Aslam, Commented Nov 26, 2011 at 9:04

user1054194 · Accepted Answer · 2011-11-26 12:56:19Z

1

Oracle Providers for ASP.NET support this service provider mechanism allowing application state storage within an Oracle database. Existing ASP.NET provider developers will discover the Oracle Providers for ASP.NET are easy to learn and use as they share a common schema and API with existing ASP.NET providers. They integrate seamlessly with existing ASP.NET services and controls, just like other ASP.NET providers.

Oracle offers the following providers:

Membership Provider Role Provider Site Map Provider Session State Provider Profile Provider Web Events Provider Web Parts Personalization Provider Cache Dependency Provider

answered Nov 26, 2011 at 12:56

user1054194

1062 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rick schott · Accepted Answer · 2011-11-26 12:04:35Z

1

You have to have the Oracle client software installed. You also have to make sure ISUER or your app pool's identity has permission to the Oracle client directory, same for TNS directories and resources.

answered Nov 26, 2011 at 12:04

rick schott

21.1k5 gold badges54 silver badges81 bronze badges

Collectives™ on Stack Overflow

Oracle with asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related