I have just moved my database from SQL CE to SQL 2012 using the Export SQL Server Compact package. I've ran the script but after updating the web.config to point the new database I get the following error:
Server Error in '/' Application.
Object reference not set to an instance of an object.
Are there any other settings that need to be changed?
I just seemed to fix it, I hadn't called the name="umbracoDbDSN" I'd given it a custom name but after changing it back (with the new string) it appears to be working now!
Error after switching from SQL CE to SQL 2012
Hi,
I have just moved my database from SQL CE to SQL 2012 using the Export SQL Server Compact package. I've ran the script but after updating the web.config to point the new database I get the following error:
Server Error in '/' Application. Object reference not set to an instance of an object.
Are there any other settings that need to be changed?
Thanks, Jeff
I'd say it looks like your database settings are not correct.
Most likely the server path / name.
What does your connection string look like ?
Thanks
Carl
Hi Carl,
I just seemed to fix it, I hadn't called the name="umbracoDbDSN" I'd given it a custom name but after changing it back (with the new string) it appears to be working now!
So it was:
But changed it to:
Thanks, Jeff
Ah yes - that would do it - The connection string name is coded into Umbraco.
You can add aditional connections to the web config and use them from your own code if you like but the Umbraco one is fixed.
Glad you made it work
Carl
is working on a reply...