Re: What's My Password?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Cor,

We all try to learn on this board, will you next time the name of books
you have used as well.

Are you asking for the name of the books?

Well, the two I have in front of my are:

[Microsoft ADO.NET 2.0 Step by Step (Rebecca M. Riordan, MS Press)]
This book provides step by step instructions on creating my database
connection. It starts by telling me to choose the Add New Data Source from
the Data menu. That's very nice. When I read it, I had no Data menu. After
much messing around, I did get into an area where a Data menu appeared.
Unfortunately, it had no Add New Data Source command.

I managed to get the data window on the left side of the screen and there
were other options but none looked like the dialog in the book. But I
eventually worked through them. Several times, I was asked if I wanted
Windows Authentication or SQL Server Authentication. Well, the book wasn't
much help at all there but since this will be a Web application, I thought I
might want to enter a user name and password under SQL Server
Authentication. Well, that's very nice too but it then told me the user name
and password were not valid. (Perhaps I have to drive to Microsoft to
specify what will or will not be valid passwords in my program.)

At one point I did get a dialog box that looks closer to what is in the book
and the book says the following about the Server Name box:

"In the Server Name box, type (local)SQLEXPRESS. The local portion indicates
the local computer, and the SQLEXPRESS is the SQL Server instance name.
IMPORTANT: This book and code samples have been designed for use with a
default installation of Microsoft SQL Server 2005 Express Edition, which has
an instance name of SQLEXPRESS. If you want to use this book with a
different SQL Server instance name or with the full version of SQL Server,
you will have to adjust the exercise steps and connection strings
accordingly."

Well, that's nice too. Apparently, this books recommendation about the
server name field on the regular version of Visual Studio is TO BUY ANOTHER
BOOK!

[Pro ASP.NET 2.0 in C# 2005 (McDonald/Szpuszta)]
In all fairness, this is a large book and I've spent limited time with it.
But I see nothing in the ADO.NET Fundamentals chapter that tells me what I
need to know. It does offer several different types of connection strings,
which I listed in my original post. None of them work for me. That chapter
then jumps right into writing the code without mentioning how to create a
database from the IDE.

Thank you for informing us that we have to watch this when we buy books
about AdoNet.

Well, after several replies no one here has provided that specific
information either. Obviously, there's a bit of a hurdle to get from where I
am to where I'm writing code to work with a database I have created. And
it's very frustrating as it seems it could've been made far easier.

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


.

Relevant Pages

  • Re: Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... Mixed mode authentication is there for a reason. ... Microsoft strongly recommends Windows authentication for a purely ... I DO NOT DO on SQL Server systems unless necessary. ... security is no place for workarounds and you have to understand that SQL ...
    (microsoft.public.windows.server.sbs)
  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • Re: are ado questions allowed here?
    ... Microsoft re MDAC ... This article describes the past, present, and future of Microsoft data ... * OLE DB (including SQL Server OLE DB Provider, ... will be available on the 64-bit Windows operating system. ...
    (comp.databases.ms-access)
  • Re: Critical Alert Update - W32.Slammer
    ... > It's not clear if SQL Server 2000 SP1/SP2 includes the ... > Microsoft SQL Desktop ... >>most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)