Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: InstallShield LE & SQL Scripts

04 Jun 2017   #1
lehnerus2000

W7 Ultimate SP1, LM18.2 MATE, W10 Home, #All 64 bit
 
 
InstallShield LE & SQL Scripts

I'm supposed to create an installer for a program for my TAFE course.
The program needs a DB to work.

I got the short straw and drew the junky InstallSheld LE.

Other students got the even worse ClickOnce (it has failed to create an installer every time I've tried it).

Only the guys who got to use WIX, got a proper tool (and instructions).

I cannot find any useful examples of how you include and execute SQL scripts (to generate a new DB with the appropriate tables) in InstallShield LE.

Does anyone know how it's done?


My System SpecsSystem Spec
.
04 Jun 2017   #2
Mellon Head

Win 7 Pro x64/Win 10 Pro x64 dual boot
 
 

I just had a quick look at this, so I'm not 100% sure, but there might be something you can use:

Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script
My System SpecsSystem Spec
04 Jun 2017   #3
lehnerus2000

W7 Ultimate SP1, LM18.2 MATE, W10 Home, #All 64 bit
 
 

Quote   Quote: Originally Posted by Mellon Head View Post
I just had a quick look at this, so I'm not 100% sure, but there might be something you can use:

Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script
Hi Mellon Head, thanks for looking into this.

I've seen that page before but it must be referring to a different product.

InstallShield LE adds itself to Visual Studio (it gives you a wizard style tool).
None of the options mentioned exist in IS LE (e.g. View List, Behavior and Logic, Property Manager, Runtime tab, etc.).

It seems that you have to use Custom Actions and some sort of VB script, which I've downloaded from MS, but I couldn't find any examples of how it's supposed to be used.

I tried including it in my project, hoping it would trigger some errors, but the installer I created didn't throw any errors.
My System SpecsSystem Spec
.

05 Jun 2017   #4
lehnerus2000

W7 Ultimate SP1, LM18.2 MATE, W10 Home, #All 64 bit
 
 
Too Difficult

It must actually be impossible.
Comments on the various forums all suggest that you should use WIX.

My lecturer just told me to forget about trying to create a DB for the program using InstallShield.
My System SpecsSystem Spec
07 Jun 2017   #5
Mellon Head

Win 7 Pro x64/Win 10 Pro x64 dual boot
 
 

Quote   Quote: Originally Posted by lehnerus2000 View Post
It must actually be impossible.
Comments on the various forums all suggest that you should use WIX.

My lecturer just told me to forget about trying to create a DB for the program using InstallShield.
Probably a good thing. Installshield is one messed up suite of utilities.

Sorry I couldn't help more.
My System SpecsSystem Spec
08 Jun 2017   #6
lehnerus2000

W7 Ultimate SP1, LM18.2 MATE, W10 Home, #All 64 bit
 
 
Thanks Mellon Head

Quote   Quote: Originally Posted by Mellon Head View Post
Probably a good thing. Installshield is one messed up suite of utilities.

Sorry I couldn't help more.
It's not your fault.

It's very easy to create a basic program installer using InstallShield LE, easier than WIX or ClickOnce.

Apparently the point of the exercise was to prove that WIX is the best.
WIX should be the easiest as it uses old school XML, but finding useful file structure information proved very difficult.

I can't Rep you, but thanks for trying.
My System SpecsSystem Spec
Reply

 InstallShield LE & SQL Scripts




Thread Tools




Similar help and support threads
Thread Forum
Problem with Installshield
Hey guys I dont even know how this happened. I was able to install GTA San Andreas on Windows 7, then I thought of uninstalling it but an error appeared and it looks like this: An error (-5011 : 0x8000ffff) has occurred while running the setup. Please make sure you have finished and...
Software
Installshield remnant
Since removing some software a few days back, this irritating Installshield ghost screen appears in the middle of my screen whenever I boot from cold. It is active in the sense that even though the text is missing a mouse click on the ghost CLOSE button gets rid of it. I have tried JV16 tools to...
BSOD Help and Support
Empty InstallShield window
From time to time an empty InstallShield window pops up on my computer with the only things visible on it being an icon on the left, an empty button and the text InstallShield right above that (see first part of the image). When I click the button it'll sometimes close down to the task-bar and...
BSOD Help and Support
Installshield Installation Information
Hi, I noticed recently in my Program Files folder that there is a hidden folder named 'Installshield Installation Information'. It is taking around 100mb and contains folders in this format: eg. {4FC670EB-5F02-4B07-90DB-022B86BFEFD0}. Is it safe to delete it or should I just leave it alone? ...
Performance & Maintenance
InstallShield Needed At Startup?
Hey all, I was just going through my Startup's via msconfig when I noticed InstallShield listed there. Is it necessary to have it startup with Win 7? I am just a stickler for what gets loaded at startup. :)
Installation & Setup


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:48.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App