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!

Unable to cast 'System.String' to type 'Oracle.DataAccess.Types.OracleClob'

756334Jul 7 2011 — edited Jul 8 2011
I have a Web Service that installs ODAC 11.1.0.6.21 (Xcopy). The connection string looks like this: Namespace='Oracle.DataAccess.Client',ADORelease='2.111.6.20',DataSource='(description=(address_list=(address=(protocol=tcp)(host=Server1)(port=1521)))(connect_data=(service_name = famous)));Validate Connection=True;Min Pool Size=1;Max Pool Size=1'

This setup works perfectly until...the Web Service is installed on a server that has Oracle Server 11.2.0.2 installed. Once this happens I receive the error above. Some questions:
1) My registry entries are pointing to use the 11.1 installation so why would it be using 11.2? Policy DLL?
2) Is there a way to make it always use 11.1?
3) Why would it work in 11.1 and not 11.2? Bug?

Thanks,
Chris Craft
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2011
Added on Jul 7 2011
2 comments
251 views