<%@ Page Language="C#" debug="true" %>
<%@ Import Namespace="System.Data.OracleClient" %>
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();
}
}
This page simply tries (and fails) to open an Oracle connection.