I have succsessfuly downloaded MSCDEX (which I guess is a kind of
lightweight version of SQL SERVER 2000). It doesn't have much of GUI.
I have Windows XP peronal edition.
I have book I called ASP.NET UNLEASED" by
Stephan Walther.
This is the code that I am trying to run.
conPubs = New
SqlConnection("Server=MITCH1\MITCHSSQL;uid=sa;pwd= darth.vader;database=pubs1").
It tells me that "sa" not trusted user. (I changed my user name to sa,
because the documentatin sat the you needed to be. The password password
from the account remains the same, and it was the password I used
in an install.bat that I used.
This is the code in the authors source:
conPubs = New SqlConnection(
"Server=localhost;uid=sa;pwd=secret;database=p ubs" )
It gives me a data base not found error or not have a right to the database.
Interestingly, a tool that I found in my book called "ASP.NET Web Matrix"
will let me create databases, tables and columns, but it won't let me conect
from the VB.NET code.
