home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,629 of 19,505   
   Tony to All   
   Re: How do I fix this error   
   11 May 12 00:27:28   
   
   From: johansson.andersson@telia.com   
      
   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.   
      
      
          
        
      
   //Tony   
      
      
   "Erland Sommarskog"  skrev i meddelandet   
   news:XnsA04FF3151DD17Yazorman@127.0.0.1...   
   > Tony (johansson.andersson@telia.com) 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, esquel@sommarskog.se   
   >   
   > 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   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca