Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Size issue in SQL CE

Author  Topic  cweiz32 Starting Member 2 Posts Posted - 2007-04-18 : 12:06:33 I'm creating a DB on a Pocket PC 2003 device with a connection string in one of my programs through the Engine.CreateDatabase method. I'm setting Max Database Size through the connection string to be 1024. I then try to immediately pull about 2 million records into the database through an RDA connection using a compression level of three. The database size on the storage card I'm using ends up being 165M. I received no errors during the RDA pull. After that, any time I try to access the DB in CE Query or try to use it as a dataset in a program, I get the message that the database size is larger than the configured maximum database size. How do I get around this? Is there another way I should be creating the database?