Using Pubs SQL Database

[anon]

I'm trying to work through the tutorial that came with
VS.net. It talks about using the "pubs" database. I
downloaded MSDE 2000 and installed it but I'm not sure
what to do next. Do I need to start the database engine?
Do I need to create an ODBC data source? I did find and
run the "instpubs.sql" file which seemed to work but I
still cant find a database file.

[Jody Fisher]

try creating a new connection - sqlconnection("server=localhost;
username=sa;database=pubs")

and executing a query against it

You will find that you have no user interface for the desktop engine. You
can try querying the INFORMATION_SCHEMA.TABLES view to get a list of
available table if required
(ie "select * from INFORMATION_SCHEMA.TABLES")
Cheers

Jody

"anon" <an*******@discussions.microsoft.com> wrote in message
news:05****************************@phx.gbl...

I'm trying to work through the tutorial that came with
VS.net. It talks about using the "pubs" database. I
downloaded MSDE 2000 and installed it but I'm not sure
what to do next. Do I need to start the database engine?
Do I need to create an ODBC data source? I did find and
run the "instpubs.sql" file which seemed to work but I
still cant find a database file.