Trying to make a connection a database on a server

[napstar]

I need help to connect to an access db which is on a server,I did the follwing but i had an error.how do i correct this?


string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=100.0201.01\\BordercomTrainersDB.mdb";
string strSQL = "SELECT * FROM CoursesTable";
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
try
{
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "CourseName");
DataTable dTable = dtSet.Tables[0];
foreach (DataRow dtRow in dTable.Rows)
{

comboBox1.Items.Add(dtRow["CourseName"].ToString());

}
}

[nateraaaa]

I need help to connect to an access db which is on a server,I did the follwing but i had an error.how do i correct this?


string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=100.0201.01\\BordercomTrainersDB.mdb";
string strSQL = "SELECT * FROM CoursesTable";
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
try
{
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "CourseName");
DataTable dTable = dtSet.Tables[0];
foreach (DataRow dtRow in dTable.Rows)
{

comboBox1.Items.Add(dtRow["CourseName"].ToString());

}
}

Please post the error that you received.

Nathan

[napstar]

c:\documents and settings\chris\my documents\visual studio 2005\projects\Bordercom\BordercomTrainers\bin\debu g\ \\Server1\training\\BordercomTrainersDB.mdb is not a valid path.Make sure path name is spelled correctly correct and that you are connected to the server on which the file resides.