Delphi and SQLCE

[topcat01]

Hi,

I would like to know if it is possible to access a SQL CE database via delphi, i suspect it is but have struggled to find a solution. I have delphi versions D6 Pro and D7.

I did find one example but was unable to identify how to use the units 'ADODB_TLB' and 'ssce35_tlb' - I think I need to install some additional software/drivers however none of the posts I've read tell me if this is the case...

//-----
...
  uses
    .. , ADODB_TLB, ssce35_tlb;
...
const
c_SSCE35 = 'Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=%s;Persist 
Security Info=False';
var
  s:String;
  connSDF      : _Connection;
begin
  connSDF    := CoConnection.Create;
  s:= Format(c_SSCE, [sFileName] );
  connSDF.Open( s, '', '', Integer (adConnectUnspecified ) );
...
end;
//-----

Thanks for any help