Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 2

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?
Labels (1)
0 Kudos
(3) Replies
Level 17

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!
0 Kudos
Level 3

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?
0 Kudos
Level 17

You need to update the same files under the C:\Program Files\InstallShield\2013 SAB folder.
0 Kudos