ASPNETDB
Printed From: Web Wiz Forums
Category: Web Wiz Hosting Services Forums
Forum Name: Web Wiz Hosting Support Forums
Forum Description: Support forum for Web Wiz Hosting services and solutions.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29257
Printed Date: 28 March 2026 at 7:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ASPNETDB
Posted By: AlexW
Subject: ASPNETDB
Date 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?
|
Replies:
Posted By: WebWiz-Bruce
Date 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:-
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
can't I run the SQL query from publishing the DB in Web Developer to get everything created?Posted By: AlexW
Date 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'?
|
Posted By: AlexW
Date 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 |
Posted By: WebWiz-Bruce
Date 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.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: AlexW
Date 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?? |
Posted By: WebWiz-Bruce
Date 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.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: AlexW
Date 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. |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |