By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,333 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,333 IT Pros & Developers. It's quick & easy.

Shell MSDE setup problem

P: n/a
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few
seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Chris Austin
Nov 21 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi,

Take a look at this toolkit
http://www.microsoft.com/downloads/d...DisplayLang=en

Ken
----------------------------------
"Chris Austin" <c.******@bigfoot.com> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few
seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Chris Austin

Nov 21 '05 #2

P: n/a
Thanks, but I have already looked at this toolkit and decided I couldn't use
it for 2 reasons:

1) I need to give the user the option of selecting either an existing SQL
Server instance (local or remote) or installing a new MSDE instance

2) This is still a release candidate and not usable for public distribution.
I need to supply this setup next week.

So back to the original problem, why does the setup pause when shelled from
an app, but not when called from the command line with exactly the same
parameters.

Chris

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ue**************@TK2MSFTNGP15.phx.gbl...
Hi,

Take a look at this toolkit
http://www.microsoft.com/downloads/d...DisplayLang=en
Ken
----------------------------------
"Chris Austin" <c.******@bigfoot.com> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Chris Austin

Nov 21 '05 #3

P: n/a

"Chris Austin" <c.******@bigfoot.com> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Maybe dumb, but try using Process.Start instead of shell. I know its kinda
stupid because it *should* be doing the exact same thing, but every now and
then you find these little quirks. Shell should start the application out
of process, but it will only return an error level, nothing you can use to
necessarily monitor the application.

IT's just a hunch, but at least something to try. Plus its managed, which
may take care of some of the bs for you.


Chris Austin

Nov 21 '05 #4

P: n/a
How about you shell a file such as msdesetup.bat
and the file would have the following:
start MSDE\Setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL

"Chris Austin" <c.******@bigfoot.com> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Chris Austin

Nov 21 '05 #5

P: n/a
Hi,

http://www.red-gate.com/sql/sql_packager.htm
Ken
-----------------
"Chris Austin" <c.******@bigfoot.com> wrote in message
news:eM**************@TK2MSFTNGP11.phx.gbl...
Thanks, but I have already looked at this toolkit and decided I couldn't use
it for 2 reasons:

1) I need to give the user the option of selecting either an existing SQL
Server instance (local or remote) or installing a new MSDE instance

2) This is still a release candidate and not usable for public distribution.
I need to supply this setup next week.

So back to the original problem, why does the setup pause when shelled from
an app, but not when called from the command line with exactly the same
parameters.

Chris

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ue**************@TK2MSFTNGP15.phx.gbl...
Hi,

Take a look at this toolkit
http://www.microsoft.com/downloads/d...DisplayLang=en
Ken
----------------------------------
"Chris Austin" <c.******@bigfoot.com> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...
I am trying to use the Shell command to run the MSDE setup.

Shell("MSDE\setup.exe SAPWD=blah INSTANCENAME=TEST SECURITYMODE=SQL")
This works in that it runs the setup, but the setup always pauses with a few seconds to go (as far as I can tell just before the MDAC install).

If I then stop my VB.Net app, then the setup continues. Why is this
happening and what can I do to resolve it?

The same command works perfectly from the command prompt, so it seems that
the shell command isn't allowing the shelled app to launch another process
(MDAC install).

Chris Austin


Nov 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.