PDA

View Full Version : SQLDMO.SQLServer is unaccessible on Vista



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

Kovalenko
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?

hidenori
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.