Re: Do you have to rename ASPNETDB.MDF for ASP.NET 2.0 Web Hosters?

VB Programmer,

That's what I thought at first also. And I found out otherwise when I tried
to deploy a SQL Express database to a site experimentally. The ISP didn't
have SQL Express installed on the server. And because it wasn't installed my
database couldn't be loaded. It seems that SQL Express needs to be installed
on the server and it loads up databases just like SQL does. The only real
noticeable difference is how many connections it handles (of course there
are many other differences, but not many that affect day to day development
if a site is small). Anyway, no, SQL Express is not like an access database
file because the server has to be running a component.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"VB Programmer" <dont@xxxxxxxxxxx> wrote in message
news:%23y0pJE8IGHA.3492@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks. Few questions...
>
> 1. Why should it matter since everything (like the connection string) is
> referencing my app_data dir? Isn't the SQLExpress MDF handled similar to
> an Access MDB database? It's just a database file in a dir...
> 2. If I simply rename the db (in VS2005) and change the web.config VS
> STILL automatically creates the ASPNETDB.mdf. Any ideas why?
>
> Thanks again....
>
> "S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate.com> wrote
> in message news:OMnCg74IGHA.3904@xxxxxxxxxxxxxxxxxxxxxxx
>> Well,
>>
>> If they already have a database out their with the same name (some other
>> customer probably deployed before you did and they are calling it first
>> come first served) your only choice will be to rename and change your
>> code... You should just need to change your connection string to the
>> database file in your web.config.
>>
>> --
>> Sincerely,
>>
>> S. Justin Gengo, MCP
>> Web Developer / Programmer
>>
>> www.aboutfortunate.com
>>
>> "Out of chaos comes order."
>> Nietzsche
>> "VB Programmer" <dont@xxxxxxxxxxx> wrote in message
>> news:u%23evGF3IGHA.3696@xxxxxxxxxxxxxxxxxxxxxxx
>>> My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db
>>> for my 2.0 site to work. Is this accurate?
>>>
>>> If so, how can I rename it without breaking anything on my site?
>>>
>>> FYI: This is the error I'm getting after I publish my site to their
>>> servers...
>>> An attempt to attach an auto-named database for file
>>> c:\hosting\myhost\member\myaccount\customerdomains\mysite\App_Data\ASPNETDB.MDF
>>> failed. A database with the same name exists, or specified file cannot
>>> be opened, or it is located on UNC share.
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)