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
- :
- Re: What Property has List of SQL Server Databases
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
Feb 19, 2011
11:14 AM
What Property has List of SQL Server Databases
I want to get a list of Sql Server Databases on a Server without going through the SQLBrowse Dialog. This is what I tried...
On the SqlLogin Dialog Next Button
Set [IS_SQL_DB_BROWSE] to 1
Set [IS_SQL_SERVER_BROWSE] to 0
Set [IS_SQLBROWSE_INTRO] to [IS_SQLBROWSE_INTRO_DB]
DoAction ISSQLQueryDatabases
DoAction ESNA_DB_IN_USE
From the ESNA_DB_IN_USE I have an installScript to get the DB LIST.
I get the IS_SQLSERVER_LIST property using MsiGetProperty (hMSI,"IS_SQLSERVER_LIST",szDBList,nDBList);
The szDBList is empty. Why doesn't the IS_SQLSERVER_LIST contain the list of DBs?
Can someone please tell me what I am doing wrong? Is there another property with the list of DBs?
On the SqlLogin Dialog Next Button
Set [IS_SQL_DB_BROWSE] to 1
Set [IS_SQL_SERVER_BROWSE] to 0
Set [IS_SQLBROWSE_INTRO] to [IS_SQLBROWSE_INTRO_DB]
DoAction ISSQLQueryDatabases
DoAction ESNA_DB_IN_USE
From the ESNA_DB_IN_USE I have an installScript to get the DB LIST.
I get the IS_SQLSERVER_LIST property using MsiGetProperty (hMSI,"IS_SQLSERVER_LIST",szDBList,nDBList);
The szDBList is empty. Why doesn't the IS_SQLSERVER_LIST contain the list of DBs?
Can someone please tell me what I am doing wrong? Is there another property with the list of DBs?
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Feb 22, 2011
12:21 PM
Have you checked out this thread?