server explorer window

[somersbar]

i hav a project in visual basic.net which uses asp.net web forms to
access a microsoft access database. i had fierce trouble getting it to
access the database but fixed it by accident. basically i deleted the
database from under 'data connections' in the 'server explorer window'
on the screen and now it works fine. i was getting errors probably
because of connection strings and access privileges to my database but
now its fine. can anyone tell me why this is?

 

[Patrice]

My first thought would be that the file can only be opened in exclusive mode
(it could perhaps cause problems if multiple users are trying to access your
site).

In the future, please *always* post the exact error message when reporting
an error else we just have to guess from countless possibilities. The error
message can help us to narrow down possible causes...

 

[somersbar]

there is no error message. its working, i just dont understand why, or
whether it will now only work on my computer or something. thanks
anyway.

 

[Patrice]

Of course, I'm not talking about the current situation but the one you had
before "fixing it by accident" : "I had fierce trouble", "I was getting
errors".

So if you had errors previously :
- what was the message ? (without the message we can't do much than guessing
what was the previous situation)

If you never had error messages, I don't answered what is the question...

 

[Patrice]

I meant if you never had error messages, I don't *understand* what is the
question. As you see I'm all confused by your post now ;-)

 

[somersbar]

okay, heres the origonal error which im gettin from line 103 of the
code below:

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
0x890 Thread 0x114 DBC 0x437b04 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 0x890 Thread
0x114 DBC 0x437b04 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 0x890
Thread 0x114 DBC 0x437b04 Jet'. ERROR [HY000] [Microsoft][ODBC
Microsoft Access Driver]General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x890 Thread 0x114 DBC
0x437b04 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 0x890 Thread
0x114 DBC 0x437b04 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 0x890 Thread 0x114 DBC
0x437b04 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 0x890 Thread
0x114 DBC 0x437b04 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0x890 Thread 0x114 DBC 0x437b04 Jet'.
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
'(unknown)'; file already in use.

Source Error:


Line 101: If Not Page.IsPostBack Then
Line 102: AreasDataSet11.Clear()
Line 103: OdbcDataAdapter1.Fill(AreasDataSet11)
Line 104: DropDownList1.DataBind()
Line 105: End If


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

Stack Trace:


[OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access
Driver]General error Unable to open registry key 'Temporary (volatile)
Jet DSN for process 0x890 Thread 0x114 DBC 0x437b04 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
0x890 Thread 0x114 DBC 0x437b04 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
0x890 Thread 0x114 DBC 0x437b04 Jet'.
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
0x890 Thread 0x114 DBC 0x437b04 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:103
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

thanks.