I am trying to connect to the Northwind database to follow the examples in the beginning asp.net databases book. i have installed visual studio.net 2002 professional, the .net framework, and MSDE. i still am unable to make the connection to the Northwind Database. can anyone help?

What error are you getting? It also may help to see a copy of the code you are using.

the error says sql server error 4060. i am not using any code i am simply attempting to add the connection to the Northwind Database so i can follow the example code supplied in the beginning asp.net database. i am not sure why i am getting this. the instructions seem so easy and i am already frustrated.

Try this:

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="C#" runat="server">
void Page_Load()
{
string strConnect;
OleDbConnection objConnect = null;

strConnect = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\Ch12\Northwind.mdb";

objConnect = new OleDbConnection(strConnect);
objConnect.Open();
}

</script>