Member Avatar for krunalvarma

hello all,

can any one teach me how to connect to oracle database
from asp.net in vb 2005

pls reply me with code and example if u can

bye

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man 
<%@ Page CompilerOptions='/R:"C:\Program Files\Microsoft.NET\OracleClient.Net\System.Data.OracleClient.dll"' Language="vb" %>
<%@ import Namespace="System.Data.OracleClient" %>
<%@ Import Namespace="System.Data" %>
<%@ import Namespace="System.XML" %>
<script runat="server">

    Sub Page_Load(Sender As Object, E As EventArgs)

        Dim oOracleConn As OracleConnection = New OracleConnection()
        Dim oraODR as System.Data.OracleClient.OracleDataReader
            Dim oraConn As System.Data.OracleClient.OracleConnection
            Dim oraCMD as System.Data.OracleClient.OracleCommand
        Try
            oOracleConn.ConnectionString = "User ID=a; Data Source=b; Password=c;"
            oOracleConn.Open()
            Response.write("Connected to Oracle.")
            oraCMD = New System.Data.OracleClient.OracleCommand()
                oraCMD.Connection = oOracleConn
                oraCMD.CommandText = "SELECT tid, descrption FROM TSTAT;"
                oraODR = oraCMD.ExecuteReader()
        Catch
        Finally
        End Try
   End Sub
 </script>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.