Walkthroughs ... access to SQL Server

[vreemde]

I am sort of a newbee in Visual Basic .NET

In order to complete one of the walkthroughs I need

an access to a server with the Pubs SQL Server sample database.

It comes out then, that I should know the name of the server, the password and the likes. Can anybody tell me where could I get 'em?
Couldn't find in Internet any charities with gratis SQL servers databases.

Will the installation of the evaluation option of the SQL Server on my computer serve the purpose? How could I connect to my database from my own pc then?

Can anyone help me, pleeaase?
Thanking you in advance
Leo

[Edneeis]

You can use MSDE which is on the VS.NET discs. It is a faceless developer version of SQL. It may even install by default, but you'll also need to run this other install package in the Program Files\MS Visual Studio.NET folder somewhere, probably in a Setup or MSDE subfolder. From there you can use it via Access or the Server Explorer in the VS.NEt IDE.

[Jeremy Martin]

The evaluation version should to the trick. One thing that I sometimes find myself doing when I can't remember exactly how to connect to a SQL server and run the query's is to use a SQLDataAdapter, under the data portion of the toolbox. After answering all of the questions you can look through the properties of the DataAdapter you can see what the connection string/query string should be. I usually then just take and copy those strings and then delete the control.

This probably is not the best way of doing it but it beats writing down all of the parts of the strings or trying to remeber what they are.

After doing that you should have a pretty good idea on how to do it without using the control from the toolbox.

Jeremy

[vreemde]

Originally posted by Edneeis
You can use MSDE which is on the VS.NET discs. It is a faceless developer version of SQL. It may even install by default, but you'll also need to run this other install package in the Program Files\MS Visual Studio.NET folder somewhere, probably in a Setup or MSDE subfolder. From there you can use it via Access or the Server Explorer in the VS.NEt IDE.

................................................................

Thanks a lot for a useful hint

Leo

[vreemde]

Originally posted by Jeremy Martin
The evaluation version should to the trick. One thing that I sometimes find myself doing when I can't remember exactly how to connect to a SQL server and run the query's is to use a SQLDataAdapter, under the data portion of the toolbox. After answering all of the questions you can look through the properties of the DataAdapter you can see what the connection string/query string should be. I usually then just take and copy those strings and then delete the control.

This probably is not the best way of doing it but it beats writing down all of the parts of the strings or trying to remeber what they are.

After doing that you should have a pretty good idea on how to do it without using the control from the toolbox.

Jeremy

Thank you for a prompt advice
"A friend in need is a friend indeed"

Leo