Trying to Connect to SQl Server database - SqlConnection Not Defined Error
Thank you for looking at my question. I am trying to build a web-based system to interrogate database tables on our SQL server.
I am falling at the first hurdle - I can't connect to the database and don't know what I'm doing wrong. I have attached the code I am using and would appreciate somebody pointing out my error.
Thank you in advance for your help,
<%@ Page Language="VB" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.Odbc" %><script runat="server"> sub Page_Load(obj as object, e as eventargs) dim objConn as new SqlConnection("user id=username; password=password; data source=ServerName; initial catalog=DatabaseName;") dim objCmd as new SqlCommand ("SELECT ColumnName FROM TableName", objConn) dim objReader as SqlDataReader objConn.Open objReader = objCmd.ExecuteReader while objReader.Read Response.write(objReader.GetString(0) & "<br>") end while objConn.Close end sub</script>Error Message:Compiler Error Message: BC30002: Type 'SqlConnection' is not defined.Source Error:Line 6: sub Page_Load(obj as object, e as eventargs)Line 7: Line 8: dim objConn as new SqlConnection("user id=anodising; password=bugger; data source=SCLServer; initial catalog=SCLAnodising;")Line 9: dim objCmd as new SqlCommand ("SELECT CustStockCode FROM ArCustStkXref", objConn)Line 10: