I just went through my web.config and commented out all of the asp.net membership info to see if I could get it to work properly. it does. I now want absolutely nothing to do with and login function and just want my DB to work properly.
Do I have to do anything with my web.config to get me DB to just show my products? or to get teh connectionstring to recognize my GNJDB. I have the correct connectionstring I still have no clue why it isn't showing up.
When I click on anything that is supposed to display data this is what I get:
Invalid object name 'Brands'.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.Data.SqlClient.SqlException: Invalid object name 'Brands'.
When you look online at your GoDaddy database manager do you see your tables in that database? You may have to use their tool to add them or try to connect via SSMS.
Remember to mark as answer if this post answered or solved your problem.
When I look on godaddy's database manager it only shows my asp tables and not my product tables. they are in the same db so i am curious as to why it only shows half my tables. So you are saying I should use their program instead of filezilla, I have
never connected via SSMS. Is it ant different?
The only way I was ever able to add tables to the database on GoDaddy was to use their tool. Never tried to connect via SSMS as I am guessing GoDaddy wouldn't allow it. Not sure how you use Filezilla to upload tables to a database but my guess is it didn't
work. There is a tool out there provided by Microsoft that will allow you to publish your db to a hosted provider. What I would suggest doing is creating a backup of your db on godaddy, then coping the .bak file to your local machine, restore it to your
local machine then make the mods to it and re-publish it to godaddy.
I am still having problems with my website...I was wondering if you could go to www.gnjwholesale.com and click on a link to view the error and let me know what you think might be wrong....I am really stuck.
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 03:35 AM|LINK
<clear />
<add name="GNJDBConnectionString" connectionString="Data Source=GNJDB.db.4160044.hostedresource.com; Initial Catalog=GNJDB; User ID=GNJDB;Password="mypassword"; Trusted_Connection=False" providerName="System.Data.SqlClient" />
</connectionStrings>This is my connectionstring, when i use this it doesnt show any of my actual products tables. Could the problem be elsewhere?
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 04:31 AM|LINK
I just went through my web.config and commented out all of the asp.net membership info to see if I could get it to work properly. it does. I now want absolutely nothing to do with and login function and just want my DB to work properly.
Do I have to do anything with my web.config to get me DB to just show my products? or to get teh connectionstring to recognize my GNJDB. I have the correct connectionstring I still have no clue why it isn't showing up.When I click on anything that is supposed to display data this is what I get:
Invalid object name 'Brands'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'Brands'.
Thanks
b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 05:25 PM|LINK
When you look online at your GoDaddy database manager do you see your tables in that database? You may have to use their tool to add them or try to connect via SSMS.
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 07:55 PM|LINK
When I look on godaddy's database manager it only shows my asp tables and not my product tables. they are in the same db so i am curious as to why it only shows half my tables. So you are saying I should use their program instead of filezilla, I have never connected via SSMS. Is it ant different?
b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 09:05 PM|LINK
The only way I was ever able to add tables to the database on GoDaddy was to use their tool. Never tried to connect via SSMS as I am guessing GoDaddy wouldn't allow it. Not sure how you use Filezilla to upload tables to a database but my guess is it didn't work. There is a tool out there provided by Microsoft that will allow you to publish your db to a hosted provider. What I would suggest doing is creating a backup of your db on godaddy, then coping the .bak file to your local machine, restore it to your local machine then make the mods to it and re-publish it to godaddy.
Here is the tool
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
jwadsworth
Contributor
2378 Points
542 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 09:55 PM|LINK
Here is some additional help with publishing to godaddy.
http://help.godaddy.com/article/3437
and a tutorial
http://products.secureserver.net/products/hosting/PublishingWithDPW.htm
Extended Personal Site Starter kit
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
Jul 01, 2009 09:12 PM|LINK
I am still having problems with my website...I was wondering if you could go to www.gnjwholesale.com and click on a link to view the error and let me know what you think might be wrong....I am really stuck.
Thanks, rogriall79