The underlying provider failed on Open

Jan 27, 2010 at 5:24 AM

Hello,

I'm new to Aqua so forgive my ignorance, I just downloaded the sourcecode, tried running it and i get an error -  "The underlying provider failed on Open." I'm using VS 2010, also is there a DB I was supposed to install if so where is it? I have SQL 2005.

Feb 3, 2010 at 4:37 AM

Hi guys, just more information on the error, i have installed sql 2008 but still getting this error

System.Data.EntityException was unhandled by user code
  Message=The underlying provider failed on Open.
  Source=System.Data.Entity
  StackTrace:
       at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       at System.Data.EntityClient.EntityConnection.Open()
       at System.Data.Objects.ObjectContext.EnsureConnection()
       at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Objects.ObjectQuery`1.Execute(MergeOption mergeOption)
       at Infragistics.Guidance.Aqua.DataClient.Data.EntityRepositories.EntityContext.ExecuteQuery[TQuery](IQueryable`1 query) in C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\Aqua.DataClient\Data\EntityRepositories\EntityContext.cs:line 45
       at Infragistics.Guidance.Aqua.DataClient.Common.BaseRepository`2.GetItemCollection(CommandCriteria criteria) in C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\Aqua.DataClient\Common\BaseRepository.cs:line 42
       at Infragistics.Guidance.Aqua.DataClient.Data.EntityRepositories.AdmittancesRepositoryEF.SelectCollection(CommandCriteria criteria) in C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\Aqua.DataClient\Data\EntityRepositories\AdmittancesRepositoryEF.cs:line 52
       at Infragistics.Guidance.Aqua.DataClient.Commands.GetAdmittanceCommand.ProcessCommand(CommandCriteria criteria) in C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\Aqua.DataClient\Commands\GetAdmittanceCommand.cs:line 21
       at Infragistics.Guidance.Aqua.DataClient.Commands.BaseDataCommand`1.worker_DoWork(Object sender, DoWorkEventArgs e) in C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\Aqua.DataClient\Commands\BaseDataCommand.cs:line 106
       at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
  InnerException: System.Data.SqlClient.SqlException
       Message=An attempt to attach an auto-named database for file C:\Users\Sly TheDj\Documents\Aqua-08302009\Aqua\SQLData\MedicalData.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
       Source=.Net SqlClient Data Provider
       ErrorCode=-2146232060
      

       LineNumber=65536
       Number=15350
       Procedure=""
       Server=.\SQLEXPRESS
       State=1
       StackTrace:
            at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
            at System.Data.SqlClient.SqlConnection.Open()
            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
            at System.Data.SqlClient.SqlConnection.Open()
            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       InnerException:

Feb 3, 2010 at 6:06 AM

Got this fixed