Request information regarding MSDE

[_AnonCoward]

I have an instance of MSDE on my system (installed with VS I presume)
and I want to start using it. As far as I can tell, there are no tools I
can use so I'm going to have to roll my own. The first thing I want to
do is figure out how to:

* connect to my server
* get a list of databases on that server
* retrieve a database from the server
* add a database to the server
* remove a database from the server

Any suggestions on how to proceed? If another ng is more appropriate for
this, plz advise.

TIA.

Ralf

[Robin Tucker]

Re: Request information regarding MSDE

Yes, try comp.databases. ms-sqlserver. But to answer your questions, in
Visual Studio, if you go to "server explorer", then it is possible to start
setting up and using databases from within the IDE.

"_AnonCowar d" <abc@xyz.com> wrote in message
news:4jkpe.3834 $%h7.588131@twi ster.southeast. rr.com...[color=blue]
>I have an instance of MSDE on my system (installed with VS I presume)
> and I want to start using it. As far as I can tell, there are no tools I
> can use so I'm going to have to roll my own. The first thing I want to
> do is figure out how to:
>
> * connect to my server
> * get a list of databases on that server
> * retrieve a database from the server
> * add a database to the server
> * remove a database from the server
>
> Any suggestions on how to proceed? If another ng is more appropriate for
> this, plz advise.
>
> TIA.
>
> Ralf
>
>[/color]

[Kerry Moorman]

Re: Request information regarding MSDE

Ralf,

You can get started by using Visual Studio's Server Explorer. From the View
menu, choose Server Explorer. You should be able to do the things you listed
in your post from here.

You can also use Access's Upsizing Wizard to convert an Access database to
SQL Server.

Kerry Moorman

"_AnonCowar d" <abc@xyz.com> wrote in message
news:4jkpe.3834 $%h7.588131@twi ster.southeast. rr.com...[color=blue]
>I have an instance of MSDE on my system (installed with VS I presume)
> and I want to start using it. As far as I can tell, there are no tools I
> can use so I'm going to have to roll my own. The first thing I want to
> do is figure out how to:
>
> * connect to my server
> * get a list of databases on that server
> * retrieve a database from the server
> * add a database to the server
> * remove a database from the server
>
> Any suggestions on how to proceed? If another ng is more appropriate for
> this, plz advise.
>
> TIA.
>
> Ralf
>
>[/color]

[_AnonCoward]

Re: Request information regarding MSDE


"Robin Tucker" <idontwanttobes pammedanymore@r eallyidont.com> wrote in
message news:d84lt9$kvp $1$830fa79d@new s.demon.co.uk.. .
: Yes, try comp.databases. ms-sqlserver. But to answer your questions,
in
: Visual Studio, if you go to "server explorer", then it is possible to
start
: setting up and using databases from within the IDE.


Thanx, I'll give that a shot.


Ralf


: "_AnonCowar d" <abc@xyz.com> wrote in message
: news:4jkpe.3834 $%h7.588131@twi ster.southeast. rr.com...
: >I have an instance of MSDE on my system (installed with VS I presume)
: > and I want to start using it. As far as I can tell, there are no
tools I
: > can use so I'm going to have to roll my own. The first thing I want
to
: > do is figure out how to:
: >
: > * connect to my server
: > * get a list of databases on that server
: > * retrieve a database from the server
: > * add a database to the server
: > * remove a database from the server
: >
: > Any suggestions on how to proceed? If another ng is more appropriate
for
: > this, plz advise.
: >
: > TIA.
: >
: > Ralf
: >
: >
:
: