Hello all.
First thing to say is that I'm an Extreme Newbie(tm) when it comes to Wix, so please be gentle! *anxious smile* Okay, what I'm trying to do is to create a SQL analysis services DB as part of the installation. I've managed to add some GUI which sets the value of some properties that store the name of the server (we assume for the moment that the server has analysis services installed) and the name of the database that we're going to create. The GUI also captures the server, db, user and password for the SQL database that the analysis services DB is based on. My automated build process creates a .xmla script file which (I hope) can be used to construct the database (which includes some dimensions and a cube), but it will need to have the connection string for the SQL database configured dynamically as part of the install. I've a few months of C# experience, but no experience at all with C++ or VBScript, so I would prefer to avoid writing a C++ DLL or some VBScript to handle this. (As I said above, I'm VERY new to Wix). Now, Microsoft distributes a utility called ascmd which (I think) can be used to execute a .xmla script against the server to create the AS database. My first thought therefore was that I could use a Wix CustomAction to run ascmd with the .xmla script. (Does this seem reasonable?) I can't, however, work out a comfortable way of doing this. I could perhaps install ascmd and the .xmla file to the Windows temp folder. I could then modify the .xmla file dynamically to include the correct connection string and then delete them at the end of the install. I can get most of that working, but not the eventual deletion. In any case, this would presumably mess things up on the uninstall, as files that had been a part of the install would no longer be there...? I know that there is supposed to be a way to bundle files into the Wix installation package that are not actually installed, but I can't figure out how to do that, either. (I know it's something to do with a <Binary> tag, but the correct syntax and location to include it elude me). And, if I do somehow manage to bundle (but not install) the files, how do I dynamically change the connection string property in the .xmla file? And how do I then launch ascmd correctly/ Any suggestions would be welcome! Rgds, Nicolas. This e-mail is intended only for the person to whom it is addressed. It may contain confidential information and/or privileged material. If you receive this in error, please notify the sender immediately and delete the information from your computer; please do not copy or use it for any purpose nor disclose its contents to any other person. ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
