MSDE Pubs

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Can anyone tell me how to get Pubs into VB.net without
installing SQL server? I have installed MSDE but Pubs is
not there when I try to connect to an SQL server in
VB.net. According to Visual Studio Walkthrough book that
came with it it should be there if MSDE is installed.

Thanks
Randy
 
Hi,

In the C:\Program Files\Microsoft Visual Studio .NET
2003\SDK\v1.1\Samples\Setup directory is the instpubs.sql script. From the
command line in that directory try this.

isql /Usa /Psapassword /Sserver -i\instpubs.sql

replace sapassword with your sa password. blank by default (should change
if it is)

replace server with the msde server name it should be your machine
name\VSdotNet

Ken
 
Thanks for responding,

The file was not where you said, I found it in the
following directory and ran it thusly.

C:\Program Files\Microsoft Visual
studio .NET\FrameworkSDK\Samples\Setup\isql /Usa /mupojama
/home -i\instpubs.sql

and got the following message.

'isql' is not recognized as an internal or external
command, operable program or batch file.

It didnt work. Help?
By the way I am running Windows 2000 Professional and have
Visual Studio 2003 installed.
 
You will need to be in the "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\ directory first

Cheers

Jody
 
I tried it from that directory and still got the same
message.... 'isql' is not recognized as an internal or
external command, operable program or batch file.

?????
Randy
 
Back
Top