Web Wiz
Home
Home		 Hosting Services
Hosting Services		 Knowledgebase
Knowledgebase		 Community and Support Forums
Support Forums		 Customer Login
Customer Login

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

Windows Web Hosting 30 Day Free Trial

Windows Web Hosting 30 Day Free Trial

Windows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.

For more information see our Windows Hosting 30 Day Free Trial page.

ASPNETDB
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
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 Topic: ASPNETDB
    Posted: 15 April 2011 at 8:24pm
Hi all,
 
I'm using the default ASP database: ASPNETDB.MDF but when I try to create it I get a message saying it already exisits.  Also can't I run the SQL query from publishing the DB in Web Developer to get everything created?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole, England
Status: Offline
Points: 8028 		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?
Find Web Wiz on Facebook
Follow Web Wiz on Twitter
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
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
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole, England
Status: Offline
Points: 8028 		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.
Find Web Wiz on Facebook
Follow Web Wiz on Twitter
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: Poole, England
Status: Offline
Points: 8028 		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.
Find Web Wiz on Facebook
Follow Web Wiz on Twitter
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
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



Become a Fan on Facebook Follow us on Twitter Web Wiz on Google+ Community Forums Web Wiz Blogs Web Wiz News
Company Information | Contact Web Wiz | Terms & Conditions | Privacy Policy

Prices exclude VAT unless otherwise stated - $, € prices shown as a guideline only
Web Wiz Ltd, Unit 10E Dawkins Road Ind. Est, Poole, Dorset, UK, BH15 4JD
Copyright ©2001-2012 Web Wiz - All rights reserved