| Author |
How can I tell if SQLServer2005_BC.msi is already installed?
|
|
|
| My application used SQL-DMO to connect to and manage a SQL Server 2000
database. We want to include the new 2005 version of SQL-DMO that is
part of SQLServer2005_BC.msi as a conditional prerequisite in our
install. What should the condition of this prerequisite be? Is there
a way to know if SQLServer2005_BC.msi has already been installed?
| |
| John Bell 2006-01-03, 8:23 pm |
| Hi Todd
If you install this regardless would it be an issue?
John
"Todd" <todderickson@gmail.com> wrote in message
news:1136309306.790334.214130@f14g2000cwb.googlegroups.com...
> My application used SQL-DMO to connect to and manage a SQL Server 2000
> database. We want to include the new 2005 version of SQL-DMO that is
> part of SQLServer2005_BC.msi as a conditional prerequisite in our
> install. What should the condition of this prerequisite be? Is there
> a way to know if SQLServer2005_BC.msi has already been installed?
>
| |
|
| Thanks for that thought John. At this point I think it would be fine
if I always installed it. It may become an issue if a newer version of
these components gets installed, although one would hope that the MSI
would catch this itself.
-Todd
| |
| Tibor Karaszi 2006-01-04, 3:23 am |
| Thinking out loud here... How about checking the registry for registration of those COM components?
I have a feeling that with some investigating work, you could determine how to differentiate whether
7.0, 8.0 and/or 9.0 DMO has been installed. There are a bunch of such components in the registry,
for instance HKEY_CLASSES_ROOT\SQ
LDMO.Backup
HKEY_CLASSES_ROOT\SQ
LDMO.Backup.8.0
HKEY_CLASSES_ROOT\SQ
LDMO.Backup2
I believe that some objects has the 2 at the end, which were extensions made between 7.0 and 8.0
(remember that you shouldn't change a COM object - create a new instead). But perhaps you can try
some combinations and from that determine which has been installed? Or perhaps there exists some
other better registry entry for that?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Todd" <todderickson@gmail.com> wrote in message
news:1136327678.345758.282570@o13g2000cwo.googlegroups.com...
> Thanks for that thought John. At this point I think it would be fine
> if I always installed it. It may become an issue if a newer version of
> these components gets installed, although one would hope that the MSI
> would catch this itself.
> -Todd
>
|
|
|
|