Devart Forums

Posted: **Sun 25 Sep 2011 10:24**

hello
if the unidac support sql server compact edition?
in history list i see that sql server 3.x have support sql server compact 4 edition. how about 3.5?

and how to use it?

if not supported what version of unidac that compatible with sdac 4.8?

thx a lot

Posted: **Mon 26 Sep 2011 08:20**

Hello,

UniDAC supports SQL Server Compact Edition 3.5. To connect to SQL Server Compact database, you can use the following code:

Code: Select all

UniConnection.ProviderName := 'SQL Server';
UniConnection.Database := 'filename'; // .sdf
UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prCompact';
UniConnection.LoginPrompt := False;
UniConnection.Open;