Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 01, 2009 09:12 PM by rogriall79
Apr 24, 2009 10:43 PM|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|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|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|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|LINK
Thanks that helped out a lot. It works great now....
Apr 30, 2009 10:09 PM|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|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|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|LINK
These r the one i am given......which do u recommend:
May 01, 2009 02:08 AM|LINK
Use the last one.