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.s ql" file which seemed to work but I
still cant find a database file.

[Jody Fisher]

Re: Using Pubs SQL Database

try creating a new connection - sqlconnection(" server=localhos t;
username=sa;dat abase=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_SCH EMA.TABLES view to get a list of
available table if required
(ie "select * from INFORMATION_SCH EMA.TABLES")


Cheers

Jody

"anon" <anonymous@disc ussions.microso ft.com> wrote in message
news:059101c39c 5f$5c979510$a10 1280a@phx.gbl.. .[color=blue]
> 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.s ql" file which seemed to work but I
> still cant find a database file.[/color]