cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eriendeau
Level 3

No See SQL Scripts on Server Configuration

Hi,
I need to make a SQL Connection in my InstallShield setup and in the HLP his talking about to add a SQL Scripts in Server Configuration and I don't see it on this panel. I created a MSI Database install.

Somebody can help me.

Thanks

Eric RIendeau
eric.riendeau@medisolution.com
Senior Programs Developper
Labels (1)
0 Kudos
(4) Replies
klacounte
Level 6

This should help:

0 Kudos
hidenori
Level 17

The SQL Scripts view is currently avaiable for Basic MSI, InstallScript MSI and InstalScript projects.
0 Kudos
eriendeau
Level 3

Thanks to everybody

I found it and now I'm able to run a script sucessfully but is possible to see the result of this script. Like evaluate a field value returned by a select? Or you can only run a no result script?

I.E: Select name, first_name frm client and i want to see the name in a dialog.



Eric Riendeau
0 Kudos
hidenori
Level 17

Unfortunately, the built-in SQL feature currently does not have the ability to allow you handle the results from SQL queries. You need to write your own code to manage database connections and run SQL statements. There are some sample codes available in this community forum:

http://community.macrovision.com/showthread.php?t=165473
http://community.macrovision.com/showthread.php?t=152884

Hope that helps.
0 Kudos