Msde

[mrdutchie]

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 don't 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 don't have that.

Where to get the download version, since it's free (according

to the other posts in this forum)

 

Thanks so much

[PlausiblyDamp]

http://go.microsoft.com/fwlink/?linkid=13962

[mrdutchie]

Thanks.....

I'm downloading the 70Mb :cool:

[mrdutchie]

Well, installed it and rebooted it, but

 

not I am trying to do the example from the MS site, but doesn't work.

When I look in my systray I have the sqlicoon and tried to select

(local) but that doesn't work.

 

for Access2000 i am doing the northwind database, but

it's asking for username password....

well.... I don't know what??

 

I gave a password during install MSDE... but what is that username?

[mutant]

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.

[mrdutchie]

Well, that didn't work either :(

 

can you use MSDE with NO SQL server at all?

Cause I don't have a SQL server.

[mutant]

Yes, you can use it without MSSQL server. Its a stand alone, scaled down version of MSSQL Server.

[mrdutchie]

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 that's part is still

not working.

 

I am using the integrated sec. cause other then that won't work.

Now I created some tables within VB.NET / Server Explorer..

now let's see how I can show that within VB.NEt