PDA

View Full Version : SQLLogin garbage instance names



THintz
08-07-2013, 08:01 AM
If there is a second instance name in the registry it is displayed in the SQLLogin dialog as garbage. Project is built using 2013 SAB only. Project is a basic MSI upgraded from 2012Spring. Some prerequisites and redist files were copied from the old 2012 folders, but nothing overwritten. Is this a bug or a corrupted installation? Here is an install log example from a 64-bit target machine.

MSI (c) (18:90) [15:32:31:101]: Invoking remote custom action. DLL: C:\Users\qatest\AppData\Local\Temp\MSICB33.tmp, Entrypoint: ISSQLServerFilteredList
1: CSQLServerList::DoSQLServerList() begins.
1: CSQLServerList::DoSQLServerList: Checking if the ComboBox table exists.
1: CSQLServerList::ClearListBoxOrComboBox: Deleting items from the IS_SQLSERVER_SERVER ComboBox.
MSI (c) (18!E4) [15:32:31:647]: Note: 1: 2262 2: ComboBox 3: -2147287038
1: CSQLServerList::DoSQLServerList: Loading database server metadata from the ISSQLDBMetaData table.
1: CSQLServerList::DoSQLServerList: Loading ODBC APIs from ODBC32.dll.
1: CSQLServerList::DoSQLServerList: Retrieving database server names on the network, and registered on the local machine.
1: CSQLServerBrowse::GetServerList() begins.
1: CSQLServerBrowse::GetServerList: Attempting to retrieve server names for Microsoft SQL Server.
1: CSQLServerBrowse::GetServerList: Retrieving local instance names of Microsoft SQL Server from registry.
1: CSQLServerBrowse::GetServerList: Retrieving alias names of Microsoft SQL Server from registry.
1: CSQLServerBrowse::GetServerList: Retrieving server names registered in system DSNs.
1: CSQLServerBrowse::GetServerList: Retrieving server names registered in user DSNs.
1: CSQLServerBrowse::GetServerList() ends.
MSI (c) (18!E4) [15:32:31:725]: PROPERTY CHANGE: Adding IS_SQLSERVER_FILTERED_FLATLIST property. Its value is '(local)\SQLEXPRESSADV,(local)\匀...'.
1: CSQLServerList::PopulateListBoxOrComboBox: Populating the IS_SQLSERVER_SERVER ComboBox.
MSI (c) (18!E4) [15:32:31:725]: Note: 1: 2262 2: ComboBox 3: -2147287038
1: CSQLServerList::DoSQLServerList() ends.
Action ended 15:32:31: ISSQLServerFilteredList. Return value 1.

The registry looks like the picture supplied in the attachment.

10163

hidenori
08-09-2013, 10:28 AM
I confirmed it is a bug introduced in InstallShield 2013 and filed the work order #IOA-000081442. I will post the hotfix to this thread as soon as it is available.

Thank you for your feedback.

hidenori
08-12-2013, 11:32 AM
The attached is the InstallShield 2013 hotfix for the work order #IOA-000081442. 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\redist\Language Independent\i386\ISSQLSrv.dll
C:\Program Files\InstallShield\2013\redist\Language Independent\x64\ISSQLSrv.dll

Regards.

THintz
08-13-2013, 10:43 AM
The patch works. Thank you for the quick turn-around!