MSDE Pubs

[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

 

[Cor]

Hi Randy,

I thought, so don't blame me when I am wrong, that when you intstall the Net
SDK pubs will be automaticly intstalled.

Here you can find the version 1.1
http://www.microsoft.com/downloads/...A6-3647-4070-9F41-A333C6B9181D&displaylang=en


Cor

 

[Ken Tucker [MVP]]

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

 

[Randy]

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.

 

[Jody Fisher]

You will need to be in the "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\ directory first

Cheers

Jody

 

[Guest]

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