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
- :
- SQLLogin garbage instance names
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
‎Aug 07, 2013
08:01 AM
SQLLogin garbage instance names
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.
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.
![](/legacyfs/online/vb/10163_registry.png)
- Tags:
- sqllogin
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 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.
Thank you for your feedback.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 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.
C:\Program Files\InstallShield\2013\redist\Language Independent\i386\ISSQLSrv.dll
C:\Program Files\InstallShield\2013\redist\Language Independent\x64\ISSQLSrv.dll
Regards.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 13, 2013
10:43 AM
The patch works. Thank you for the quick turn-around!
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)