I downloaded and installed MSDE2000A. I ran the setup and created a
default instance and a named instance. How do I issue commands like
"Create Table", etc?
I am quite familiar with databases, SQL, stored procedures, etc. but I
have been "dead in the water" for a day trying to talk to MSDE! Where
is the interface/command interpreter? Do I go into DOS and run the
.exe programs there?

If you have used this yourself, you should be able to help right away
with little time spent. I am not asking for a lot of research. I have
not been able to find anything that has helped me and don't want more
searching. I want a quick example from someone who has already done
it.



http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/ReadmeMSDE2000A.htm
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en


I plan to create a database similar to an existing one in Access 2000
and copy the data over with a VB.Net program. I already have VB.Net
working w Access. I will need to open the new MSDE database and insert
rows in structures built from command line files like the above
"Create Table". Can you provide any advice to avoid losing more time?
I will need to open the new db from vb.net with a password, just as I
am already doing with the Access db.

Documentation, in my opinion, for the desktop engine is pretty sparse.
 If you're using the Microsoft Visual Studio .NET, you can simply
"connect" to your desktop database by creating a new data connection
through the server explorer.

Or if you're using Microsoft SQL Server's Enterprise Manager, you can
make a similar connection to your desktop database.

In both instances, you're looking for a database server with the following name:

 - [COMPUTERNAME]\NetSDK

Otherwise you would have to programmically access your desktop
database.  Once you're connected to your desktop database (with either
of the previously mentioned tool), you can easily perform any of the
functions you've mentioned.

mcho
http://www.messagingreminder.com/