473,320 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Shell MSDE setup problem

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
5 2107
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
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

"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David Lee | last post by:
Need some help bad here. Am using VB.Net Standard 2003 supplied for a class and I need to install Msde and the sample databases to work on homework. Following the documentation I can download...
5
by: João Portela | last post by:
As i try to install MSDE (Microsoft SQL Server Desktop Engine), i get this error message : "A strong SA password is required for security reasons. Please use SAPWD switch to suply the same. Setup...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
1
by: Markus Graf | last post by:
Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client...
1
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve...
1
by: hplloyd | last post by:
I want to include MSDE 2000 as part of my setup project for a VB.NET app from withing VS.NET 2003. I am having trouble finding out how to do this in terms of changing the settings re...
2
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
3
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together...
1
by: kaushalgajjar | last post by:
I have been struggling to build a package in VS2005. I have an application made in VB.Net with SQL 2000 now i want to build it to use in a stand alone Computer so i have found MSDE from Microsoft...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.