Well I have an dbOleConnection object set at design time to:
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\Inetpub\wwwroot\Flows\db1.mdb;Mode=ReadW rite|Share Deny
None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;Jet OLEDB:SFP=False
And my dummy function simply tries to open the oleDbConnection object by
invoking the Open method. That's it.
This is the error I'm getting:
Server Error in '/Flows' Application.
----------------------------------------------------------------------------
----
Unspecified error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Unspecified error
Source Error:
Line 62: private void Button1_Click(object sender, System.EventArgs e)
Line 63: {
Line 64: oleDbConnection1.Open();
Line 65: System.Data.OleDb.OleDbDataReader myReader =
oleDbCommand1.ExecuteReader();
Line 66: while (myReader.Read())
Source File: c:\inetpub\wwwroot\flows\webform1.aspx.cs Line: 64
Stack Trace:
[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvid er()
System.Data.OleDb.OleDbConnection.Open()
Flows.WebForm1.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\flows\webform1.aspx.cs:64
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
System.Web.UI.Page.ProcessRequestMain()
Thanks again for any help!
"Sreejumon[MVP]" <sr********@hotmail.com> wrote in message
news:OV*************@TK2MSFTNGP12.phx.gbl...
Could you please send your code snippet ?
--
Let me know if you need further help
Regards
Sreejumon[MVP]
www.mstechzone.com
"Mohammed AlQuraishi" <si******@hotmail.com> wrote in message
news:#m**************@TK2MSFTNGP12.phx.gbl... Well I did set impersonation to true, which, if what I gathered from the
document is correct, ought to be sufficient to resolve the problem. However, I am getting a new error now, namely "Unspecific error has occurred"...
Any ideas? Thank you very much!
"Sreejumon[MVP]" <sr********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... Hi,
I think the problem is the ASPNET user permision.
Please refer the following link.
http://support.microsoft.com/default...;EN-US;Q316675
--
Let me know if you need further help
Regards
Sreejumon[MVP]
www.mstechzone.com
"Mohammed AlQuraishi" <si******@hotmail.com> wrote in message
news:eN**************@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> I'm trying to connect to an MS Access database using ADO.NET and C#, but I'm
> getting the dreaded "Microsoft Jet database engine cannot open the file 'x'.
> It is already opened exclusively by another user, or you need permission to
> view its data."
>
> Any ideas as to why? I set up a connection using Jet 4.0 and I'm
able to > open the database from within VC#.
>
> Thanks for any help!
>
>