Solved

OracleClient Vs. ODP.NET using Lightweight Sessions

Posted on 2003-10-30
3
356 Views
Last Modified: 2012-06-22
Does Microsoft's OracleClient (included with .Net 1.1 framework) support Lightweight session similar to Oracles ODP.net driver? (Proxy Authentication) I know that Lightweight sessions are part of Oracle Call Interface, although I haven't found any documentation on creating a Proxy connection to Oracle with the OracleClient.  

Main reason for asking, I want to maintain connection pooling while using different users to connect to oracle so that we can take advantage of Fine Grained Access Control (FGAC or VPD) when connecting from IIS.

My only slution might be to switch to ODP.... Thanks

I hope this question wasn't confusing.
Gerald

0
Comment
Question by:GeraldC
3 Comments
 
LVL 6

Accepted Solution

by:
etmendz earned 250 total points
ID: 9654913
I've tried using ODP.Net and its connection pooling capability is obviously working. Just switch to ODP.Net which is supposedly faster and better. I am not sure about Oracle's support though in the long run...
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 10232248
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: etmendz {http:#9654913}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

TheLearnedOne
EE Cleanup Volunteer
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now