<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
<script runat="server" language="c#">
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Driver={SQL Server};SERVER=winsql3.abac.com;Database=jgrant_aw cconnect;" +
"UID=xxx;PWD=xxx");
SqlCommand comm = new SqlCommand("SELECT txt_username FROM jgrant_awcconnect.dbo.usr_user", conn);
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
employeesLabel.Text = (string)reader["txt_username"];
reader.Close();
conn.Close();
}
</script>
<body>
<form runat="server">
<asp:Label ID="employeesLabel" runat="server" />
</form>
</body>
I left off some of the html tags for space sake. For some reason I keep getting an error. The error message says "Keyword not supported: 'Driver'"
I tried it without the driver tag but it didnt work either. It passed the compiler but did not connect properly. This connection matches to a .udl generated connection string but it still throws an exception. So I am kind of thinking now that I am doing something wrong above and that the connection string may be right? Am I on the right track here?
connection error
