Hi,
I have a new project in umbraco 7 using mvc.
I have installed umbraco to an existing database on sql server (nor sql server express).
I'm now trying petapoco database connection and inserts (http://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/).
I don't get any errors but the records in the database table is not inserted.
I am wondering if I have the database connection set up properly or the record is going somewhere else perhaps?
In my connection string says
Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;
The database name is obviously different. Shall I use classic database connection string in this case?
Umbraco.sdf is the standalone SQL Server CE database file which you should find in the App_Data directory of your Umbraco installation. So it sounds like you're probably inserting to that database rather than your existing SQL Server database.
Umbraco 7 mvc existing database connection
Hi, I have a new project in umbraco 7 using mvc. I have installed umbraco to an existing database on sql server (nor sql server express).
I'm now trying petapoco database connection and inserts (http://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/). I don't get any errors but the records in the database table is not inserted.
I am wondering if I have the database connection set up properly or the record is going somewhere else perhaps?
In my connection string says Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;
The database name is obviously different. Shall I use classic database connection string in this case?
Umbraco.sdf is the standalone SQL Server CE database file which you should find in the App_Data directory of your Umbraco installation. So it sounds like you're probably inserting to that database rather than your existing SQL Server database.
Phil
is working on a reply...