Configuration :: Deploying A Website With A SQLExpress Database
Jun 6, 2010
I have just developed a website with VS 2008, ASP.NET 3.5. It contains a long range of pages and one contact page. The contact page is connected to a SQLExpress database, where details about all the visitors' requests are stored. The website works fine at the development environment, but when I deploy it to the internet host, the Contact page will not open any longer, due to all sorts of problems with the database. I have the database files located in the App_Data folder under the main directory for the website.
I have tried with all kinds of connection strings, setups, etc. - to no avail. I have also tried using the ISP's tool for creating a new database with the intention of copying the original database to it. But when I use the Publishing Wizard and generate a SQL script, then the Web Administration Tool for the remote database won't run the script. Now my question is, plainly: Is there any step-by-step procedure I can use, if I want a data-enabled website. It seems incredible that it has to be so frustratingly difficult. Basically, what I need, is:
* A database, located in the App_Data folder, to store all information received via the Contact.aspx page.
* All visitors of the site should be able to post messages on the Contact.aspx page.
* I have got the information from the ISP that I can connect to MSSQL via the server "host55.nethotel.ccSQLEXPRESS".
If a general procedure can be advised, and some directions about how exactly the database should be set up with authentication, rights, etc., for such a - supposedly ordinary - system, then I will be grateful for any information - or somebody who could point me in the right direction of a solution.
View 2 Replies
Similar Messages:
Mar 3, 2011
On my local machine I have created a database driven website. All is working well on my local machine.
Now I want to upload it to my Arvixe Hosting. How do I do that from Visual Studio 2010 Keeping in mind I have a Database too ?
Do I need to manually create a Database on the Server ? Do I then create all the tables Manually ? Do I then populate the tables manually ? Or is it a 1 button click ?
View 10 Replies
Sep 30, 2010
Current Web.Config
View 4 Replies
Mar 23, 2011
I created web form which gets data from local database (SQLEXPRESS). It gives me an error when I publish the website. I can upload regular aspx page into my site. It works fine. How can I publish data-driven web form into my website?
View 8 Replies
Jun 29, 2010
I made a simple network tool using Visual Studio 2010 Express, ASP.NET C#.
When I finished, I deployed it to a Local IIS 5.1 Server. I'm running XP(BTW).
The situation right now is that every time I add/change something to suit my needs, it changes it directly on the server - which is obviously unwanted. I want to understand why this is and how to change it. I don't want every test I do to be implemented directly on save.
ps.
On Project->Properties, Web tab. I verified that under the "Servers" option, "Visual Studio Development Server" in checked and not "Local IIS Web Server"
View 4 Replies
Aug 31, 2010
I have my Website Application [URL]. How is it deploy my site to web server [ IIS ] so that it can be accessed via intranet.
View 1 Replies
Dec 9, 2010
so I have a fully functioning DynamicData website, and all works fine when debugging in VS2010But when I moved the site to a webserver (server 2008, IIS7) the default paeg comes up, but any links or pages after that are all sending 404 errors http://{IP address}/{table}/{action}.aspxdoes not work when on the server, but works fine in VS.What configuration am i missing from IIS7 to make this url work?
View 1 Replies
Jul 9, 2010
I'm deploying a web site to a server I've set up for testing. The website works great in development (Running in VS 2010) as well as in production on multiple client sites. I'm simply trying to test the site in a new environment. I simply copied the complete site (pages, code, directories, everything...) to my server. In IIS7 I created a new web site pointing to the directory containing my site's files and directories. I can open my site and my initial login page loads.
Database connections are made, page and buttons all seem great. Then, I log in. In the first line of code that attempts to instantiate an instance of a class contained in my App_Code folder, an exception is thrown, 'Invalid object name'. I've messed with as many settings as I could in IIS7 but to no avail. I've searched the internet on something regarding this, but nothing seemed to apply. At this point I'm about ready to install Visual Studio on my server to get it to run (this was the route one of the other developers took).
View 3 Replies
Aug 14, 2010
I have attempted to deploy my first WEB application and needed to include the Membership for Internet login. Application works fine when I use Visual Web Developer, but when I deploy to my provider when I attempt to Login, I eventually get the error message (this was after I turned on the debug="true" - full message is
[Code]....
When I copied the application to the WebSite, I assumed that the ASPNETDB.MDF needed to be copied too with everything that I defined for users and roles. Looked at the WEB.CONFIG and expected to see something defined here as to where it is located, etc. Do not see anything in my project with the name.
View 3 Replies
Aug 10, 2010
I'm about to roll out my web site soon, and was just wondering if there's a way to roll out the db I'm working with on my dev computer, or if I have to recreate everything on the production server. If I can roll out my dev db, will the uids be the same?
View 1 Replies
Aug 16, 2010
first here is my connection string:
"Data Source=tcp:sql2k803.discountasp.net;Initial Catalog=SQL2008_736225_aldookandb;User ID=SQL2008_736225_aldookandb_user;Password=******; "
note that i can successfully connect to the db using the user 'SQL2008_736225_aldookandb_user' when i use a remote connection tool, such as sql server managment studio
And you can reproduce this problem, see it live and see the stack trace by doing the following:
A) :
1.go to my website [URL]
2.login as username: Teacher1 password: 123456 (Note that you have been logged in successfully)
3. go to the link in the upper right corner where it says (Teacher Page)
4. booooom!
B):
1. go to the website and create an account as a "Teacher"
2. do steps 2 to 4 from above and same problem occurs
View 1 Replies
Jun 8, 2010
I have a web site that has always run fine for years and years under 3.5. I converted it recently to run under 4.0, and it runs on Cassini fine. When I attempt to deploy the app to an IIS7 server that has 4.0 installed, all I get is "internal server error", and no error messages in the Event log, and nothing in the http logs.
I've double checked that the application pool I've deployed to is running 4.0.
It's an x64 web server and app (always has been while it was under 3.5.
View 5 Replies
Sep 10, 2010
I have developed a website using visual studio. Now i want to deploy the same on server having windows server 2008 o.s. and IIS 7. When i copy the website and paste it into wwwroot folder of iis its not working. What settings need to be done so that website can be accessed from iis.
View 2 Replies
Apr 19, 2010
i've written a small application using asp.net and sql server express.
my question is after checking the application in the visual studio environment how can i get it to work in a way that
users that are working on the same network as me could use it to?
i've changed the user instances option in the web.config file to false, and from the info i found so far i understand that security measures are to be applied, but i just couldn't get it to work...
View 2 Replies
Aug 12, 2010
i have created a website in vs 2008. and i want to deploy that website on other system. i don't want to give all the source(just like .exe file not source).
View 4 Replies
Jan 17, 2011
I get another error message regarding SQL database.In my project, the database for membership and roles is under App_Data, plus another DB data i created. both DBs are .mdf"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)"I have my web hosting from GoDaddy, do i need to configure anything there? or is it something to do with my web application?This is my connection string in web.config:
[Code]....
View 4 Replies
Jul 15, 2010
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
View 3 Replies
May 4, 2010
I am using XAMPP to publish my a .net application. The server is working fine. I created a sample login.aspx file, and it works fine. I deleted the sample login file, and I build and copy all the files to the XAMPP directory. When I tried to acces the page, it gave an error message "Access forbidden! You don't have permission to access the requested object. It is either read-protected or not readable by the server. If you think this is a server error, contact the
View 8 Replies
Mar 30, 2011
Apologies if this is is in the wrong place but I'm not sure where this issue fits. My issue deals with setting up an ASP.NET 64bit website on IIS6 (W2003 R2) so it could be a compiling problem or an IIS setup issue - I've read so much now I'm all tied up in knots.I have a web app which has been written on top of my company's custom framework, both have been compiled in .Net 2.0 with the "AnyCPU" option and run quite happily on my laptop within Visual Studio 2008 (on a Windows 7 Enterprise 64bit laptop). All of the code is managed code with the exception of 1 3rd party dll that I think is still 32bit.
Question 1: when running on my laptop in VS, is my web app running in 32bit or 64bit mode, given the OS is 64bit? I have both versions of .NET 2.0 installed.I have a new desktop that is to be our test server, and has been installed with Windows 2003 R2 and had IIS6 configured (same as the production environment). Again, both versions of .NET 2.0 are installed. When I copy my web app to the server and browse to the site, I get the dreaded "%1 is not a valid Win32 application", and sometimes (depending on what settings I've been playing with) "Service Unavailable" messages. If I register the .NET version to 32bit, and set the IIS 'Enable32bitAppOnWin64' to true, the app runs happliy the same as when on my laptop......but I don't want it to do that! I want to run IIS to run in 64bit mode with the 64bit .NET 2.0 Framework!Question 2: What does IIS see to make it think that my app is a Win32 app or am I interpreting that message wrong? Is the fact that I have 1 32bit dll in the in folder enough for IIS to say "32bit" and keel over?
My understanding of the "AnyCPU" option was that as long as the code is all managed code within the application, the bitness of the OS does not matter so I cannot understand why IIS6 cannot run the app in 64bit mode....and no, installing IIS7 is not an option.
View 3 Replies
Feb 25, 2010
I'm running windows 7, so I installed on my machine the oracle client version 11.1.0.7.0 (ODP.NET - Oracle.DataAccess version 2.111.7.20) .
I'm trying to deploy an asp.net web application to a server that is running windows 2003, which has the oracle client version 11.1.0.6.0 (ODP.NET - Oracle.DataAccess Version 2.111.6.20)
In my web.config file I have:
<add assembly="Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
(which for my surprise it compiles just fine).
Now when I compile my application and deploy it in a setup project (as pre-compiled). The start page of my web app tires to connect to Oracle and it returns the following error message:
"Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."
Which is super weird because, cause the web.config file as shown above has Version=2.111.6.20.
Now the strange part is that if I copy the source code from the client to the server, the same code, same config file, it works just fine.
So I'm thinking that the pre-compiled version is telling the server to load Oracle.DataAccess Version=2.111.7.20, maybe in one of the dlls, not in the config file for sure.
Has anyone run into this problem?
what's the best approach to deploy to servers with different oracle client version? (I have a similar problem trying to deploy to a 64 bit machine)
View 2 Replies
Jul 11, 2010
I would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.
Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262
View 6 Replies
Mar 30, 2011
I added "MvcMusicStore.mdf" to my project. I corrected my connection string in web.config. [Code]....
How do i create DB in my ./sqlexpress because when i look it with SQL Server manegment studio,
i don't see the database and the tables that are created in my mdf file.
View 3 Replies
Jan 28, 2011
When we create or install any database using Visual Studio - The database gets saved in SqlExpress instance.How I can see the list of all the database that are ins SqlExpress and how to delete any of those database?Is it possible using DOS ? I don't have SQL Server Management studio
View 6 Replies
Jul 23, 2010
I designed SqlExpress database for online store ( Asp.net).And these is tables
Department Table:
dep_Id (PK)
dep_name
dep_description
View 3 Replies
Aug 7, 2010
this has to be the longest day of my life!!! have been trying to fix this for 2hrs now!
I have installed on my machine the following:
1. VISTA Enterprise (UAC turned off)
2. MICROSOFT VISUAL STUDIO 2010 ULTIMATE (Visual Web Developer 2010)
3. MICROSOFT SQL SERVER 2008 R2
4. INTERNET EXPLORER 7
5. .NET 3.5 SP1
I have an web aplication and I am trying to attach a database to my App_Data folder and it gives me the error as discussed...
I have tried everything to changing the permissions of (sql, vs2010) folders and the owner of the folders to me. But I cant still attach a DB.
View 1 Replies
