Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
2 posts • Page 1 of 1
UniDAC supports SQL Server Compact Edition. To connect to SQL Server Compact database, you can use the following code:
Migrating from MS Access to SQL Server Compact is out of scope of our support. You can take a look at the following topic: http://social.msdn.microsoft.com/Forums ... rom-access . For more information, please write to the Microsoft support.
Code: Select all
UniConnection.ProviderName := 'SQL Server'; UniConnection.Database := 'filename'; // .sdf UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prCompact'; UniConnection.LoginPrompt := False; UniConnection.Open;