What is oledb Compatable connection string for sql server compact (default) database.
normal connection string (got from server explorer db properties) is :
"Data Source=C:\UmbracoDemo\App_Data\Umbraco.sdf"
connection string in web.config is
<connectionStrings>
<remove name="umbracoDbDSN" />
<add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />
<!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->
</connectionStrings>
The connection string in your web config is more dynamic than the one you got from Server Explorer.
|DataDirectory| tells the system to look for the app_data directory in the current directory of the application, in this case your website. At least that is my understanding.
Umbraco form PROBLEM
Hi,
What is oledb Compatable connection string for sql server compact (default) database.
normal connection string (got from server explorer db properties) is :
"Data Source=C:\UmbracoDemo\App_Data\Umbraco.sdf"
connection string in web.config is
Tnxx
The connection string in your web config is more dynamic than the one you got from Server Explorer.
|DataDirectory| tells the system to look for the app_data directory in the current directory of the application, in this case your website. At least that is my understanding.
is working on a reply...