SQL Server Compact Samples

[FraDusOne]

Are there any Delphi code samples working with SQL Server Compact using SDAC 4.0 avalible?

[Jackson]

An example of working with SQL Server Compact Edition you can find in %SDAC%\Demos\TechnologySpecific\MSSQLCompact,
where %SDAC% is the SDAC installation path on your computer.

[RobertBinsack]

Hi!

I wanted to use UniDAC with SQL-Server Compact Edition with Delphi 7. I've just downloaded the UniDAC for Delphi 7 Version 3.00.0.8 (12-Apr-2010) from the registered Users Area.

After doing a complete installation with everything checked (also examples) I took a look at the %SDAC%\Demos\TechnologySpecific\MSSQLCompact-Folder and there is only a "SecureBridge"-Folder but not samples for SQL-Server compact.

Can you help me or post the example-files here?

Kind regards,

Robert

[Dimon]

You can work with TUniConnection and SQL Server Compact Edition the same way as with an ordinary SQL Server database.
Set the OLEDBProvider specific option to prCompact and specify the path to the database file in the Database property, like this:

Code: Select all

UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prCompact';
UniConnection.Database := 'database.sdf';