I recently purchased the ASP.net databases using vb.net and I have a few issues.
 When installing the MSDE (ch. 1 pg 28) I get the error “A strong SA password is required for Security reasons, Use SAPWD switch to supply the same". I have SQL server 2000 installed on the machine. Is this why i get the error?
Since I couldn’t connect to the MSDE I went on to the Access connection example. I've followed the instructions to a 't', but when I go to http://localhost/begaspnetdb/ch03/ac...onnection.aspx all I get is the HTML, no data from the Northwind.mdb.
So I went on to the Excel project..same thing..no data..only the text in the [h3] tags.
It also states on page 69 to "consult online documentation for the SQLconnection objects constructor". Where is this located? Id love to get into the SQL server for the data.
With all of these pages I’m not getting any server errors, just no data.
Also, why is Northwind.mdb suddenly referred to as nwind.mdb on pg 72 and subsequent pages?
thanks,
joe


Joe Dorenbos
[email protected]

No, I don't think that is why you get that error. You get that error because using an SA account without a SA password is very insecure.

Look at the readme for the MSDE. I usually don't read readme documents to well, but for the MSDE it's pretty necessary.

You can use this command line for setup without a string SA password:

Setup BLANKSAPWD=1 INSTANCENAME=YourInstanceName

Alternatively, and preferred, you can supply a password for the SA account.


Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.