ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Te

Discussion in 'ASP .Net' started by bazzer, Mar 30, 2006.

  1. bazzer

    bazzer Guest

    hey,
    im trying to access a microsoft access database from an ASP.NET web
    application in visual basic 2003.NET. i get the following error when i
    try running it:

    Server Error in '/CinemaBookingSystem' Application.
    --------------------------------------------------------------------------------

    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
    Unable to open registry key 'Temporary (volatile) Jet DSN for process
    0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC
    Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000]
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread
    0x228 DBC 0x437b94 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft
    Access Driver] Could not use '(unknown)'; file already in use. ERROR
    [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable
    to open registry key 'Temporary (volatile) Jet DSN for process 0xffc
    Thread 0x228 DBC 0x437b94 Jet'. ERROR [HY000] [Microsoft][ODBC
    Microsoft Access Driver]General error Unable to open registry key
    'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC
    0x437b94 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]
    Could not use '(unknown)'; file already in use.
    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.Odbc.OdbcException: ERROR [HY000]
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread
    0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager]
    Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC
    Microsoft Access Driver]General error Unable to open registry key
    'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC
    0x437b94 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]
    Could not use '(unknown)'; file already in use. ERROR [HY000]
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread
    0x228 DBC 0x437b94 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft
    Access Driver]General error Unable to open registry key 'Temporary
    (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'.
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
    '(unknown)'; file already in use.

    Source Error:


    Line 108: AreaDataSet11.Clear()
    Line 109: CinemaDataSet21.Clear()
    Line 110: OdbcDataAdapter1.Fill(AreaDataSet11)
    Line 111: DropDownList1.DataBind()
    Line 112:


    Source File: c:\inetpub\wwwroot\CinemaBookingSystem\WebForm1.aspx.vb
    Line: 110

    Stack Trace:


    [OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access
    Driver]General error Unable to open registry key 'Temporary (volatile)
    Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'.
    ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
    SQLSetConnectAttr failed
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
    Unable to open registry key 'Temporary (volatile) Jet DSN for process
    0xffc Thread 0x228 DBC 0x437b94 Jet'.
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
    '(unknown)'; file already in use.
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
    Unable to open registry key 'Temporary (volatile) Jet DSN for process
    0xffc Thread 0x228 DBC 0x437b94 Jet'.
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
    Unable to open registry key 'Temporary (volatile) Jet DSN for process
    0xffc Thread 0x228 DBC 0x437b94 Jet'.
    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
    '(unknown)'; file already in use.]
    System.Data.Odbc.OdbcConnection.Open()
    System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
    ConnectionState& originalState)
    System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
    startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
    CommandBehavior behavior)
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
    startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
    CommandBehavior behavior)
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
    CinemaBookingSystem.WebForm1.Page_Load(Object sender, EventArgs e)
    in c:\inetpub\wwwroot\CinemaBookingSystem\WebForm1.aspx.vb:110
    System.Web.UI.Control.OnLoad(EventArgs e)
    System.Web.UI.Control.LoadRecursive()
    System.Web.UI.Page.ProcessRequestMain()


    The only thing is, if i delete the data connection from the server
    explorer window, it works perfectly.

    can anyone tell me why this is? thanks.
    bazzer, Mar 30, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page