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
- :
- Get SQL Connections list problem.
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
‎Jun 19, 2013
09:50 AM
Get SQL Connections list problem.
I have a IS2012 installation that I converted to a IS2013 installation.
Everything in fine except that, in the OnSQLogin() function in the InstallScript file, the 2 lines:
//Get the names of all the necessary connections
listConnections = SQLRTGetConnections();
ListGetFirstString (listConnections, szConnection);
are returning only "S" in szConnection.
With IS2012 sConnection was returning "SQLConnection" wich is ok.
Is someone as a get around for this?
Everything in fine except that, in the OnSQLogin() function in the InstallScript file, the 2 lines:
//Get the names of all the necessary connections
listConnections = SQLRTGetConnections();
ListGetFirstString (listConnections, szConnection);
are returning only "S" in szConnection.
With IS2012 sConnection was returning "SQLConnection" wich is ok.
Is someone as a get around for this?
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 24, 2013
09:57 AM
We confirmed it is a bug that InstallScript MSI setups built in InstallShield 2013 does not interact with issqlsrv.dll correctly. I filed the work order #IOA-000080073 to track this issue, and attached the InstallShield 2013 hotfix to this post. In order to apply the fix, please replace the following files with the new ones in the attachment, and then rebuild your setup.
C:\Program Files\InstallShield\2013\Script\ISRT\Lib\SQLConv.obl
C:\Program Files\InstallShield\2013\Script\ISRT\Include\SQLConv.h
C:\Program Files\InstallShield\2013\Script\ISWI\Lib\ISWI.obl
Thank you for your feedback!
C:\Program Files\InstallShield\2013\Script\ISRT\Lib\SQLConv.obl
C:\Program Files\InstallShield\2013\Script\ISRT\Include\SQLConv.h
C:\Program Files\InstallShield\2013\Script\ISWI\Lib\ISWI.obl
Thank you for your feedback!
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 31, 2013
10:20 AM
Hi hidenori,
After applying the patch the issue was resolved when I created exe using the Install Shield Release option. But if I create exe using Install Shield Stand alone (us IsCmdBld.exe) I see the same issue.
How can I resolve it?
Is there a separate patch for Install shield stand alone?
After applying the patch the issue was resolved when I created exe using the Install Shield Release option. But if I create exe using Install Shield Stand alone (us IsCmdBld.exe) I see the same issue.
How can I resolve it?
Is there a separate patch for Install shield stand alone?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 31, 2013
10:36 AM
You need to update the same files under the C:\Program Files\InstallShield\2013 SAB folder.