how to connect sql server ce?

[bugmenot1]

how to connect sql server ce with delphi 7??
pls give me a demo.

[Dimon]

To connect to SQL Server CE you should set the following properties of TUniConnection:

Code: Select all

UniConnection.ProviderName := 'SQL Server';
UniConnection.SpecificOptions.Add('OLEDBProvider=prCompact');
UniConnection.Database := Path_To_Database_File;