I want to connect ms-access from ftp server in c# windows application

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Parvender
    New Member
    • May 2015
    • 1

    I want to connect ms-access from ftp server in c# windows application

    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

    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);
                    
                }
    Last edited by Rabbit; May 30 '15, 05:21 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Working...