[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

OracleClient Vs. ODP.NET using Lightweight Sessions

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
GeraldC
Asked:
GeraldC
1 Solution
 
etmendzCommented:
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
 
Bob LearnedCommented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now