Using Pubs SQL Database

  • Thread starter Thread starter anon
  • Start date Start date
A

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.
 
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
 
Back
Top