Hi. When you do your database backup to make you BAK version, are you selecting a 'Full' backup setting?
If you are using the 'Full' backup setting, then can you check the database on the provider to ensure all the tables ands stored procedures have been created? Your error indicates that your SQL code is calling a Table or Stored Procedure that is missing in
the provider database.
One last thing, have you checked the connection string, because your local string would refere to ./SQLExpress or similar, whereas on the provider, it will need to point to PROVIDERDATABASENAME/SQLExpress or PROVIDERDATABASENAME/SQLServer.
saly
Member
52 Points
45 Posts
Invalid Object Name error 0x80131904
Apr 30, 2012 06:04 AM|LINK
Hello all,
I have this error for 2 weeks and I couldn't solve it and I read this post that may start solving from it
http://our.umbraco.org/forum/getting-started/installing-umbraco/24591-Invalid-object-name-%27umbracoDomains%27
My database is working in my localhost perfectly with no errors but when I convert it BAK file and upload it to ixwebhosting I faced this error
please help me to share all posts
Thanks
praseTech
Member
198 Points
51 Posts
Re: Invalid Object Name error 0x80131904
Apr 30, 2012 06:10 AM|LINK
check this link this may help you out
http://stackoverflow.com/questions/5374482/sqlexception-0x80131904-invalid-object-name-dbo-categories
saly
Member
52 Points
45 Posts
Re: Invalid Object Name error 0x80131904
Apr 30, 2012 06:20 AM|LINK
Hi praseTech,
I read this post before and I am sure of that perhapses or suggestions.
thank you
HamtekSoftwa...
Member
65 Points
23 Posts
Re: Invalid Object Name error 0x80131904
May 01, 2012 12:21 PM|LINK
Hi. When you do your database backup to make you BAK version, are you selecting a 'Full' backup setting?
If you are using the 'Full' backup setting, then can you check the database on the provider to ensure all the tables ands stored procedures have been created? Your error indicates that your SQL code is calling a Table or Stored Procedure that is missing in the provider database.
One last thing, have you checked the connection string, because your local string would refere to ./SQLExpress or similar, whereas on the provider, it will need to point to PROVIDERDATABASENAME/SQLExpress or PROVIDERDATABASENAME/SQLServer.
Hope that helps.