Creating Installer w/ MSDE: Need to start server for OSQL

• Richard Rice

  SSC Eights!

  Points: 879

  More actions

  November 10, 2004 at 9:43 am

  #84099

  I have an installer package that installs MSDE, MDAC, etc for the client. I also need to run an SQL package to load the database. What I need to do is start the local MSDE so that I can run the following batch file:

  SET SQLPath=%1

  if '%SQLPath%' == '' goto pathnotok

  :pathok

  %SQLPath%\sql\msde\setup.exe

  %SQLPath%\mdac27_typ.exe

  start /wait "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n

  OSQL /E /i %SQLPath%\poller.sql

  OSQL /E /i %SQLPath%\sql_max_mem_size.sql

  :pathnotok

  echo "Usage: nsisqlcltools.bat <sql install path>"

  @echo off

  :endit

  The OSQL will not run after the MSDE installation unless the PC is restarted, which I am trying to avoid. The call to sqlmangr starts the manager but not the database. Is there a better way to start the database or do I need to set other flags to sqlmangr?

  Any help is appreciated.

• November 15, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Patrick Duflot

  SSChasing Mays

  Points: 660

  More actions

  November 18, 2004 at 2:15 am

  #530595

  You can start SQLServer service with SQL DMO as in the following VB code.

  Public Sub StartSQLService(MachineName as String)

  Dim MySqlServer as SQLDMO.SQLServer

  Set MySqlServer = New SQLDMO.SQLServer

  MySqlServer.Start False, MachineName

  End Sub

  Don't forget to add Microsoft SQLDMO object library in the Project-References dialog.

  You could probably achieve the same result in every language supporting COM objects and avoid the distribution of the VB runtime.

  Patrick

   

  Patrick Duflot