Solved

OracleClient Vs. ODP.NET using Lightweight Sessions

Posted on 2003-10-30
3
359 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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