Open Connection using OLEDB

Question

I am getting a strange error when opening a connection using c#. Here is the exception i am getting. System.Data.Oledb.Oledbexceptoion: No Error information available: 0x8007007E. at System.Data.Oledb.oledbconnection.ProcessResult32(int32hr)..... Here is the code i am using. oleDbConnectionObject.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=abc.MDB; if(oleDbConnectionObject.State == 0) { oleDbConnectionObject.Open(); } The above routine fails while opening a connection. I think this has to do with some of the dll's but not sure which one. any help is appreciated... Rajesh.

madhboda · Answer

I assume it might because of unable to locate yr database.. Try following.. OleDbConnection cn; string path; path = HttpContext.Current.Server.MapPath(abc.mdb); cn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=+path); OldDbCommand cmd; cmd.CommandText = your query..... cmd.Connection = cn; cn.Open(); Hope it works....