Friday, January 4, 2013

Connect to oracle from Visual Studio

http://blogs.msdn.com/b/kaevans/archive/2009/07/18/connecting-to-oracle-from-visual-studio.aspx

If connection to oracle database throws the error "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed"

https://forums.oracle.com/forums/thread.jspa?messageID=10719809

Still this was not working so installed 32 bit oracle client version (on top or earlier 64 bit version) and yet this failed to work.

Finally added tns_names variable as explained below and the connection is now working.

http://yyosifov.blogspot.co.uk/2011/10/ora-12154-tnscould-not-resolve-connect.html
http://kb.tableausoftware.com/articles/knowledgebase/oracle-connection

No comments:

c# httpclient The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch

 If we get this error while trying to get http reponse using HttpClient object, it could mean that certificate validation fails for the remo...