StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POOracle.DataAccess.dll connectivity failed for web applications
text
Body
copied!<p>I am developing web application in asp.net, we are using Oracle 11g 64 bit server as back end, connecting through the following code fails to connect:</p> <p>I am using Visual Studio 2012(4.5) under 64 bit compilation environment,</p> <p>What I've tried :</p> <p>I tried to connect oracle data access, dll which will perform Oracle db connectivity, it connects at windows applications, while trying with following code on web applications it fails:</p> <pre><code>Imports System.Data Imports Oracle.DataAccess.Client ' ODP.NET Oracle managed provider Imports Oracle.DataAccess.Types Public Class RafiqClass Public Sub Intm() Try Dim oradb As String = "Password=valuesol;Persist Security Info=True;User ID=system;Data Source=orcle" Dim conn As New OracleConnection(oradb) conn.Open() Dim cmd As New OracleCommand cmd.Connection = conn cmd.CommandText = "select department_name from departments where department_id = 10" cmd.CommandType = CommandType.Text Dim dr As OracleDataReader = cmd.ExecuteReader() dr.Read() Catch ex As Exception MsgBox(ex.Message) End Try End Sub End Class </code></pre> <p>I already added reference, library creation for this dll, but still it's not working with respect to web application</p> <p>Whats error which occurs:</p> <p><em>Attempt to load oracle client libraries threw badimageformatexception. This problem will occur when running in 64 bit with the 32 bit oracle client components installed.</em></p> <p>Any guidance to solve this problem are welcome.</p> <p>thanks in advance</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload