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/d...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" <rj*****@sbcglobal.net> wrote in message
news:04****************************@phx.gbl...

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

[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.

-----Original Message-----
Hi,

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

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

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

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

Ken
--------------------------------
"Randy" <rj*****@sbcglobal.net> wrote in message
news:04****************************@phx.gbl...

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

.

[Jody Fisher]

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

Cheers

Jody

"Randy" <rj*****@cox.net> wrote in message
news:02****************************@phx.gbl...

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.

-----Original Message-----
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" <rj*****@sbcglobal.net> wrote in message
news:04****************************@phx.gbl...

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

.

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

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

Cheers

Jody

"Randy" <rj*****@cox.net> wrote in message
news:02****************************@phx.gbl...

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.

>-----Original Message-----
>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" <rj*****@sbcglobal.net> wrote in message
>news:04****************************@phx.gbl...
>> 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
>>
>
>
>.
>

.