Page 1 of 1

Connecting to Compact database with different options

Posted: Wed 23 May 2007 07:36
by yeohray
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

Posted: Wed 23 May 2007 10:36
by Jackson
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.