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
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Troubles about SQL scripts
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
‎Sep 12, 2007
01:40 PM
Troubles about SQL scripts
I'm using IS 2008 Professional v14 with Lic. Hotfix.
When using the SQL scripts explorer I found some troubles. I have 2 SQL connections in the explorer view, and each one has a script inside.
1) NewSQLConnection1
- newscript1.sql
2) NewSQLConnection2
- newscript2.sql
I click the NewSQLConnection1 and in the General tab I set the field Default Target Server Name (optional) to "TESTSQLSERVER"
Then I click the NewSQLConnection2 and in the General tab I found in the Catalog Name field the same value I set previously in the Default Target Server Name for NewSQLConnection1. So Catalog Name is set to "TESTSQLSERVER" too.
In particular, if I try to change the Catalog Name for NewSQLConnection2, that value is then copied to the Default Target Server Name for NewSQLConnection1.
To be honest I really do not understand this behaviour. It's like the two fields are exchanging their values!
Please can you tell me what's the trouble?
I was looking at the chapter "Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script" discussed here:
http://helpnet.installshield.com/Robo/BIN/Robo.dll?mgr=agm&tpc=%2Frobo%2Fprojects%2Finstallshield14helplib%2FSQLServer.htm&wnd=InstallShieldLivingHelp%7CMain&agt=wsm&ctxid=showthread.php
Even the example provided by the IS2008 guide in that chapter is not working because the strange behaviour I described above.
When using the SQL scripts explorer I found some troubles. I have 2 SQL connections in the explorer view, and each one has a script inside.
1) NewSQLConnection1
- newscript1.sql
2) NewSQLConnection2
- newscript2.sql
I click the NewSQLConnection1 and in the General tab I set the field Default Target Server Name (optional) to "TESTSQLSERVER"
Then I click the NewSQLConnection2 and in the General tab I found in the Catalog Name field the same value I set previously in the Default Target Server Name for NewSQLConnection1. So Catalog Name is set to "TESTSQLSERVER" too.
In particular, if I try to change the Catalog Name for NewSQLConnection2, that value is then copied to the Default Target Server Name for NewSQLConnection1.
To be honest I really do not understand this behaviour. It's like the two fields are exchanging their values!
Please can you tell me what's the trouble?
I was looking at the chapter "Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script" discussed here:
http://helpnet.installshield.com/Robo/BIN/Robo.dll?mgr=agm&tpc=%2Frobo%2Fprojects%2Finstallshield14helplib%2FSQLServer.htm&wnd=InstallShieldLivingHelp%7CMain&agt=wsm&ctxid=showthread.php
Even the example provided by the IS2008 guide in that chapter is not working because the strange behaviour I described above.
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 12, 2007
02:03 PM
Please check the Windows Installer properties assocaited with the settings of each SQL connection in the Connection | Advanced tab of the SQL Scripts view. I am assuming that you are using a same property for both the Target Server Property Name for NewSQLConnection1, and the Target Catalog Property Name for NewSQLConnection2. Therefore, those values that you entered are shared between those settings.
Hope that helps.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 13, 2007
02:28 AM
OK, solved!
Thanks.
Thanks.