This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQLDMO.SQLServer is unaccessible on Vista
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 25, 2008
09:28 AM
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?
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?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 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?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 25, 2008
12:43 PM
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.