Web Hosting Forum | Lunarpages
News: July 14, 2008 - New Contest! - Submit Your WordPress Theme Designs, Win BIG!
June 30, 2008 - Submit Your Site for the July 08 Site of the Month Award!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
July 25, 2008, 05:09:20 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Error message connection closed?  (Read 351 times)
sarahjayne5792
Space Explorer
***
Offline Offline

Posts: 6


« on: April 25, 2008, 07:24:41 PM »

I am trying to figure out how to get my database uploaded to lunarpages. i am using aspx converted to mssql pages. i have followed the instructions provided by the friendly tutors on this site but this is the error i keep getting when i click submit. Can any one help?

Offending URL: http://lesuth.lunarpages.com/mylittleadmin3/tools/query.aspx

Source: System.Data

Message: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

Stack trace: at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at mla_gui.NewQuery.btnSubmit_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Target site: System.Data.SqlClient.SqlInternalConnection GetOpenConnection(System.String)
Logged
MrPhil
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3106



« Reply #1 on: April 26, 2008, 03:57:43 PM »

You may have to wait until your domain has propagated to your ISP and you can use your domain instead of the generic server name. I think there are a lot of restrictions on what can be run this way. By the way, don't you have to give your account name in there? If you're on a Linux server (Basic or Business account), it would be something like http://lesuth.lunarpges.com/~sara35/mylittleadmin3/tools/query.aspx.
Logged

sarahjayne5792
Space Explorer
***
Offline Offline

Posts: 6


« Reply #2 on: April 26, 2008, 08:16:25 PM »

hmm,maybe thats it, but i thought that if you registered your domain name with lunarpages you were supposed to be able to upload domains databases almost immediately. i'm so new to this stuff, i regestered the name and got the confrimation on wednesday or thursday i think...so i guess it takes up to 72 hours? Is there any way to tell when it has propagated? as far as my account name...i did everything exactly as that on tutorial on the forum says that's posted right on top called "my first .net experience" and that was the error i got when i submitted my query. i'll try again later and see if it works.
Logged
Troy Laclaire
Support
Intergalactic Superstar
*****
Offline Offline

Posts: 156


Darkwolf


« Reply #3 on: April 26, 2008, 09:55:10 PM »

If your domain is registered through lunarpages, it may still take up to 72 hours for propagation, depending on location.

Generally the best way to tell if propagation has taken effect, is to setup a very basic page on your domain, and if you see it, then propagation should be ok for you.

How large is the database file you are trying to import?

If the issue continues, you may want to upload it to your site, and contact support@lunarpages.com   and provide :

Database name:
Database username:
Database password:
Location of database file:

And we can further look into any issues being received.

Logged

Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.3 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM