View Full Version : SQLDMO.SQLServer is unaccessible on Vista

07-25-2008, 09:28 AM

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?

07-25-2008, 09:52 AM
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?

07-25-2008, 12:43 PM
There are some samples for the database management available at InstallSite (http://www.installsite.org/pages/en/isp_db.htm). Please see the List SQL Servers section. It might be what you are looking for.