Last post Jul 01, 2009 09:12 PM by rogriall79
Apr 24, 2009 10:43 PM|rogriall79|LINK
I uploaded my site to godaddy and I keep getting this when I sign into my site:
I have seen this in a previous post but I am not sure how this applies to my site, here is my connection string
<add name="AspnetdbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\GNJDB.MDF;Integrated Security=True;User Instance=True"
<add name="GNJDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\GNJDB.mdf;Integrated Security=True;User Instance=True"
So do I delete this and replace it with this:
I am new to this so I didn't even know I had to change anything in my web.config file and godaddy didn't say anything either.
Thanks to anyone who can help me become less confused
Apr 25, 2009 02:26 AM|b471code3|LINK
I have godaddy hosting also and my connection string looks similar but unless you renamed the database I think that could be the problem, take a look at mine. If I remember right, I wasn't able to rename the db. Also try removing spaces between the semi
colon and the next item in the string.
Apr 26, 2009 07:14 PM|rogriall79|LINK
Ok I see. I didn't change the name of my DB but how do I get the connection string from godaddy? if I call will they give it to me. Probably a dumb question but that seems to be my prob. I was searching around the hosting part of my account and I cant
really see how it get it. how did you link it to their server?
Apr 26, 2009 11:58 PM|b471code3|LINK
After I logged in, on the left navigation there is a link named "Hosting", click it. On the next page it will show your hosting accounts, click on the account in Manage Account under the Control Panel header. This will open another window, in which you
click on the Databases in the Accordion control then click on SQL Server. There it will show your SQL Server version and name. If you click on the pencil it will display all your info with the exception of your password.
Good luck, hope this helps
Apr 30, 2009 03:55 AM|rogriall79|LINK
Thanks that helped out a lot. It works great now....
Apr 30, 2009 10:09 PM|rogriall79|LINK
OK I have one more question. I actually have the connection to my DB but it only shows my ASP Tables and not my Products Tables. I was wondering if you know whtI might be doing wrong. I actually went through and got rid of all my login and membership
pages and tables from my website to see what is wrong. I am now thinking I might be using the wrong connection string. I used the string
For my DB but only my ASP tables are showing. Do you think it might be something else? Should I use a different Connection string? I am not sure why I can only see my ASP tables and not my Product Tables. This is even after I deleted all login stuff
from my site.
It is starting to get to me a bit.....I really hope you can help, I am not sure why after connecting my DB only select tables are able to be used.
May 01, 2009 12:38 AM|b471code3|LINK
Any particular reason you are not using just a regular SQL client provider vs your OLE DB provider?
May 01, 2009 12:53 AM|rogriall79|LINK
Actually I don't know the difference but I will use this one instead and see how it works:
Not sure what the difference is, I am still reading up on DB and programing so if this is the problem then I will have to look at it more.
Is this what you meant by the regular SQL Client Provider?
May 01, 2009 01:50 AM|rogriall79|LINK
These r the one i am given......which do u recommend:
May 01, 2009 02:08 AM|b471code3|LINK
Use the last one.
May 01, 2009 03:35 AM|rogriall79|LINK
<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" />
This is my connectionstring, when i use this it doesnt show any of my actual products tables. Could the problem be elsewhere?
May 01, 2009 04:31 AM|rogriall79|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.
When I click on anything that is supposed to display data this is what I get:
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.
System.Data.SqlClient.SqlException: Invalid object name 'Brands'.
May 01, 2009 05:25 PM|b471code3|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.
May 01, 2009 07:55 PM|rogriall79|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?
May 01, 2009 09:05 PM|b471code3|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
May 01, 2009 09:55 PM|jwadsworth|LINK
Here is some additional help with publishing to godaddy.
and a tutorial
Jul 01, 2009 09:12 PM|rogriall79|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.