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:

Regex obfuscate email

 Use this code in C# to obfuscate email using regex // Online C# Editor for free // Write, Edit and Run your C# code using C# Online Compile...