cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tjacobsky
Level 3

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

Have you checked out this thread?
0 Kudos