Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

How to run a setup dyanamically through VB

Sir,
  I have a Database programme in VB and SQLServer as back end.I want to use  MSDE(Microsoft Desktop Engine) instead of SqlServer.
I want to install this MSDE setup through VB Programme

Currently i am installing this MSDE manualy ie,go to command prompt and go to the setup path (C: or )execute some instuctions such as

setup INSTANCENAME="MSDE04" SECURITYMODE=SQL SAPWD="sa"  DISABLENETWORKPROTOCOLS=0

I want to do this in VB programme dynamically.
using shell or something like that...creating a .bat file or...

that is when the programme run ask for the path  of the setup then run this set up.after that ask for restrating the computer.then finally store the Database in this MSDE.

Hoping to reply soon
regards
  Nais
0
Nais81
Asked:
Nais81
2 Solutions
 
anvCommented:
try this ..

PathName = "C:\MSDE"
Shell  PathNAme & " setup INSTANCENAME=MSDE04 SECURITYMODE=SQL SAPWD=sa  DISABLENETWORKPROTOCOLS=0 "
0
 
Arno KosterCommented:
better use the following syntax :

pathname = "C:\MSDE"
filename = "setup.exe"
arguments = "INSTANCENAME=MSDE04 SECURITYMODE=SQL SAPWD=sa  DISABLENETWORKPROTOCOLS=0 "

shell pathname & "\" & filename & " " & arguments
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now