Free App: Frost Alert

[vikkib]

I tried to sign up too. Entered email address and password and got the following error returned:

_______________________________________________________________

"Server Error in '/' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +376
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +44
System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +45
System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +20
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +57
System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +23
System.Linq.Queryable.Count(IQueryable`1 source) +240
FrostAlert.CreateAccount.btnCreateAccount_Click(Object sender, EventArgs e) in C:\Users\leon\Documents\Visual Studio 2008\Projects\FrostAlert\FrostAlert\CreateAccount.aspx.vb:14
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074"

_______________________________________________________________

Will try again tomorrow as it sounds very handy!

[throup]

I don't think the location search feed supports postcodes unfortunately, but I'll have a look at the API documentation in case I'm missing anything.

Thanks for looking into it. I have no idea what the weather.com API is like, but if it will support it that would be great.

If it's any use, I know streetmap.co.uk has a nice tool to convert postcodes to geographic data including latitude and longitude. For example, go to Grid Conversion Results to see date for BBC TV Centre. Replace the name parameter with the postcode you are searching for and you could easily parse the resulting data table.

[Crundy]

Sorry sorry sorry!!
I added a quick admin stats page and managed to knacker up the connection string in the config file. It's back up again now! I promise not to mess around with it again until at least tomorrow!

[Crundy]

Oh, by the way, the email alerts are sent from Alerts@FrostAlert.co.uk so make sure you have this whitelisted if you have spam blocking software.

[zazen999]

Ok, it worked this time - you mended it inbetween me getting that message above and posting on here.....

[amandaandherveg]

Worked for me too - thankyou.

[AnnetteJ]

Thank you - it's working for me too now!!

Annette

[w33blegurl]

Signed up and alerts set up....fingers crossed then!

[zazen999]

I've put an 8 degree alert on mine, so I'll let you know if I get an email as it is bound to go under that in the next few nights.

[Crundy]

I've put an 8 degree alert on mine, so I'll let you know if I get an email as it is bound to go under that in the next few nights.

Good idea. Thanks.
The email task runs at 10am every day, so if you find you haven't got an email by tomorrow lunchtime then let me know in here and I'll try and find out what's wrong.

[Hans Mum]

thanks have registered

[AGardener]

Great idea. Should be a very useful tool.

[Alice]

I've just registered, but all I was asked for was my E - mail address.
Have I missed a step somewhere.

[Alice]

I tried to log back in to see if I had missed something.
Got an error message saying e- mail and password don't match.
The e-mail is correct so maybe I made a typo in the password, but can't find anyway to correct that.

[Crundy]

Did you get the confirmation email? You need to verify that you own the email address to stop people just making up email addresses and adding alerts for them.