Hi

I am currently reading the book "Beginning Dynamic Websites with ASP.NET Web Matrix" by Dave Sussman.

I am unable to install the sample database by either following the instruction for Step 2 or running the InstallDatabases.bat file manually (Chapter 1). I have installed ASP.NET version 1.1 and the newest version of Web Matrix. I found that the directory listed in the .bat file is different from where the 4 SQL are stored (C:\Program Files\Microsoft.NET\SDK\v1.1\Samples\Setup) but changing that does not resolve the issue. The error message shown in the DOS window are as follows:
=================
D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>cd C:\Program Files\Microsoft.NET\SDK\v1.1\Samples\Setup

D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>osql -E -S (local)\NetSDK -i InstPubs.sql
Cannot open input file - InstPubs.sql
No such file or directory

D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>osql -E -S (local)\NetSDK -i InstNwnd.sql
Cannot open input file - InstNwnd.sql
No such file or directory

D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>osql -E -S (local)\NetSDK -i Portal.sql
Cannot open input file - Portal.sql
No such file or directory

D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>osql -E -S (local)\NetSDK -i Grocer.sql
Cannot open input file - Grocer.sql
No such file or directory

D:\Beginning Dynamic Websites with ASP.NET Web Matrix\Chapter01>pause
=================

Appreciate if you could advise on a course of actions.

Regards,
Stenrique

i have a similiar problem - will not recognise osql command from that batch file???
naomi

Hi, You should enter the full path of the instnwnd.sql etc.
Cheers
Kay

I love Arsenal!

             This is how I downloaded the sample database:
1. goto
http://www.microsoft.com/downloads/d...displaylang=en
2. download file SQL2000SampleDb.msi
3. run it - you'll get seven files , one of them - ReadMe_SQL2000SampleDbS...
4. follow the instructions

be aware that I downloaded Web Matrix and MSDE2000 from www.microsoft.com
not from CD , and they are different versions (look at my post about it)
Michael