Publishing Website And MySQL Database?
Dec 5, 2010
This is what my website looks like:
When I build the website and upload everything as it is, I get this error:
Quote:
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 guess I have to deploy Database, or?
View 10 Replies
Similar Messages:
Jan 21, 2011
To start, I am a new web developer. I have been writing C# for about a year, but just recently learning web development. I wrote an application that connects to a MySql database and when I run it on my localhost it wokrs great! I created a ubuntu server on amazon ec2 and it is hosting my MySql server. It is up and running just fine. I created a windows 2008 server instance on amazon ec2 to host my asp.net project. I published my project to my windows server and I went to my public IP address and my site was there! it was so easy...
However, when I went to login, I recieved this error: Could not load file or assembly 'MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified. I made sure the correct connector was installed on ym server. I have the most recent mysql connector installed. I do not know how the publish actually works. I saw some forum posts that said maybe I was missing DLLs from my bin directory but I cannot even find my bin directory for my project on the server. I also saw some posts about changing the web config file, but that was gibberish to me at this level.
View 3 Replies
Dec 16, 2010
Why does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
View 1 Replies
Dec 21, 2010
My code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
View 2 Replies
Dec 2, 2010
if i have a separate dll for each page on my server and that is working fine. if I make some changes in code behind file of a particular page say, xyz.aspx page. then I have to upload the dll of that particular page. and that refreshes the whole web application and all sessions and other values got disturbed in the application. Is there any way that uploading the xyz.dll (of page xyz.apsx) on refreshes the xyz.aspx and didn't disturb the whole web application.
View 1 Replies
May 10, 2010
I have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
View 1 Replies
Mar 11, 2010
I hv a query regarding publishing the website. I use aspnet2.0 and for uploading we use filezilla.
Whenever I make any changes to my website (either in aspx or aspx.cs page), I need to upload the entire website (along with my bin folder, after publishing)again otherwise my site just doesnt work.Its very time consuming.
View 6 Replies
Apr 1, 2011
I have created a website with asp.net and uses oracle connectivity with pl/sql developer.i have uses the crystal report which is a third party tool. how to purchase it.
i am using visual studio 2005 and yes i am using basic crystal crystal that comes with visual studio.
Now suppose i hav purchase a domain www.abc.com.
View 10 Replies
Nov 9, 2010
I am a bigineer in the asp.net with c#. May any one help me to know "What happen to all .cs files that contain the code on publishing."
View 6 Replies
Nov 29, 2010
I am trying to move my web application from my computer to a server by publishing as a web site. But, after publishing, the user controls defined in the designer files are no longer recognized by the code behind.
View 5 Replies
Nov 5, 2012
I've published my website and tried to host in my localsystem.Im getting the login page but cannot login to my application.When i click the submit button in the login page,the page simply refreshes and comesback.The page is not showing any error like 'invalid username or password' which i've set for not proper login
I am using visualstudio 2008 and iis 5.1.What could be cause of this error ??
View 1 Replies
Jan 1, 2014
How can i pulish my website online tell me the procedure ,steps?
View 1 Replies
Aug 16, 2010
Login not working after publishing asp.net website
I am used default login control, form based authentication and default sqlmembership provider.but in local my site working fine,when i publish it locally in iis means,the login is not working , i don't know what is the reason?
View 3 Replies
Nov 7, 2010
I have an ASP.NET web site project, which I'm publishing to IIS on my Win2k8 R2 server. It has a default page called login.aspx. I set that up on the published web site.
Trouble is, every time I publish a new version of the web site, the login.aspx entry gets erased from the "Default Document" settings of the web site in IIS. This is very annoying. How can I publish my web site from Visual Studio without wiping out the default page every time?
View 1 Replies
Aug 31, 2010
I have a ASP.NET Web application which has 2 projects(one for UI and one for Business layer)Now when i publish this for deployment,its giving me so many DLLS in bin folder which starts with prefix "App_Web...."in the name.How can i make it into only one DLL or 2 DLLS (one for UI and one for BL) ? I work with Visual studio 2010
View 1 Replies
Mar 9, 2011
Is there anyway I can put my custom name while publishing asp.net 2.0 website?
View 1 Replies
Dec 21, 2010
When I try to upload my website I have created to [URL] then test it I cannot see any home page or anything. Just a list of pages etc I have uploaded, Its like im looking into a FTP server. I publish using visual studio 2010, I have tried both Copy website over to my FTP server and Publish website under the build button.
View 8 Replies
Nov 16, 2010
How to publish the website/application on localhost and what should be entered in browser while accessing it from localhost
View 1 Replies
Mar 26, 2011
The file system I'm publishing to is a not hosted by me, but by my university. IT here offers students their own web directory to host a website. My intention is to use it to host projects for classes and demo them for my professors. You can enter in a specific link in any browser to go to this website and view it as long as there is a file named 'index.html' in the directory with some presentable html code.
So here's the problem. I want my website to be written using ASP.NET and when I use VS2010 to publish my ASP.NET website to the 'File System,' I cannot simply open up my browser, type in the normal link, and have it display. It just shows up as a list of files in the directory and I can see all my source code for the web site
View 2 Replies
Aug 2, 2010
How do I exclude Web.config from server when publishing website (not web application project) in Visual Studio 2005 I can see information how to add setting to the Web.Config but in this instance the Web.config is fine on the servers; so I do not want the problem of introducing possible faulty Web.config to a live environment.
View 1 Replies
Jul 8, 2010
how i can edit Global resources after publishin web site?
View 2 Replies
Jan 5, 2011
I have published a website when is a plain page with login and CreateUserWizard control in it. I have used the "aspnet_regsql.exe" file to configure my database such that there I can see the tables like dbo.aspnet_users. I have also added a the following to the connectionstring in web.config
<connectionStrings>
<add name="ApplicationServices" connectionString="Data Source=***location of DB***; Initial Catalog=***DB Name***; User ID=***My ID***; Password='***My Password***';" providerName="System.Data.SqlClient" />
</connectionStrings>
I kept getting the "
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
" whenever I try to create user account using the CreateUserWizard control.
I am using web hosting account.
View 3 Replies
Nov 15, 2010
I come from a PHP/Rails background where deploying a website often means FTP/Checkout of the source code in the correct directory on the web server.
However, I've been asked to develop an ASP.NET website and some people have advised me to "Publish" the site instead of copying over the source code directly. Apparently, this converts the codebehind (.cs) files into compiled DLL's etc.
My application does not contain any specific secretive business logic. It's a common shopping cart app. My question is if this is a good idea? How does not making the C# code reside on the server make the app more secure?
View 4 Replies
Nov 20, 2010
In one of webforms user must enter the percent of tax and then I convert it to the float number and finally save it into database. here is a sample:
Dim txtMyPercent
txtMyPercent=Convert.ToSingle(txtPercent.text)
label.text=txtMyPercent
insert into(txtmypercent)
This peice of code, works perefect while runs via Visual Studio 2010, however after publishing, numbers are converted to integer. Thus it can't be inserted into Sql server database .... Server OS: Windows 2003 x64 IIS: 6 .Net Framework: 4.0
View 2 Replies
Jan 26, 2010
I have created a web app using Visual Studio 2008 Express Edition and have come to the point where I need to publish the site onto my server (which is running window server 2008). I found that the publish function is not limited in the express edition, so published the app to a local file and FTP'd the contents across to my server. I then setup a website through the servers IIS manage and pointed it to the folder containing the FTP'd files.
My question is, how do I run the app? Do I need to point to a specific file?
I have tried to view a number of the files in browser directly from the IIS but keep getting the same standard connection error i.e. "Internet Explorer cannot display the webpage"
I have never used IIS Manager before and I can't find a resource which gives me a step by step guide to setting up a new site which has been created by Visual Studio 2008 Express Edition, are there any config changes needed.
View 3 Replies