Reply

BB

Member

20 Points

What am I doing wrong?

Aug 14, 2006 02:51 PM|LINK

I am trying to get my site to work online and having problems. I was initially using the beta version but just recently downloaded the new version. I am using godaddy and here is what I have done so far:

I downloaded the final version at http://www.asp.net/downloads/starterkits/default.aspx?tabid=62

I followed the directions from http://help.godaddy.com/article.php?article_id=688&topic_id

I used the Query Analyser from the SQL Server Web Admin to install classifieds-add.sql and classifieds-categories.sql from the App_Data folder. Tables, views and stored procedures were all entered.

I have tried several several different connection strings:

Only the first connection string above will work on my localhoast. The last two will not and I get this error when I debug:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

None of them work online. I will always get the error.aspx page telling me to contact the site administrator.

This is the first time I have ever done this... Please advise.

Thanks,

BB

Reply

justin0501

Member

705 Points

138 Posts

Re: What am I doing wrong?

Aug 14, 2006 04:16 PM|LINK

Your first connection string works as it is for sql express which is intalled locally on your machine.

GoDaddy allows one database, unless you have purchased another. So the third set of connection strings seem correct:

Basically when you setup the .net 2.0 schema for the users and roles go daddy puts everything in your DB_79394 database, and then I'm assuming you ran the classifieds sql scripts in that database as well.

Now, if you try and connect to that database from your local machine, you will get that error message. Go Daddy will not allow you to access their sql servers from a remote machine. So you will either need to use the sql express connection string when developing on your local machine and switch your connection strings when you upload the application to go daddy's server. Or you can develop the app, then upload it and test it that way which is time consuming

Reply

BB

Member

20 Points

4 Posts

Re: What am I doing wrong?

Aug 14, 2006 06:03 PM|LINK

I still get the error.aspx page with this connection string when I try to access online.

Should I have not entered the classifieds-add.sql or the classifieds-categories.sql into the query analyser? What am I not doing right?

Reply

justin0501

Member

705 Points

138 Posts

Re: What am I doing wrong?

Aug 14, 2006 06:11 PM|LINK

You are right by running those sql scripts, but can you post the actual error message you are getting?You may need to change your custom errors tag in your web.config to this:

Reply

BB

Member

20 Points

4 Posts

Re: What am I doing wrong?

Aug 15, 2006 12:46 AM|LINK

Ok I turned that off and now it gives me the following error. Did I not set up my database right?

Server Error in '/' Application.

Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.

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.ArgumentException: Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.

Source Error:

[No relevant source lines]

Source File: App_Code.bmauaqv3.11.vb Line: 1470

Stack Trace:

[ArgumentException: Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.]
   System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +1406642
   System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +102
   System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +52
   System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
   System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +125
   System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +56
   System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4
   AdsDataComponentTableAdapters.AdsDataAdapter.InitConnection() in App_Code.bmauaqv3.11.vb:1470
   AdsDataComponentTableAdapters.AdsDataAdapter.get_Connection() in App_Code.bmauaqv3.11.vb:1356
   AdsDataComponentTableAdapters.AdsDataAdapter.InitAdapter() in App_Code.bmauaqv3.11.vb:1428
   AdsDataComponentTableAdapters.AdsDataAdapter.get_Adapter() in App_Code.bmauaqv3.11.vb:1346
   AdsDataComponentTableAdapters.AdsDataAdapter.GetAdsByRandomOrder(Int32 NumRecords, Int32 AdStatus, Int32 AdLevel) in App_Code.bmauaqv3.11.vb:1667
   AspNet.StarterKits.Classifieds.BusinessLogicLayer.AdsDB.GetFeaturedAdsSelection(Int32 maxNumAds) in d:\hosting\brettbissell\App_Code\BLL\Ads.vb:220
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.FetchFeaturedAd() in d:\hosting\brettbissell\App_Code\Web\FeatureCache.vb:94
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd(HttpContext context) in d:\hosting\brettbissell\App_Code\Web\FeatureCache.vb:81
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd() in d:\hosting\brettbissell\App_Code\Web\FeatureCache.vb:69

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040
   System.Web.UI.WebControls.Repeater.GetData() +50
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   System.Web.UI.WebControls.Repeater.EnsureDataBound() +55
   System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12
   System.Web.UI.Control.PreRenderRecursiveInternal() +77
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

Reply

justin0501

Member

705 Points

138 Posts

Re: What am I doing wrong?

Aug 15, 2006 02:08 AM|LINK

I missed this before but it looks like you have a typo in your connection string. Currently you have:

The ClassifiedsConnection is missing the Server keyword. It should look like:

Give that a try and let me know

Reply

BB

Member

20 Points

4 Posts

Re: What am I doing wrong?

Aug 15, 2006 02:41 AM|LINK

I can't thank you enough! That works! I can't login as the administrator but I saw other postings on this topic. I will trouble shoot first.

Thanks for all the help,

BB

What am I doing wrong? RSS

6 replies

BB

What am I doing wrong?

justin0501

Re: What am I doing wrong?

BB

Re: What am I doing wrong?

justin0501

Re: What am I doing wrong?

BB

Re: What am I doing wrong?

Server Error in '/' Application.

Keyword not supported: 'whsql-v04.prod.mesa1.secureserver.net;database'.

justin0501

Re: What am I doing wrong?

BB

Re: What am I doing wrong?

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft