Mega Code Archive
Connect to Oracle with OracleConnection
<![CDATA[
<%@ Page Language="C#" debug="true" %>
<%@ Import Namespace="System.Data.OracleClient" %>
<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
String connectString = "Data Source=Oracle-Test;User ID=user;Password=pass";
OracleConnection myConn = null;
try
{
myConn = new OracleConnection( connectString );
myConn.Open();
lblConnectInfo.Text = "Connection successful!";
}
catch
{
lblConnectInfo.Text = "Connection failed!";
}
finally
{
if (myConn != null)
myConn.Close();
}
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form id="form1" method="post" runat="server">
This page simply tries (and fails) to open an Oracle connection.
<asp:Label id="lblConnectInfo" runat="server"></asp:Label>
</form>
</body>
</html>
]]>