PDA

View Full Version : Get SQL Connections list problem.



MichelD
06-19-2013, 09:50 AM
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?

hidenori
06-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!

akashcpatel
07-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?

hidenori
07-31-2013, 10:36 AM
You need to update the same files under the C:\Program Files\InstallShield\2013 SAB folder.