<%@ Page Language="C#" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
void Page_Load(Object sender, EventArgs e)
{
String connectString = "DSN=myDSN;Uid=user;Pwd=pass";
OdbcConnection myConn = null;
try
{
myConn = new OdbcConnection( connectString );
myConn.Open();
lblConnectInfo.Text = "Connection successful!";
}
catch
{
lblConnectInfo.Text = "Connection failed!";
}
finally
{
if (myConn != null)
myConn.Close();
}
}
Open an ODBC connection.