.net – Managed ODP.NET driver does not show up in Data Source dialog

I've been looking into this problem further, and you simply need to grab all the appropriate DLL's from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers.

I've explained how to do this here: http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c Here's the gist of it though:

• Download ODP.Net
• Unzip the file
• Unzip all the JAR's in it
• Grab these dll's that were just unzipped:
  • oci.dll (renamed from 'oci.dll.dbl')
  • Oracle.DataAccess.dll
  • oraociicus11.dll
  • OraOps11w.dll
  • orannzsbb11.dll
  • oraocci11.dll
  • ociw32.dll (renamed from 'ociw32.dll.dbl')
• Put all the DLLs in the same folder as your C# Executable

This will check the content type and the X-Requested-With header which pretty much all javascript frameworks use:

public bool IsJsonRequest() {
    string requestedWith = Request.ServerVariables["HTTP_X_REQUESTED_WITH"] ?? string.Empty;
    return string.Compare(requestedWith, "XMLHttpRequest", true) == 0
        && Request.ContentType.ToLower().Contains("application/json");
}