Results 1 to 3 of 3

Thread: database connection problem

  1. #1
    Join Date
    Dec 2006
    Location
    Selangor
    Posts
    7
    Rep Power
    0

    database connection problem

    somebody please help me on this. i'm using visual studio.net 2003 and try to conect to access database but fail. the error come out like this:

    Server Error in '/Connected Access' Application.
    --------------------------------------------------------------------------------

    The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\myname\Desktop\Classroom management database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
    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: The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\myname\Desktop\Classroom management database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

    Source Error:


    Line 24: {
    Line 25: // Put user code to initialize the page here
    Line 26: connection.Open();
    Line 27: System.Data.OleDb.OleDbDataReader reader;
    Line 28: reader= command.ExecuteReader();


    Source File: c:\inetpub\wwwroot\connected access\accessdata.aspx.cs Line: 26

    Stack Trace:


    [OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\myname\Desktop\Classroom management database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.]
    System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
    System.Data.OleDb.OleDbConnection.InitializeProvid er()
    System.Data.OleDb.OleDbConnection.Open()
    Connected_Access.AccessData.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\connected access\accessdata.aspx.cs:26
    System.Web.UI.Control.OnLoad(EventArgs e)
    System.Web.UI.Control.LoadRecursive()
    System.Web.UI.Page.ProcessRequestMain()




    --------------------------------------------------------------------------------
    Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

  2. #2
    Join Date
    Aug 2006
    Location
    Malaysia
    Posts
    1,576
    Rep Power
    185
    Do you open the access (.mdf) file to view its table design etc using MS Access, at the same time, running the developed application?

    Viewing the design part in the MS Access could trigger the error when the developed app is trying to interact with the mdf file.
    Last edited by genzy; 30-04-2007 at 04:30 AM.

  3. #3
    Join Date
    Dec 2006
    Location
    Selangor
    Posts
    7
    Rep Power
    0
    No, the mdf file is not open but the same error come out. what else could be wrong?. Is it the coding?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database connection
    By checkitout in forum Website Programming
    Replies: 6
    Last Post: 24-08-2009, 08:46 PM
  2. Replies: 15
    Last Post: 30-12-2006, 04:40 PM
  3. CFM DNS-Less Connection
    By zhnme in forum Website Programming
    Replies: 1
    Last Post: 14-03-2005, 02:23 PM
  4. Connection Refused?
    By lcf in forum Mamak Stall
    Replies: 9
    Last Post: 07-01-2005, 09:52 PM
  5. what is your connection speed?
    By meredzone in forum Mamak Stall
    Replies: 23
    Last Post: 12-04-2004, 11:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37