I'm trying to install MSDE so that I can experiment with communicating with
a database using .NET. I ran setup.exe in the ...Visual Studio\Setup\MSDE
directory, then executed the command "NET START MSSQL$VSdotNET", which
seems to have started the SQL server; the service "MSSQL$VSdotNET is
running and is set to start automatically.
Before I can communicate with a database, I presumably need to create one
and give it a schema. I have no idea how to do this.
http://msdn.microsoft.com/vstudio/downloads/addins/msde/databases.asp
suggests that I use SQL Server Developer edition, and it says that "Visual
Studio 6.0 developers have the option of using SQL Server 7.0 Developer
edition, which is included on the MSDE for Visual Studio 6.0 CD-ROM, to
create MSDE databases and database objects." If this also applies to
VS.NET, I can't find it.
I'd really appreciate it if somebody would help me know how to create a
database, give it a schema, and refer to it from inside a C# program so I
can populate it.
Thanks,
Scott
|
