Groups > comp.databases.ms-sqlserver > #1050

Re: How do I fix this error

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	bradbury9 <ray.bradbury9@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: How do I fix this error
Date	Thu, 10 May 2012 22:44:39 -0700 (PDT)
Organization	http://groups.google.com
Lines	60
Message-ID	<7659906.610.1336715079870.JavaMail.geo-discussion-forums@vbq19> (permalink)
References	<4fabfbd0$0$290$14726298@news.sunsite.dk> <XnsA04FF3151DD17Yazorman@127.0.0.1> <4fac40d5$0$293$14726298@news.sunsite.dk>
NNTP-Posting-Host	95.16.97.75
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1336715175 21253 127.0.0.1 (11 May 2012 05:46:15 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Fri, 11 May 2012 05:46:15 +0000 (UTC)
In-Reply-To	<4fac40d5$0$293$14726298@news.sunsite.dk>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=95.16.97.75; posting-account=jIl9nQoAAAA9P37IIqQq64yAx-2NQYiu
User-Agent	G2/1.0
Xref	csiph.com comp.databases.ms-sqlserver:1050

Show key headers only | View raw

El viernes, 11 de mayo de 2012 00:27:28 UTC+2, Tony  escribió:
> It was path problem that I had now it works.
> But I wonder you mentioned that using the AttachDBFilename was not so good 
> according to you
> If I have a database called CarsDB.mdf with these setting in web.config how 
> would I write to skip this
> AttachDBFilename ?
> The CarsDB.mdf is located in the App_data folder which the DataDirectory is 
> refering to.
> 
> <connectionStrings>
>     <add name="CarsDBConnectionString2" connectionString="Data 
> Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CarsDB.mdf;
>          Integrated Security=True;User Instance=True" />
>   </connectionStrings>
> 
> //Tony
> 
> 
> "Erland Sommarskog"  skrev i meddelandet 
> news:XnsA04FF3151DD17Yazorman@127.0.0.1...
> > Tony writes:
> >> 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.
> >
> > Reading the error message, there appears to be three possibilities:
> >
> > 1) You already have a database CarsDB.
> > 2) There is no file G:\ASP Module 3\CarsDB.mdf
> > 3) G is a mapped network drive.
> >
> > The AttachDBFilename is a connection-string option that I've never
> > understood the point with. Why not just attach the database once and
> > for all?
> >
> > -- 
> > Erland Sommarskog, SQL Server MVP
> >
> > Links for SQL Server Books Online:
> > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> >

Try not to double post

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

How do I fix this error "Tony" <johansson.andersson@telia.com> - 2012-05-10 19:33 +0200
  Re: How do I fix this error Erland Sommarskog <esquel@sommarskog.se> - 2012-05-10 23:53 +0200
    Re: How do I fix this error "Tony" <johansson.andersson@telia.com> - 2012-05-11 00:27 +0200
      Re: How do I fix this error Erland Sommarskog <esquel@sommarskog.se> - 2012-05-11 09:02 +0200
        Re: How do I fix this error "Tony" <johansson.andersson@telia.com> - 2012-05-11 10:34 +0200
          Re: How do I fix this error "Tony" <johansson.andersson@telia.com> - 2012-05-11 11:14 +0200
          Re: How do I fix this error Erland Sommarskog <esquel@sommarskog.se> - 2012-05-11 12:54 +0200
      Re: How do I fix this error bradbury9 <ray.bradbury9@gmail.com> - 2012-05-10 22:44 -0700

csiph-web