Page 1 of 1

how to connect sql server ce?

Posted: Wed 04 Nov 2009 03:26
by bugmenot1
how to connect sql server ce with delphi 7??
pls give me a demo.

Posted: Wed 04 Nov 2009 14:09
by 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;