Configuration :: Uploading Existing Database To The Host-Plesk?
Jan 14, 2011
I was trying to upload the database of my ASP.NET website. On the local machine, if I copy the database from another machine, I have to attach it through SQL Server Management Studio and then use it in the connection string like
[Code]....
My database is approx. 10 MB in size for now. If I upload it via ftp to App_Data folder, how would I have to attach this database?In Plesk, I have the option to create the database and its user (as shown in the screenshots):1) Web Applications and services-Plesk2) Add New Databaseand add new database user3) Webadmin>ASP.ET Enterprise ManagerBut this is for the new database I created. My problem is to upload an existing one.There's also a section in Plesk for ASP.NET settings (as shown below)
This has the option to change the connection string etc.I also asked my hosting provider about the method to be followed for attaching the database that I would upload. This was the reply in quote." mdf ldf files perhaps will be working at your local computer but this way database of mssql will not work on web server as on web server you will be required to create and restore your database backup file using plesk control panel.
Sample connection string for asp.net
mssql `Standard Security`:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
Server name to be used in coding: localhost Catalog/ database name , database user and database password you will be required to create your own using plesk control panelI would be really be appreciative for the steps I have to take to upload my existing database. How do I have attach it? What connection string I have to use?
View 1 Replies
Similar Messages:
Mar 16, 2011
I am creating an application on my test machine at home. It will require logins, roles, memberships etc.
Just a quick question, will there be any problems when uploading database to my host as its has all my asp.net configurations in the database? Is there anything I need to specifically?
View 1 Replies
Feb 23, 2011
i m developing web application in asp.net .Trying to deploy it.i m doing first time.I have uploaded my folder on plesk.But now hot to connect with database?How to connect physical server to database server on plesk 9.5?
View 3 Replies
Nov 22, 2010
I've been using a standard web site in Visual Studio for my site, using the Plesk file manager interface to upload files either singly or in total as a .zip file.Recently I've changed the project to a VS web application.All the documentation that I see refers to using IIS to deploy a web app; if I wanted to just FTP all the source code, I may well have stayed with web site.I've not been able to find any Plesk specific deployment info.
View 1 Replies
Oct 28, 2010
I have created a Website with some DataBase (using LINQ to SQL).
can i upload Website & DataBase at different Places like on different machine etc.
I use "CuteFtp" for upload Website.
View 1 Replies
May 11, 2010
This will be my first time trying to upload a ASP.NET site. I would like to upload my site by simply using ftp and transferring the contents of the project directory so that the site will be easy for me to make future updates. Where can I find directions for uploading a ASP.NET site via ftp? I am assuming that I will need to edit the connection string in the web.config file. However, my hosting company told me to just make a full backup of of the database into .BAK file format and upload it via FTP to your the "private" folder. Anyone have any experience with something like this and can tell me how this would affect the connection string? Can I back up the database to a .BAK file from within Visual Studio 2008 or do I have to use Management Studio? I am using Visual Studio 2008 with ASP.NET 3.5, C#, and SQL Server 2008 Express Edition.
View 1 Replies
Jul 27, 2010
I am using VWDExpress 2010 to create my application, now i have a hosting account on Godaddy, now my requirement is to upload the DB's in my project on the server at godaddy. A useful link for the same is provided here
[URL]
Now my problem is after I do all of the above ie create the test.sql file and try to upload it on the server, the query analyzer at godaddy gives me an error saying "INCORRECT SYNTAX NEAR GO" ,"INCORRECT SYNTAX NEAR IF EXISTS" ,INCORRECT SYNTAX NEAR )" ,etc
Now I am using sqlserver 2008 while the server on godaddy is sqlserver 2005.
[code]....
View 7 Replies
Mar 17, 2010
My kind webhost (1and1) royally asked me to go elsewhere to do something like this.
I have 2 sites. One of them was developed by a .Net programmer. Now I am contracted to implement a PHP site and fetch data from the .Net site.
There is an ASP.Net form that a customer fills and when they hit submit, the data gets stored in SQL Server DB. How do I also store the same data in MySQL parallelly? I cannot directly use some database connectors with ASP.Net since MySQL connectivity is not supported on 1and1 Windows hosting (biz account, no less!).
What I thought of is to publish an RSS feed of entries in ASP.Net site and routinely scrape that data into MySQL on Linux host. It is an overkill, I know. Not efficient.
View 1 Replies
Apr 4, 2010
I am about to give up debugging SMTP servers to send email... My code is the following
SmtpClient mailClient = new SmtpClient("plus.smtp.mail.yahoo.com", 465);
mailClient.EnableSsl = true;
MailMessage message = new MailMessage();
message.To.Add("aditya15417@hotmail.com");
message.Subject = "permias-tucson-contact-us";
mailClient.Credentials = new NetworkCredential("myemail@yahoo.com", "mypassword");
MailAddress fromAddress = new MailAddress(Email.Text, Name.Text);
message.From = fromAddress;
mailClient.Send(message);
View 4 Replies
Feb 8, 2011
there is broblum for uploading excel sheet when my application runing on local host but there is no problum on vs enviroment . i am using the following connection string code
strConn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + path +
";Extended Properties=Excel 8.0;"
;
View 3 Replies
Apr 20, 2012
{"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."}
I get the above error when sending email...
View 1 Replies
May 7, 2015
I am referring [URL] .... how to prevent file to replace when file with same name uploaded, as it replace old one in folder.
View 1 Replies
Nov 2, 2010
when developing in my pc , all is fine , but when upload to hosting , it show error ~
[img]http://image.love9cube.net/images/sadsadcgc.jpg[/img]
View 2 Replies
Jan 24, 2016
Currently I was done to insert data thru upload excel file. May I know, how to UPDATE the existing data using iploading excel file.
View 1 Replies
Nov 20, 2013
In my asp.net project i have a folder (folder name "Data").
I upload .pdf file and save the .pdf file in My Data folder.
In same day if i upload same name file then the previous file is overwrite without any message.
So I would like to know, how can i show a message like ("same name file is exit ,Do u want to replace it").
View 1 Replies
Mar 26, 2010
I had developed the 3 tire Web application, so i need to deploy the application to the customer public server.The public server has the Windows Server 20003 R2, how can i deploy my application
View 1 Replies
Aug 30, 2010
I have searched high and low on the internet for clear instructions on how to host an mvc 2 application in IIS but without luck. It seems to be from my research that it is anything but straightforward to do.
Imagine i create a new mvc 2 project in visual studio 2010. I want to host this locally on my own IIS server.
View 6 Replies
Jun 29, 2010
I have developed my first MVC application, which runs perfectly on my local development box.
However after publish to a server running IIS 7 I cannot get the application to work?
1. I created the application in IIS 7
2. Changed authentication to use Forms Authentication instead of Anonymous.
But this exception is generated - shown in browser:
[code]...
View 1 Replies
Jul 9, 2010
I've followed this link [URL] to configure my application on iis7.
- I've published it
- create a folder in inetpubwwwrootMyApp
- I've created my virtual directory to point on MyApp
but then to log on it, I need to point on http:\localhostMyApp but i would like to point on http:\localhost
View 1 Replies
Dec 18, 2010
I want to publish my project, and upload it to my host but I don't know how to to do that to convert my codes to .dll to protect it ? to take a copy of my database and upload it to the host and bind it all steps needed to complete that successfully
View 2 Replies
Sep 1, 2010
I have set up a development server (Win Server 2003) with IIS 6.0. I have the .NET Framework 2.0 and 4.0 installed. My web host (where my app will run) has .NET 3.5. Will it work for me to set up my development server with 4.0 in IIS, and then create a new website in Visual Studio (2010) that targets the .NET 3.5 framework (aimed at my development server)? want to be able to publish the site to my web host (with .NET 3.5).
View 2 Replies
Aug 14, 2010
i have a web application in which i have a emailing module. in which i am currently using gmail smtp host but i need to allow any or all smtp host account to be used for sending emails like yahoo , hotmail etc.
for sending a mail i need to have port no , .Host, and .EnableSsl there r many many smtp host used for emailing . how do i configure my emailing modue to accomodate all the possible smtp host and set their host , port & enable ss1 so that any one using the emailing module can set their smtp host and use the module for emailing
View 1 Replies
Mar 15, 2010
I've just signed up for a MaximumASP MaxV virtual server hosting account. I can remote desktop into the box and am wondering how to configure it to host my website. I do not want to enable any features which I don't need. All I need is to be able to run an ASP.Net 3.5 Web Application, SQL Server 2008 & URL re-writing. What is the minimum set of windows features I need to enable? In what order should features and programs be installed? How will I deploy and configure my web app? How do I configure multiple domains to point to my application?
View 1 Replies
Jun 8, 2010
can u plz tell me how can i publish my web pages to host it on registered website?
View 2 Replies
Aug 28, 2010
i have a site on internet. last week i work on that site at my work and there is no problem. now today i try to connect my database on the host ş got error.The error is:
An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft Sql Server, Error:53)
i am using sql server 2008 my operating system is windows 7.what can be the problem in my local? i enabled both tcp and named pipes also i start sql browser but it is failed again
View 2 Replies
