Connecting to Compact database with different options

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yeohray
Posts: 56
Joined: Mon 26 Mar 2007 01:25

Connecting to Compact database with different options

Post by yeohray » Wed 23 May 2007 07:36

How can I connect to a SQL Server Compact database with a custom 'maximum database size' value? Using OLEDB, I would have used the DBPROP_SSCE_MAX_DATABASE_SIZE to set this value when making the connection.

Thanks.

Ray Mond

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

Post by Jackson » Wed 23 May 2007 10:36

SDAC doesn't allow to set this property. SDAC just sets it to the maximum possible value: 4091.
We have in plans to introduce an extended support of the SQL Server Compact Edition to let users access SQL Server Compact Edition specific properties.

Post Reply