SQL Server Compact Samples

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FraDusOne
Posts: 1
Joined: Tue 20 Mar 2007 16:35

SQL Server Compact Samples

Post by FraDusOne » Tue 20 Mar 2007 16:40

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

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 22 Mar 2007 07:49

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
Posts: 2
Joined: Fri 24 Feb 2006 09:35

SQL-Server Compact-Edition Delphi Example missing

Post by RobertBinsack » Fri 16 Apr 2010 04:48

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 16 Apr 2010 12:36

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';

Post Reply