I have an ASP .net Web Application already deployed on my local machine (virtual directory/IIS are configured). I used the Publish tool from Visual Studio. Now I want to move it to our Webserver (I have the IP adress and the appropriate credentials).
EDIT By the way, I'm asking because I don't know if there is a specific way to do this? I can do it manually by moving the files to the remote computer and configure IIS approriately.
I am rather new to asp.net but I have built a couple of apps that do not require users to login. am having some problems moving my secure .net application from my laptop to a production server, however, and I am hoping someone can help me. On my laptop my application's user authentication functions as it should, but when I move my application to a webserver I get an assortment of errors. Forgive me if these questions are a little basic. My first question is this. In a production environment do I move the ASPNETDB.MDF file in the App_Data folder to my SQL server? Is it OK to rename it to something more descriptive?
View 4 Replies[Code]....
i want to get data from database of field Name and Gender, and then display it in Label name and gender. when i click save it move to next record and display name and gender that next record.
I am new to cloud computing, so please bear with me here. I have an existing ASP.NET application with SQL Server 2008 hosted on a Virtual Private Server. Here's what it briefly does:The front end accepts user's requests and adds them to a DB tableA Windows Service running in the background picks up the request, processes it and sets a flag.The Windows Services also creates a file for the user to download
View 1 RepliesOn Button Click how to move the mousecursor position in web application???
In case of windows application on button_click i have written the following code:
Point p = new Point();
p.X = 41;
p.Y = 400;
Cursor.Position = p;
This works fine & cursors position also change.
but how to do that on aspx page or in web application?
In my case also on button click i have to move the cursors position.
I need to move all requests from one domain to another. I want to change part of URL, like subdomain.olddomain/url -> subdomain.newdomain/url.
I was sure that this is piece of cake and wrote Application_Begin request as:
void Application_BeginRequest(object sender, EventArgs e)
{
string url = Request.Url.ToString().ToLower();
string from = ConfigurationSettings.AppSettings["from"];
if (url.IndexOf(from) >= 0)
{
url = url.Replace(from, ConfigurationSettings.AppSettings["to"]);
Response.Redirect(url);
}
else
{
if (url.IndexOf("error.aspx") < 0)
{
Response.Redirect("Error.aspx?url=" + Server.UrlEncode(url));
}
}
}
So far, I forget, that BeginRequest started only when file physically exist. how I can make such redirect in asp.net without creating hundreds of old pages?
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesI'm currently writing a website in ASP.NET MVC, and my database (which doesn't have any data in it yet, it only has the correct tables) uses SQL Server 2008, which I have installed on my development machine. I connect to the database out of my application by using the Server Explorer, followed by LINQ to SQL mapping.
Once I finish developing the site, I will move it over to my hosting service, which is a virtual hosting plan. I'm concerned about whether using the SQL Server setup that is currently working on my development machine will be hard to do on the production server, as I'll have to import all the database tables through the hosting control panel. I've noticed that it is possible to create a SQL Server database from inside Visual Studio. It is then stored in the App_Data directory.
Does it make sense to move my SQL Server DB out of SQL Server and into the App_Data directory as an .mdf file? If so, how can I move it? I believe this is called the Detach command, is it not? Are there any performance/security issues that can occur with a .mdf file like this? Would my intended setup work OK with a typical virtual hosting plan? I'm hoping that the .mdf database won't count against the limited number of SQL Server databases that can be created with my plan.
We have an already existing project on IIS and we want to move to Apache (windows) with mod_aspdotnet. What things could not work? If we use 3rd party DLLs? Will office components work fine (export to Excel, Word, etc). If you have any experience on this type of migration, I'd like your inputs! Also, is there another alternative to mod_aspdotnet?
View 1 RepliesHow is it possible to move files from a folder to web server through FTP, using ASP.Net with C# ?
View 1 RepliesIn my live server we have total nos of approx 200 reports and 50 email subscriptions created by us. Now we are planning to change our existing hardware configuration and due to some other reasons, now the current live server we will not use in future, In view of same we want to move our all our reports and email subscription to other new server and that new server will be our next live server.Now the problem is that i have 50 email subscription which i have created in old server so how can i move this subscription to new server? Reports can be deployed to new server by taking the backup. Is there any other concern in such situtation?
View 1 RepliesWe have two database, one is normalised A other one is not normalised B. Bu SSIS mirroring we have moved all latest data B to A. But now that is one time opersation. But B is our live database, now everyday I want that any operation occur in B should move to A.
Is there any automatic way is available if not then can I acheive this my manually?
i'm tring to connect a ql database to my website but the data r not getting added in the table..
ut when i use the query builder there the data is been added successfully when done for testing the connection.i'm using sqlserver2005 in vs-2008.
I have moved my entire project to my test server, everything went as planned with the exception of a couple of items. The main one that I'm having troubles with deals with subfolders of the website. On my local computer I created a my project then I created a sub folder, Secure, so that I can work with the security on the sub folder via ASP.NET configuration. I wanted only certain users to be able to access the folder, which works on my local computer, but when I try to navigate to it on my test server, I get a 404 error. I create two Roles on my local computer, but don't know if I'm able to make those roles on my test server. Is there a way to make those roles so that the security that I have on the sub folder will allow them to be displayed. Not certain why I get a 404 error.
View 3 RepliesI have SQL Management studio in one system. It has lot of tables, stored procedurs. I want to move that database data into another system. like taking Office database to my home. How can I do that ?
View 1 RepliesI have a Asp Application built in VS 2010, it works prefectly on my box , when I moved the code to the dev server, it gives error on a particual web page saying cannot open the database requested by the login, login failed, the other web pages in the application are also suing the same database and they are loading perfectly.
View 4 RepliesWhat is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.
View 4 RepliesProblem: I need to move a local development database to the production server without any of the test data.
I am running SQL Server Express 2008 and SQL Server Management Studio 2008.
To create my ASP.NET Membership 2.0 system I created the DB initialy and ran aspnet_regsql.exe
I then added my own tables manually to store additional information.
I adjusted the web.config file with an application name.
When I ran a sript the application ID name was created and populated in the aspnet_Applications table. My script created a new member created and added to the admin role. Ok so everything go so far.
Now I want to move the local DB to the server. I know the connection string and can change this in the web.config.
My hosting company doesn't provide restore, so I don't think I can backup and restore
Q 1. What would be the best way to move the database across. Bearing in mind I need to clean the database out of test data.
Would it be just generate an SQL Script for the database and run it as a query on the server? And if this is the best way then do I need to set the permissions for the ASPNET user?
Q 2. What is the best way to clear out the data in the local database.?
i have been creating a website on my computer which has VWD 2008 and SQL Server 2008, i have membership and role system set up, (using the aspnet_regsql) and that worked perfectly fine on my compuetr.
Now when i was ready to deploy it on my web server, i simply copied the whole database, and added it onto the SQL Server on my server, so it has exactly the same rows, tables, data, etc etc.
Now, when i run the website via the domain, users are able to login etc, and my authentication code that redirects users if they are not logged in also works, so im sure it cant be a problem with the membership provider, as it all seems to work.
But all the users that were already in the set roles, it still shows them in the role in aspnet_roles table, but its not working, the thing i have in the roles loginview does not display, and even after running the web administrator tool, it shows that the user is in that role, but does not work (even while viewing on the local machine)
So i added code in a page_load event that would auto add that user to the role
System.Web.Security.Roles.AddUserToRole(HttpContext.Current.User.Identity.Name, "TestRole");
and on entering the domain (on the local server) i got error:
The role '' was not found.
And on local host server
I get error:
The user 'TestUser' is already in role 'TestRole'.
But yet, even on the localhost i still cant see any indications that the user is in a role, as none of my rle login views are showing.
The role '' was not found.
, I've researched this quite a bit and I'm just not seeing the problem. The app runs beautifully when living on my pc - the app on my pc connects successfully to the SQL Server 2008 Express Database (which sits on a server - not my pc). However, as soon as I publish this application to the server that the SQL Server 2008 Express Database sits on, I get this error when I try to run the application:
ERROR [42S02][Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'user'
It's behaving as if it either doesn't know where the table is when the app tries to run on the same server as the database or maybe the app doesn't have permission to hit the database once the app is on the same server as the database. I have connections on my pc and the server defined for this database, I verified that I set up each connection the same. I've also tried connecting using [dbo].[user] and this doesn't remedy the situation either. my connection string is in my web.config and it looks like this:
<add name="directoryConnectionString" connectionString="DSN=directoryProd" providerName="System.Data.Odbc" />
my sql looks like this:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
connectionstring="<%$ ConnectionStrings:directoryConnectionString%>"
ProviderName="System.Data.Odbc"
SelectCommand="SELECT fName FROM [user]"></asp:SqlDataSource>
I was not able to do unit testing for our existing web site project. I converted the web site project to a web application project. I did some unit testing and changes on the converted web application project. However, my co-worker was doing UI testing on the web site project. We need put UI testing and unit testing to the web application project. Is it possible to move the UI testing code that my co-worker did to the web application project I am working? If so, how do you do it?
View 2 Repliesmoving some tables & stored procedures from SQL Server 2000, to SQL Server 2005.So far so good, but I've come across a problem with this stored procedure:
CREATE PROCEDURE [dbo].[user_insert]
@user_service_unit int,
@user_champion_1 varchar(50),
@user_champion_1_nt varchar(10),
@user_champion_2 varchar(50),
@user_champion_2_nt varchar(10),
@user_champion_3 varchar(50),
@user_champion_3_nt varchar(10),
@user_date_received datetime,
@user_requestor varchar(255),
@user_info_requested text,
@user_expiry_date datetime,
@user_10_days datetime,
@user_5_days datetime,
@user_2_days datetime
[code]...
I have a routine to display an image on an aspx page. The url for the image uses imagerender.aspx . This is simply an empty page with code behind:
myClass mysub = new Myclass(); // create class
Stream strm = mysub.DisplayImage(UserID); // call method to load bytes from db
byte[] buffer = new byte[2048];
int byteSeq = strm.Read(buffer, 0, 2048);
while (byteSeq > 0)
{
Context.Response.OutputStream.Write(buffer, 0, byteSeq);
byteSeq = strm.Read(buffer, 0, 2048);
}
Ok, this work fine when testing on my local machine, but when I move it to the live server, it comes up with an empty image box!
It looks like there must be a problem with security, maybe with ISS.
Does anyone know what changes I can make to fix this problem or what setting to change in IIS 7?
To my understanding the clinet side can only send data to the server either by get or post. so basically either through query string (get) or through body of the page (post).
So when we upload a file from client machine and send it to server, what exactly is happening behind the scenes? are we doing a post?
I'm using vs2010. I have a left column simular to a navigation area and I'm trying to figure out a way to display the FK links that appear at the end of a list as columns, in my navigation area. One thought was to place a duplicate table in the navigation area and hide all the columns except for the FK links. Is there an easier way to accomplish this.
View 1 Replies