Loading
InstallScript - Executing SQL Scripts
Hello, I have written an InstallScript project that executes several SQL scripts. The project works fairly well, but I want to hide the SQL Login dialog box and provide the connection and login information to the SQL Server via InstallScript as most if not all of my users are simply going to be confused by the SQL Login dialog. However, it appears that when I do comment out the display of this dialog, the event for OnSQLBatchScripts never gets fired.

 

Does anyone know if there is a way for me to do what I want to do?

 

Thanks!

  • 0_H Yamanishi (Flexera Software)

    Which code did you comment out? You only need to comment out the following line in the OnSQLServerInitialize() event in order to suppress the SQLLogin dialog.

     

    nResult = SQLServerSelectLogin2( szConnection, szServer, szUser, szPassword, bWinLogin, szDB, FALSE, TRUE );
  • Thanks, I tried it what you suggested and it worked like a charm!

     

    Tim

Loading
InstallScript - Executing SQL Scripts