cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kovalenko
Level 6

SQLDMO.SQLServer is unaccessible on Vista

Hello,

OS: Vista
Project type: Basic MSI (IS 2009)

I have some code (in InstallScript) that gets a list of SQL databases. It is done via SQLDMO.SQLServer object, but the following code seems to not get the object:

set oSqlServer = CreateObject("SQLDMO.SQLServer");
if(IsObject(oSqlServer)) then
...

Interestingly that this works on XP. What may be the problem?
Labels (1)
0 Kudos
(2) Replies
Kovalenko
Level 6

I found the reason. There is no SQL Server installed locally. Is there other way to list SQL databases without having SQL Server installed on local machine?
0 Kudos
hidenori
Level 17

There are some samples for the database management available at InstallSite. Please see the List SQL Servers section. It might be what you are looking for.
0 Kudos