Msde

M

mrdutchie

Well-known member
Joined
Jul 7, 2003
Messages
78
Location
WI, USA
I have VB.NET 2003 Architect and want to start using MSDE
cause you can distibute that with you application.
Now I know that this comes with SQL2000 Standard Edition, but I dont have that one.

In VB.NET In the server Explorer, my PC is in it but no SQL server.
so how can I create a SQL Database then?
I heard it is possible with MSDE but I dont have that.
Where to get the download version, since its free (according
to the other posts in this forum)

Thanks so much
 
Well, installed it and rebooted it, but

not I am trying to do the example from the MS site, but doesnt work.
When I look in my systray I have the sqlicoon and tried to select
(local) but that doesnt work.

for Access2000 i am doing the northwind database, but
its asking for username password....
well.... I dont know what??

I gave a password during install MSDE... but what is that username?
 
I think Windows Authentication is better for testing, it saves you some time entering the username and password :). Im not really sure about MSDE but MSSQL server creates an account named "sa" for a dafault account, so you might want to try that.
 
hmm think I got that part to work... not sure.

I need to have VS.NET 2003 open so I can see the SQL server
then I can use the sql-icon in the systray
using \\dutchie\VBDOTNET

Also I can past that screen from Access 2000 and I add all the tables that I want to convert... a few minutes later
it failed with every table from that database. So thats part is still
not working.

I am using the integrated sec. cause other then that wont work.
Now I created some tables within VB.NET / Server Explorer..
now lets see how I can show that within VB.NEt
 
Back
Top