Unable to cast 'System.String' to type 'Oracle.DataAccess.Types.OracleClob'
756334Jul 7 2011 — edited Jul 8 2011I 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