Personal Site Starter Kit

Re: problems connecting to SQL Server 2005

rogriall79 — Wed, 01 Jul 2009 21:12:18 GMT

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

Re: problems connecting to SQL Server 2005

mintzberg — Sun, 21 Jun 2009 06:29:36 GMT

Really helpful information.

About detailed info on Management go to Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} <a href="http://www.provenmodels.com" title="Henry Mintzberg">Henry Mintzberg</a>

Re: problems connecting to SQL Server 2005

jwadsworth — Fri, 01 May 2009 21:55:27 GMT

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

Re: problems connecting to SQL Server 2005

b471code3 — Fri, 01 May 2009 21:05:45 GMT

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

Re: problems connecting to SQL Server 2005

rogriall79 — Fri, 01 May 2009 19:55:39 GMT

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?

Re: problems connecting to SQL Server 2005

b471code3 — Fri, 01 May 2009 17:25:44 GMT

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.

Re: problems connecting to SQL Server 2005

rogriall79 — Fri, 01 May 2009 04:31:24 GMT

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

Re: problems connecting to SQL Server 2005

rogriall79 — Fri, 01 May 2009 03:35:19 GMT

</connectionStrings>

This is my connectionstring, when i use this it doesnt show any of my actual products tables. Could the problem be elsewhere?

Re: problems connecting to SQL Server 2005

b471code3 — Fri, 01 May 2009 02:08:49 GMT

Use the last one.

Re: problems connecting to SQL Server 2005

rogriall79 — Fri, 01 May 2009 01:50:01 GMT

These r the one i am given......which do u recommend:

ODBC:
Driver={SQL Server}; Server=GNJDB.db.4160044.hostedresource.com; Database=GNJDB; Uid=GNJDB; Pwd='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=GNJDB.db.4160044.hostedresource.com; Initial Catalog=GNJDB; User ID=GNJDB; Password='your password';

SqlConnection (.NET):
Data Source=GNJDB.db.4160044.hostedresource.com; Initial Catalog=GNJDB; User ID=GNJDB; Password='your password';

I am currently using the middle one.

Re: problems connecting to SQL Server 2005

rogriall79 — Fri, 01 May 2009 00:53:44 GMT

Actually I don't know the difference but I will use this one instead and see how it works:

SqlConnection (.NET):
Data Source=GNJDB.db.4160044.hostedresource.com; Initial Catalog=GNJDB; User ID=GNJDB; Password='your password';

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?

Re: problems connecting to SQL Server 2005

b471code3 — Fri, 01 May 2009 00:38:39 GMT

Any particular reason you are not using just a regular SQL client provider vs your OLE DB provider?

Re: problems connecting to SQL Server 2005

rogriall79 — Thu, 30 Apr 2009 22:09:56 GMT

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

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=GNJDB.db.4160044.hostedresource.com; Initial Catalog=GNJDB; User ID=GNJDB; Password='your password';

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.

Thanks RIch

Re: problems connecting to SQL Server 2005

rogriall79 — Thu, 30 Apr 2009 03:55:06 GMT

Thanks that helped out a lot. It works great now....

Re: problems connecting to SQL Server 2005

b471code3 — Sun, 26 Apr 2009 23:58:06 GMT

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