ODP.Net Vs OleDb
-
Dear, I'm looking for a good comparison between ODP.Net and OleDb for Oracle. So far on google I only found contradictory information on forums where one claims that ODP is faster while the other claims the opposite. Why would you use ODP over OleDb or vice versa? Additionally I know that OleDb uses the MDAC (now Windows DAC) layer to talk to the database (correct?), is this also the case for ODP? many thanks.
V.
-
Dear, I'm looking for a good comparison between ODP.Net and OleDb for Oracle. So far on google I only found contradictory information on forums where one claims that ODP is faster while the other claims the opposite. Why would you use ODP over OleDb or vice versa? Additionally I know that OleDb uses the MDAC (now Windows DAC) layer to talk to the database (correct?), is this also the case for ODP? many thanks.
V.
ODP is good. Unless you have differences between your development and production computer. ODP is different for 32 and 64 bit for some weird reason. Other problem with ODP is that you have to dispose everything and I really mean everything you have created or your server would be down after some duration. Other than that, I believe it is fine. I do not have a material to read though. This is just by the personal experience of.
-
ODP is good. Unless you have differences between your development and production computer. ODP is different for 32 and 64 bit for some weird reason. Other problem with ODP is that you have to dispose everything and I really mean everything you have created or your server would be down after some duration. Other than that, I believe it is fine. I do not have a material to read though. This is just by the personal experience of.
-
d@nish wrote:
Other problem with ODP is that you have to dispose everything and I really mean everything you have created or your server would be down after some duration.
What do you mean exactly, clean up the resources?
V.