Re: Which Method to Create a Database Do I Use?

The DBO you're seeing in the server explorer is the database "owner"
designation. This permits the server to tie the identity of the object (the
database in this case) to a specific user/login account.
I've written a number of whitepapers on connecting that can be found on my
blog. I also devote an entire chapter to the subject in my book. Yes, it can
be very frustrating until you get a feel for how things work. Lots of folks
have figured it out, even old guys like me... ;)

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:uxKoO0vqHHA.3372@xxxxxxxxxxxxxxxxxxxxxxx
Bill,

I don't know why this is so infuriatingly difficult. I would say I get a
successful database connection maybe one out of every hundred attempts.
And the messages are virtually useless.

Here's the current:

{"Cannot open database \"BlackBelt\" requested by the login. The login
failed.\r\nLogin failed for user 'Jonathan-PC\\Jonathan'."}

I don't know how much hair I can withstand pulling out before this starts
making a bit of sense to me.

Thanks.

(Also, I noticed that, when I create a database via the Server Explorer,
it appears to create a DBO file instead of an MDF file. There seems to be
other differences as well. I've been programming for a hundred years
(almost) but feel completely useless right now.)

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com


"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxx> wrote in message
news:%23UKpvJvqHHA.4624@xxxxxxxxxxxxxxxxxxxxxxx
Either method is acceptable. They both create a database .mdf file that
can be populated with appropriate schema. As a matter of fact, there are
probably a half-dozen ways to create a database and populate it with
schema. The fact that you're going to use it in an ASP project suggests
that the SQL Server engine be located on another system in a heavily used
production application, but for most other installations it does not make
much difference.

I discuss how to decide in depth in my book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:%23iHid8uqHHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
It appears there are two methods for creating a database as part of an
ASP project.

I can use the Server Explorer and create a database that I can't easily
see as a file, and create a connection. On the other hand, I can right
click in the Solution Explorer window and select Add New Item, and then
create an SQL Database. This creates an MDF file directly.

I'm having trouble getting up to speed on the database stuff and have
two seemingly unrelated ways to create my database makes it all the more
confusing.

Can anyone explain the difference between these two methods, and then
help me understand which is the best method for creating a database to
be used by my Web page?

Thanks!

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com






.

Relevant Pages
Loading