cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Pilgrim

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
Highlighted
Pilgrim

Re: SQLDMO.SQLServer is unaccessible on Vista

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
Highlighted
Pilgrim

Re: SQLDMO.SQLServer is unaccessible on Vista

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