Hello !
I create a windows application in c# and i want to connect ms-access database from ftp server.
But it's shows error "could not connect server".
Please help me any one.
My Code
I create a windows application in c# and i want to connect ms-access database from ftp server.
But it's shows error "could not connect server".
Please help me any one.
My Code
Code:
try
{
OleDbConnection cnn = new OleDbConnection(@"Provider=MS Remote;Remote Server=ftp://domainname.in;Remote Provider=Microsoft.Jet.OLEDB.4.0;user id=uid ; password=password ;Data Source=mydb.accdb;Persist Security Info=True");
try
{
OleDbCommand cmd = new OleDbCommand("insert into table([a1][a2])values(" + textBox1.Text.Trim() + "," + textBox2.Text.Trim() + ")", cnn);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
catch (WebException ex)
{
MessageBox.Show(ex.Message);
}