Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - ASPNETDB
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ASPNETDB

 Post Reply Post Reply Page  12>
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Topic: ASPNETDB
    Posted: 18 April 2011 at 12:04pm
Pausing/Stopping a website in your Control Panel disables the web site from working and will mean any requests for the website would show the default web page for the whole server which can not be modified.
Back to Top
AlexW View Drop Down
Newbie
Newbie
Avatar

Joined: 15 April 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexW Quote  Post ReplyReply Direct Link To This Post Posted: 18 April 2011 at 10:52am
Have created a ticket, however I have a quick question; can I customize the page used when the website is paused?  It doesnt seem to be using _holding.htm.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 April 2011 at 1:37pm
Please create a support ticket from your Client Area account so we are able to look at your website to find what the issue maybe.
Back to Top
AlexW View Drop Down
Newbie
Newbie
Avatar

Joined: 15 April 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexW Quote  Post ReplyReply Direct Link To This Post Posted: 17 April 2011 at 1:10pm
Thanks Bruce, I got the DB working.  However I am concerned that there may be some settings I need to look at because the ASP.NET menu (using Web Developer 2010 Express) doesnt work and appears simply as links, and some code populating drop down lists causes an error while viewing the site online??
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 April 2011 at 12:38pm
Have a look in your Space Summary email that you got when the account was created there is an example connection string which will also include the correct database host name for your account.
Back to Top
AlexW View Drop Down
Newbie
Newbie
Avatar

Joined: 15 April 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexW Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2011 at 7:11pm

Ah I've found that after creating a user you can then access these tools. 

Can you however advise on the connection string I should use, currently it is:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True

Working locally
Back to Top
AlexW View Drop Down
Newbie
Newbie
Avatar

Joined: 15 April 2011
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexW Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2011 at 4:36pm
Hi Bruce,
 
When I 'publish' the DB from Web Developer and get the SQL file containing all proceedures to re-create the database, I thought this was the preferred method of uploading the DB to host?
 
In the Database Tools I can see Backup in the Maintenance Tools section but no restore function?
 
What format does the backup need to be if not the SQL file as I only have an option to 'Publish'?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2011 at 8:35pm
As you mention ASPNETDB is the default name for databases created in Visual Studio. With shared hosting your database would sit on a SQL Server shared with other customers and so you would not be able to create a database with the same name as that set by another customer.

What you would need to do is create a database with a name that is not already being used, then create a backup of your present database which you can upload to our servers using the 'Database Tools' link in your control panel. The database would then be restored to our database servers.

Not really sure what you mean by:-

Quote can't I run the SQL query from publishing the DB in Web Developer to get everything created?
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.