Northwind Sample database in Amit Kalani's Book

Discussion in 'MCAD' started by Jessica, Feb 12, 2004.

  1. Jessica

    Jessica Guest

    Hey all,

    When I am studying 315, Amit Kalani in his book uses a
    lot the Northwind sample database coming with either MSDE
    alone or SQL Server.

    I installed the SQL Server 2000 Client Components on my
    Windows XP Professional OS, but can't find/use that
    sample database. I am wondering whether it is because I
    can't install the server-side components?

    Is there a way that I can work around to be able to use
    the sample database in my situation? Any suggestions are
    highly appreciated!

    Jessica, Feb 12, 2004
    1. Advertisements

  2. Jessica

    Kumar Reddi Guest

    You sure Northwind database got installed on your computer? I dont remember
    if SQL Server 2000 install north wind when you do the Client Tools
    configuration..You can check it in the server explorer in your Visual Studio
    ..NET IDE.
    If north wind did not get installed, you need to install north wind
    database using OSQL utility. you need to run the sql script file located in
    the following folder, if you installed Visual studio .net to its default
    C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Samples\Setup

    run the "instnwnd.sql" file using the following command

    osql -E -S <ServerName> -i InstNwnd.sql

    Replace the ServerName with your machine name, if you are installing the
    database on SQL Server 2000, or use MachineName\VSDOTNET for MSDE assuming
    VSDOTNET is the instance name of MSDE

    Have fun
    Kumar Reddi, Feb 12, 2004
    1. Advertisements

  3. Jessica

    Guest Guest

    Works now. Thanks a lot! I had been struggling for two
    days, stupid me.

    Guest, Feb 12, 2004
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.