none
still getting an error when I try to open the connection (oledb) RRS feed

  • Question

  • public System.Data.Common.DbConnection myConnection;

    public OleDbConnection cnOledb;

    public Form1()

    {

    InitializeComponent();

    cnOledb = new OleDbConnection();

    cnOledb.ConnectionString =@"Provider=microsoft.jet.OLEDB.4.0;Data Source=C:\Documents and Settings\bb\My Documents\db1.mdb;Integrated Security=SSPI";

    }

     

    private void button1_Click(object sender, EventArgs e)

    {

    myConnection.Open();

    MessageBox.Show(myConnection.State.ToString());

    myConnection.Close();

    }

     

    getting the follwoing error when I try to use button1_click:-

     

    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

     please  help
    Monday, December 8, 2008 1:23 PM

All replies