SelectDbDlg DB instance

Jun 21, 2011 at 12:03 AM
Edited Jun 21, 2011 at 12:03 AM

In the SelectDbDlg there is a property for the database name "DATABASE_SERVER", does this include the instance (if there is one) and if it does how could I separate it out in order to use the sqldatabase extension


  <sql:SqlDatabase Id="SqlDatabase" Database="[DATABASE_NAME]" DropOnInstall="no" DropOnReinstall="no" DropOnUninstall="no" CreateOnInstall="yes" ConfirmOverwrite="yes"  Server="[DATABASE_SERVER]" Instance=[?????]  />

I assume this call will fail because the server would also include the instance name

Jun 22, 2011 at 11:36 PM

I don't think there's code to do this. You can use the MSIExt extension to create the database as well.

Jun 22, 2011 at 11:41 PM

sorry where is that one I found

But that seems to be about creating a connection string i think.

Jun 22, 2011 at 11:50 PM

Look at the extensions. MSSQLDatabase is what you want, There're samples in the download that use those.