This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: Run SQL Script missing in my IA 2008 Enterprise VP1 download
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 18, 2008
10:02 PM
Run SQL Script missing in my IA 2008 Enterprise VP1 download
Hi,
I have installed IA 2008 VP1(Enterprise). From documentation I understand that IA 2008 Enterprise has Run SQL action. However in my actions list I see
....
Move Folder Action
Set System Environment Variable
However I do not see Run SQL action.
What's the mystery?
Regards, Ravi
I have installed IA 2008 VP1(Enterprise). From documentation I understand that IA 2008 Enterprise has Run SQL action. However in my actions list I see
....
Move Folder Action
Set System Environment Variable
However I do not see Run SQL action.
What's the mystery?
Regards, Ravi
(5) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 18, 2008
10:43 PM
Good. This is real life. You try for hours to find the solution, write to the forums and then next minute (ok 10 minutes) I figure out how to do.
Anyway, here is the trick (yes its tricky and not straightforward)
- To "see" Run SQL action we need to
1/ go to Organization/Hosts, Click Add Host and add Database Server
2/ Now in Install you should see the select Database Server
3/ Click on it and select Actions; You will see only 1 action - "Run SQL Script"
Cool! But very kinky way to reach it.
Regards, Ravi
Anyway, here is the trick (yes its tricky and not straightforward)
- To "see" Run SQL action we need to
1/ go to Organization/Hosts, Click Add Host and add Database Server
2/ Now in Install you should see the select Database Server
3/ Click on it and select Actions; You will see only 1 action - "Run SQL Script"
Cool! But very kinky way to reach it.
Regards, Ravi
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 19, 2008
05:03 AM
Thanks for the guide.
I have a question since you are already on it.
I need to run a SQL script on MSSQL server, I see in Hosts that it is possible to add a MSSQL server but you need to provide credentials(user,password,ect)
so can I put them as IA variables or they need to be hard coded in the installer? cause I'm getting the credentials from the user during installation.
p.s- just to make myself clear- I'm not installing a MSSQL server but my application is communicating with an existing one on the target machine.
the purpose is-when the user enters the credentials during install- I want to connect to the database to see if the credentials are right and if not announce the user
10x
I have a question since you are already on it.
I need to run a SQL script on MSSQL server, I see in Hosts that it is possible to add a MSSQL server but you need to provide credentials(user,password,ect)
so can I put them as IA variables or they need to be hard coded in the installer? cause I'm getting the credentials from the user during installation.
p.s- just to make myself clear- I'm not installing a MSSQL server but my application is communicating with an existing one on the target machine.
the purpose is-when the user enters the credentials during install- I want to connect to the database to see if the credentials are right and if not announce the user
10x
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 23, 2008
05:38 AM
1. Using this functionality can I create new database ???
2. Can i specify the credentials (username, password, port, etc) from the user input (so that i can use the IA variables instead of username, password) ???
If it is so it would be very useful..
And is there any other support for Database Operations in IA 2008 ??
2. Can i specify the credentials (username, password, port, etc) from the user input (so that i can use the IA variables instead of username, password) ???
If it is so it would be very useful..
And is there any other support for Database Operations in IA 2008 ??
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 23, 2008
06:04 AM
I'm sorry but I didn't understand your answer
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 23, 2008
06:47 AM
sorry that was a question 😛
i have edited it .. hope it makes sense .
i have edited it .. hope it makes sense .
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)