Re: What's My Password?

William,

Ok, then you have other issues to consider.
1) When using any instance of SQL Server you can access it via the network
(via netlibs like TCP/IP or named pipes) and a NIC or you can access it
via the (default) Shared Memory provider. This second option does not
require going through the NIC. This is the default for SQL Express as it's
initially intended to be accessed from the client system.

I just don't really know what that means. For testing, I will want to use
the database on my computer. After deployment, I'll want to copy the
database to the computer that hosts my Web site, and my Web site will use
the database on that same computer.

2) Yes, you can access a SQL Express instance from a hosted ISP, but this
assumes the ISP will let you install it. Some won't--thus the need for
alternative DBMS engines that they don't have to manage. Yes, management
is a serious issue. It includes backups, log truncation, security and
more.

The company that hosts my Web sites has the ASP.NET 2.0 frameworks
installed. My understanding is that includes a database engine. Why would I
want to install a different one?

3) The MacDonald book is a good one. My daughter Fred edited it (or an
earlier version) and I use it as my ASP.NET reference. It is a must-read
for ASP developers. My book is predominantly for Visual Studio/SQL Server
developers as it discusses issues that all architectures are likely to see
but it only uses Windows Forms examples. That's because too many
developers think they need ASP when they don't--not really and the
concepts apply across the board.

Yeah, I actually have two of his books (Pro and Beginning). They are big
books and I really have spent very limited time with them.

I'm extremely busy with other projects and I absolutely must get up and
running with .NET and databases before I will be in a position to read all
the stuff I have. It's a very difficult position. I guess I was optimistic
that I'd be able to get to the point where I could open my database from
code without reading all these books. Perhaps I was wrong.

4) When you build a ConnectionString, it's not enough to simply reference
the local system, you have to reference the specific named instance of SQL
Server. That's because there could be a dozen instances hosted on the
system. A correct connection string (in your case) could look like this:

"Server=local\SQLEXPRESS;integrated security=SSPI;initial
Catalog=BlackBeltCoder"

Note that I used "local", not "localhost" which is used in a URL. You can
also use "." as in ".\SQLEXPRESS" as well to refer to the local system
(whatever its name is). Don't be confused by the (unfortunate) exception
message you get back from ADO.NET. It has lead many developers astray.

I was just copying some of the many examples in MacDonald's Pro book.

Okay, here's what I got:

string connString = "Server=local\\SQLEXPRESS;integrated
security=SSPI;initial Catalog=BlackBeltCoder";

That gives me an error. However:

string connString = "Server=localhost\\SQLEXPRESS;integrated
security=SSPI;initial Catalog=BlackBeltCoder";

This actually works! With some additional messing around, I also found the
following works!

string connString = "Data Source=<sysname>\\SQLExpress;Initial
Catalog=BlackBeltCoder;Integrated Security=True";

Where <sysname> is the name for my system.

So I'm not sure I followed your comment about local vs. localhost, but only
localhost works for me.

At any rate, if I can find your book, I'll take a look. If you can explain
the above, I'm all ears.

I'm now able to continue development on this project because I can actually
connect to a database. However, I still don't understand why, the best way
to create the database, or what I'll need to change when I move it to my Web
site. But one thing at a time.

Thanks.

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


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
Loading