What is the proper syntax for sql ce max db size?
Posted on 2008-11-07
Here is my problem. Microsoft. I use a SQL CE database in my application and it works fine but microsoft defaults the database size to 256mb. I know SQL ce can use databases much much larger than this. Somewhere in the 4 gig range max I think. My question is what is the syntax for the connection string to set the max size?
Here is my current connection string
const ConSting = "Data Source = C:\Program Files\MyAppFolder\MyAppDB.sdf; password = MyAppDBPassword"
To me this is an idiotic setting it seems like if you wanted to limit the size of the db you would have to over ride the default max db size of 4gig not the other way around.
Thanks in advance