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:

SSL Error - The connection for this site is not secure

 After cloning a git repo of dot net framework website and trying to run it all I could see was this error Turns out the fix was to simply e...