Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Differences between DataAccess.dll and ManagedDataAccess.dll

966073Oct 4 2012
So far I found two differences between the fully managed version and the "old" version.
If somebody finds other differences it would be nice to add them here.

1. The connection string has "problems" with whitespaces and "CR/LF".
When I start a connection using nhibernate the old version workes with a configuration like this:

Data Source =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = xxxxxxxxx)
(SERVER = DEDICATED)));
User Id=test;
Password=test;

while the new managed version needs this:
Data Source =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT = 1521)))
(CONNECT_DATA =
(SERVICE_NAME = xxxxxxxxx)
(SERVER = DEDICATED)));User Id=test;Password=test;
Else you get an error about " User Id:"

2. Due to an error in our code there was a possibility to call "Dispose" on an OracleCommand twice.
The new version throws an exception now. (which is good as it shows the error)
The old version runs without any error being thrown.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2012
Added on Oct 4 2012
0 comments
547 views