Databases
StackOverflow2013
Postsdbo
POSystem Data Entity. The underlying provider failed on Open
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSystem Data Entity. The underlying provider failed on Open
    primarykey
    data
    text
    <p>I am creating 2 projects that have the same database (it's an MDF database). The first one is the map editor, and I use XNA 4 and Web Services to connect to it. The second one is the game itself and uses XNA 3.1 and Entity Data Model to connect database. </p> <p>When I run the map editor and access the database, it runs properly. Bbut when I run the game and access the database, it shows an error "The underlying provider failed on Open"</p> <p>I think the connection from the web service is not closed yet. But I don't know where I should close the connection.</p> <p>Here is my code from the web service:</p> <pre><code>public Map AddNewMap(string username, string mapName, int sizeX, int sizeY) { using (BaseModelDataContext context = new BaseModelDataContext()) { Map newMap = new Map() { Username = username, Name = mapName, SizeX = sizeX, SizeY = sizeY, Upload_Date = DateTime.Now, Status = 0 }; context.Maps.InsertOnSubmit(newMap); context.SubmitChanges(System.Data.Linq.ConflictMode.FailOnFirstConflict); context.Dispose(); return newMap; } } </code></pre> <p>EDIT:</p> <p>Here is the entity data model code :</p> <pre><code>using (MazeEntities ent = new MazeEntities()) { ent.Connection.Open(); return (from map in ent.Map select map).ToList&lt;Map&gt;(); } </code></pre> <p>This code runs properly if I did not use the web service before. If I use the web service first, it shows an error at ent.Connection.Open();</p> <p>Here is the inner exception:</p> <blockquote> <p>Cannot open user default database. Login failed.\r\nLogin failed for user 'erkape-PC\erkape'.</p> </blockquote> <p>Connection string for web service :</p> <blockquote> <p>connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\3DMapDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"</p> </blockquote> <p>Connection string for the game:</p> <blockquote> <p>"metadata=res://<em>/MazeDataModel.csdl|res://</em>/MazeDataModel.ssdl|res://*/MazeDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=D:\eRKaPe\DropBox\TA\Program\3D_Map_Editor\3DMapEditorServices\App_Data\3DMapDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" /></p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USerkape
    1. USerkape
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSystem Data Entity. The underlying provider failed on Open
      1. USMarcin Zawadzki
      1. VTFavorite
    1. COThe using-block automatically disposes the context after use. You don't need to explicitly call context.Dispose() here. This doesn't solve your problem. Just an info in general. Through the disposal of the context (no matter if implicitly or explicitly) the underlying connection should be closed as well. The problem must be somewhere else. Sorry I couldn't help more.
      singulars
      1. POSystem Data Entity. The underlying provider failed on Open
      1. USDennis Traub
    2. COI think the inner exception would tell you what the error is. Check your connection string and what is the user that attempts to connect to the database and its permissions.
      singulars
      1. POSystem Data Entity. The underlying provider failed on Open
      1. USdan radu
    3. COPost the inner exception(s) text here. Also, consider that disposing of the context disposes underlying connection, but dispose of the connection **does not** mean that connection will be physically **closed**. It just returns to the connection pool and can be reused then.
      singulars
      1. POSystem Data Entity. The underlying provider failed on Open
      1. USDennis
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload