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