How do I best fix this error

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I have tried with Visual Studio 2010 Proffessional and Visual Web developer
express 2010 but I get the following error when I try
to run the web site.
I have also sql server 2008 installed.
I addending a cource and when I try to run the web site that we have got as
examples I get this error.
Does anyone know how to correct so I can run the examples ?


Here is the error that I get
*******************
An attempt to attach an auto-named database for file G:\ASP Module
3\CarsDB.mdf failed. A database with the same name exists, or specified file
cannot be opened, or it is located on UNC share.
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.SqlClient.SqlException: An attempt to attach
an auto-named database for file G:\ASP Module 3\CarsDB.mdf failed. A
database with the same name exists, or specified file cannot be opened, or
it is located on UNC share.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): An attempt to attach an auto-named database for
file G:\ASP Module 3\CarsDB.mdf failed. A database with the same name
exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +5064458
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer
timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, Boolean redirectedUserInstance,
SqlConnection owningObject, SqlConnectionString connectionOptions,
TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions,
String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
+232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +123
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +319
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+92
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments
arguments) +3409
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments,
DataSourceViewSelectCallback callback) +96
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +225
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +127
System.Web.UI.WebControls.GridView.DataBind() +29
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +107
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
+131
System.Web.UI.Control.EnsureChildControls() +162
System.Web.UI.Control.PreRenderRecursiveInternal() +120
System.Web.UI.Control.PreRenderRecursiveInternal() +307
System.Web.UI.Control.PreRenderRecursiveInternal() +307
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4834

//Tony
 
I found the problem it what the path that was wrong

//Tony

Tony said:
I have tried with Visual Studio 2010 Proffessional and Visual Web developer
express 2010 but I get the following error when I try
to run the web site.
I have also sql server 2008 installed.
I addending a cource and when I try to run the web site that we have got
as examples I get this error.
Does anyone know how to correct so I can run the examples ?


Here is the error that I get
*******************
An attempt to attach an auto-named database for file G:\ASP Module
3\CarsDB.mdf failed. A database with the same name exists, or specified
file cannot be opened, or it is located on UNC share.
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.SqlClient.SqlException: An attempt to
attach an auto-named database for file G:\ASP Module 3\CarsDB.mdf failed.
A database with the same name exists, or specified file cannot be opened,
or it is located on UNC share.

Source Error:

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): An attempt to attach an auto-named database
for file G:\ASP Module 3\CarsDB.mdf failed. A database with the same name
exists, or specified file cannot be opened, or it is located on UNC
share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +5064458
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) +35

System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer
timeout, SqlConnection owningObject) +183

System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, Boolean redirectedUserInstance,
SqlConnection owningObject, SqlConnectionString connectionOptions,
TimeoutTimer timeout) +239

System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions,
String newPassword, Boolean redirectedUserInstance) +195

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) +232

System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +185

System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +123
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +319
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+92

System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments
arguments) +3409
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments,
DataSourceViewSelectCallback callback) +96
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +225
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +127
System.Web.UI.WebControls.GridView.DataBind() +29
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +107

System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
+131
System.Web.UI.Control.EnsureChildControls() +162
System.Web.UI.Control.PreRenderRecursiveInternal() +120
System.Web.UI.Control.PreRenderRecursiveInternal() +307
System.Web.UI.Control.PreRenderRecursiveInternal() +307
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4834

//Tony
Click to expand...
 
I have tried with Visual Studio 2010 Proffessional and Visual Web
developer express 2010 but I get the following error when I try
to run the web site.
I have also sql server 2008 installed.
I addending a cource and when I try to run the web site that we have got
as examples I get this error.
Does anyone know how to correct so I can run the examples ?


Here is the error that I get
*******************
An attempt to attach an auto-named database for file G:\ASP Module
3\CarsDB.mdf failed. A database with the same name exists, or specified
file cannot be opened, or it is located on UNC share.
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.SqlClient.SqlException: An attempt to
attach an auto-named database for file G:\ASP Module 3\CarsDB.mdf
failed. A database with the same name exists, or specified file cannot
be opened, or it is located on UNC share.
Click to expand...

If it is your own box and not a web hotel, then I will strongly
recommend using a regular database instead of the on demand
attach of a database feature.

Much fewer problems.

Arne
 
If it is your own box and not a web hotel
Click to expand...

Did you really mean to say web "hotel" or was it supposed to be "host"? Just
wondering if "web hotel" is a term I'm not familiar with.
 
Did you really mean to say web "hotel" or was it supposed to be "host"? Just
wondering if "web hotel" is a term I'm not familiar with.
Click to expand...

I mean to write "web hotel".

But a quick googling seems to indicate that the
term is only used in Denmark/Norway/Sweden. I
thought it was a common term. My apologies for
confusing people.

A web hotel in Denmark is a cheap web hosting
solution. You buy a standard package where you pay
a specific low amount per month, have a specific limit
on space used on the servers and a specific
software package. The servers are shared with
thousands of other users so performance is
non predictable. But it is cheap.

Compared with a professional web hosting
solution where you negotiate a customized
package.

The relevancy for the question is that the cheap
web hotel will either give you one database or may just
tell you to upload and attach the MDF while with
no choice while for the professional web
hosting you could ask for N databases to be
created.

Arne
 
Back
Top