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?
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?
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...
I have created some of my tables also ....in ASPNETDB ..
In my local PC the site was running fine ...
But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
My hosting provider connection string ..
<add name="ConnectionString" connectionString="Data Source=69.16.253.19;Initial Catalog=usa_data;Persist Security Info=True;User Id=user;Password=pass" providerName="System.Data.SqlClient"/>
My hosting provider gave me the connection string to connect to the SQL Server 2005 but it doesn't work...
I don't understand why my site was running fine using the production SQL Server 2005 in my local PC when I include ASPNETDB.MDF file in App_Data in my local pc only ..if I remove file ASPNETDB.MDF from App_Data of my local pc ... the site stops working ...
Can anybody tell em how to fix this ... !! I am very tensed since last 3-4 days
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 RepliesMy 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.
I'm getting an error in Parallels Plesk for SQL Server database on restore the cause of which is a mystery to me. Here is the support ticket I sent my hosting company:
I'm in the process of restoring my databases and the first one restored just fine. The second one called ***** for *****.com failed with the following error:
Error: dbbackup failed: Unable to restore database 'alienreports' Not valid backup The media family on device C:WINDOWSTEMPlocalhostalienreports*******.bak' is incorrectly formed. SQL Server cannot process this media family. VERIFY DATABASE is terminating abnormally.
This happened both when using the .bak file from my old host and after restoring that file on my local machine using SQL Server Management Studio 2008 just fine before backing it up and getting the same error when trying to upload and restore.
this is my 1st time uploading any database to Host Server. I have purchase DiscountASP's domain and MS SQL 2005 database addon. I can make my website to copy to DiscountASP's domain using the Visual Web Developers copy website wizard and it works great.
Now i have a database in my website which i wanna upload to DiscountASP's MS SQL 2005 database that i have bought, but i dont know how to upload it and then how to make the connection between my Website and the uploaded database. Is it that i have to copy the website(containing app_data folder containing database) to the host and it will work, or i need to copy the database separately and then make a connection in my website and then copy the website?
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;"
;
I have few questions regarding MySql database.
First one will be: I've installed MySql, Query broswer, and ODBC connector (not sure what this one does. Can anyone explain?)
Now, when im dragging a new DataGridView into the form, and try to connect it to a MySql database, i can't seem to find MySql in the databases list... why is that?
Second question, assuming everything works fine, how can i upload the database to a server and use it there?
I can think of two problems trying to do this : (1) Im not sure where my Database files are stored at... (for some reason, they are not found in MySql/Data... this folder is completly absent)
(2) While working with ACCESS, all i had to do is to point the .aspx page that did the connecting to the location of the .mdb file, but now, each time i want to reach my database, i need to send the page to the server (localhost). How will i create a connection to my database, when its on another server, in the code page ? (small code example would be nice).
I have built a website using Visual Studio 2008 asp.net 3.5, and data is retreive from a database that is made by SQL Server Management Studio 2008.
The question is: How can I upload the database files to the server? Can you give me a step by step description?!
I am sorry to ask this general question. But I could not find any comments sharing about real world experience when it comes to uploading photos. I knows a little bit about uploading photos to SQL database. One is uploading the photos insidea folder and the link to the photos will be stored inside the imagemap (not sure about this datatype??) column and perhaps the other way is to store the photos inside the database itself. Which one is the common and best practice?Any links that I can refer to?
View 2 RepliesFirstly, here is the software I am using locally (which runs my program perfectly): vista home premium sp2vs2008 sp1sql server 2008 enterprise edition sp1iis 7 The server is using: sql server 2008 enterprise edition rtmiis 5.1 I encountered a problem days ago that I have so far been unable to fix. The project runs an asp.net web app perfectly locally. However when I uploaded the solution and the database to the server, it will not connect to the database.
I get the following error:
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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error: The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts. I thought that the problem was the connection string so I changed the connection string locally to connect to the server database, and it works. But whatever I try I cannot get the program to connect to the server database from the server's wwwroot.
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 RepliesI'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
View 4 RepliesI have one IIS entry with AppPool integrated mode. There are 5 or more host headers assigned. The application pulls data based on the host name from Request.Url.Host. When I have 2 or more sites open at the same time the value of the Request.Url.Host is the same across all the sites. About every 30 seconds it resets itself to the correct value from the last request and shows that value on the other sites. So ultimately the sites are loading the same data. The value in the HOST server variable is incorrect as well.
View 1 Repliesin my application i am uploading the image into database. before it is store in the database, i want to do image management like decreasing size and decreasing height and width of the image.
View 4 RepliesI am able to upload an image to a Database from a fileupload control on a detailsview inserting event and then display it again. Here is my code to upload an image from a fileupload control:
Dim UploadedFile2 As FileUpload = CType(DetailsView1.FindControl("Fileupload2"), FileUpload)
Dim extension2 As String = Path.GetExtension(UploadedFile2.PostedFile.FileName).ToLower()
whether *.mdf database file work if host it in my domain. and also give me any free asp.net hosting site
View 1 RepliesI'am Developing a commercial website using vs2005 and sql 2005,where my users will download and upload wallpapers and ringtones,so my issue is, i got the coding for uploading ,
But the problem is it is storing the files two times,
If FileUpload1.PostedFile IsNot Nothing Then
Dim FileName As String = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName)
FileUpload1.SaveAs(Server.MapPath("Images/" & FileName))
[Code].....
Is it true that ASP.NET and IIS hosting is more more expensive that PHP and Apache? Say I want to host a dedicated server, then will the difference be that big?
- Another thing, do I really need a license for SQL Server database and IIS or something like that when I pay for a company for the dedicated server or they will pay that?
I have heard of the pains of setting up IIS. On a windows box, can I simply drop a ASP.NET application into Apache server and have it work? Or are there any other server alternatives? I am relatively new to web server concepts. I have heard suggestions for the server in mono but it doesn't seem practical using mono on a windows box, I could use a Linux box with mono, which wouldn't surprise me if it worked better then a windows solution, but for arguments sake this question is directed towards a windows box.
View 2 RepliesI have some code that allows users to upload file attachments into a varbinary(max) column in SQL Server from their web browser. It has been working perfectly fine for almost two years, but all of a sudden it stopped working. And it stopped working on only the production database server -- it still works fine on the development server.
I can only conclude that the code is fine and there is something up with the instance of SQL Server itself. But I have no idea how to isolate the problem.
I insert a record into the ATTACHMENT table, only inserting non-binary data like the title and the content type, and then chunk-upload the uploaded file using the following code:
[code].....
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.
What is the efficient way to upload excel data to sql database?excel file consists of 4000 rows..so i need to save these records to sql database in web application,i know only by creating ODBC connection i.e
_path = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + _path;
OdbcConnection _xlsConn = new OdbcConnection(_path);
_xlsConn.Open();
OdbcCommand _xlsSelSht = new OdbcCommand("Select " + columns + " FROM [" + _sheet + "$]", _xlsConn);
OdbcDataReader _xlsReader = _xlsSelSht.ExecuteReader();
while (_xlsReader.Read()){.....}
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]...