Detect sql server 2008 (Express)

[spif2001]

Hi First of all I have to say, that I'm in no way an SQL expert more likely an SQL dummy, so be warned. :) I'm am currently building an InnoSetup installer hierarchy and as a part of that I have made a prerequisite downloader+installer for various Microsoft items - .NET Frameworks, Windows Installers, Internet Explorers, MDAC etc. To detect the various components I use mostly registration keys, but as I played around with SQL Server 2005 Express I found out, that registration keys wasn't a good way detect it. Instead I tried creating an Ole object like this:

function SQLServerExpress2005Exist(): Boolean;
begin
Result := True;
try
SQLServer := CreateOleObject('SQLDMO.SQLServer');
except
if MsgBox(CustomMessage('SQLServerExpress2005Msg'), mbConfirmation, MB_YESNO or MB_DEFBUTTON2) = IDYES then Result := False;
end;
end;

This method works when trying to detect an SQL Server 2005, but when I try using the same method on my computer with a running SQL Server 2008 Express, it doesn't work i.e. the code enters the except block. What is the best way to detect an installed (not necessarily running) SQL Server 2008?

I'm in the high-fidelity first class traveling set. And I think I need a Lear jet.

[Tamer Oz]

try System.Data.Sql.SqlDataSourceEnumerator.Instance.GetDataSources(); :)

[spif2001]

That looks like a .NET library and I can't use .NET in InnoSetup - not directly anyway and I can't be sure of which .NET version is on the target machine, and if it has one at all. InnoSetup code is written in Pascal, so what I really need is a Pascal way of doing the check. :)

I'm in the high-fidelity first class traveling set. And I think I need a Lear jet.