Hi, I'm trying to connect to oracle using asp.net vb.net. I've done that ok using the provider 'Provider=OraOLEDB.Oracle'. But, I'm running into problems with CLOB datatypes and how to enter them... so on further investigation, people are talking about ODP.NET dataprovider and this seems to be the one that people are using.
So, firstly, what is the OraOLEDB.Oracle provider. Is this deprecated? It is (or was) provided by microsoft is that right? Are there issues with using this provider? Or should I be going with ODP.NET and why?