Page 1 of 1
SQL Server Compact Samples
Posted: Tue 20 Mar 2007 16:40
by FraDusOne
Are there any Delphi code samples working with SQL Server Compact using SDAC 4.0 avalible?
Posted: Thu 22 Mar 2007 07:49
by 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.
SQL-Server Compact-Edition Delphi Example missing
Posted: Fri 16 Apr 2010 04:48
by 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
Posted: Fri 16 Apr 2010 12:36
by 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';