Most Efficient Way To Update A MySQL Database On A Linux Host With That Of .Net Form On Windows Host?
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.
I 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.
I have encountered this problem before on a few shared hosts but cant remember the fix. I have spent almost 2 days googling and I have even gone through 2 external hd's of backups of old projects and read the web.configs but I just cant put my find it and I dont think I am googling the correct terms...
I am using Mysql Connector/Net to store asp session state.
The mysql db is on the hosting server ( I have no mysql locally).
Opening a page locally creates a session in the db.
Opening a page on the host does not.
I have seen this issue before but was a long time ago and I have searched a few of the answered questions here but not too extensive, I'm sick of searching.
I running MS-Access desktop application, i would like to host it to web through ASP.Net (Only report purpose). regular data we keying in through desktop. is it possible for host through crystal report?
I have problem of accessing my website created using visual studio on my local pc. the pc using windows 7 with static ip address has been configured and i have added a hostname "192.168.0.1 hosts myweb.mylocal.com" on c:windowssystem32driveretc. on the IIS i have configured the binding myweb.mylocal.com with impersonation set enabled and windows authentication is enabled.
the user login just keep prompting eventhough i have entered the correct username and password.
I have created three basic websites using VS2010 and they are working fine when invidually run from visual studio. But in order to get the full functionality of the websites, they have to be run simultaneously. There are iframes inside one contaning pages from other website.
What is the way it can be done? Is hosting the only solution to it? If so please tell me how to host them in IIS7( i am currently running on windows 7 release candidate)
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'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.
I have Connector/NET working on my windows 2008 web server. We are moving the MySQL DB from localhost on that windows 2008 server to a new Linux server. The tables are copied over. I can connect to them in the cmd line using all the same credentials.
When I try to connect via my ASP.NET application I get the ambiguous Error:
"Unable to initialize provider. Missing or incorrect schema."
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
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.
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
protected void Button3_Click(object sender, EventArgs e) { //Create a connection to the database MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********"); //open the connection conn.Open(); //MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie) MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn); // Update with new text cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value); cmd.Parameters.AddWithValue("?Information", TextBox1.Text); cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text); cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text); cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text); cmd.Parameters.AddWithValue("?Adress", TextBox5.Text); cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text); cmd.Parameters.AddWithValue("?Ort", TextBox7.Text); cmd.ExecuteReader(); conn.Close(); RefreshProfile(); }
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I want to start a new project I need performance as well as a neat and robust GUI
about the performance I have around 2 millions documents which I like to index'em by the help of lucene installed on linux due to its performance and security.
and about GUI I'd like to have flexible and professional look website and since I'm experienced with .net I'd like to retrieve the lucene's result and show it in my own way.
I've heard about some RESTful services available inside the lucene but I don't have any clue according to that and how to connect these two together.
I have an excel file which gets updated every 10 seconds through an automated process. I need excel data to be updated in MY-SQL database which is located on a remote server.
How do I do that?
I have thought of following option: 1) Every 11 seconds, an Excel macro will run and will "Save as" excel as CSV file. (not sure whether this can be done by macro...just thinking) 2) This CSV file we will FTP to remote server using Windows Service. 3) On remote server, we will parse the csv file and Update MYSQL database.
Is this approach fine? Or do you have a better approach which requires less time to update the database?
I have a Wordpress blog on GoDaddy. I originally had it using "Windows Hosting" but ran into problems so moved it to "Linux Hosting" since I was told it was more compatible and there would be fewer issues. I had a 3rd party customize the blog and add some code, etc. I would like now to use WebMatrix to continue customizing the blog on my own, and be able to step through code and add php etc. So my questions are these. Will Webmatrix work in this scenario --- Linux Hosting and processing PHP? Or do I have to move my blog onto Windows Hosting so that it uses IIS? And second...what would I have to do...FTP down my wordpress files as well as my database in order to use Webmatrix?
I'm want to run a "background job" in my ASP.NET application (periodically, as separate thread). And I need host name (DNS name or IP) to do my tasks. The problem - HttpContext.Current may be not available here (it's NULL).
Is there any way to get a host name in not using HttpContext.Current.Request.Url.Host.
I have a website has already hosted on EasyCgi (suppose that it's called website1). I have to host another one (website2). So I created a folder called "website2" under the website1 root folder. then I FTP all the content of website2 to the "website2" folder.After that, I tried to request the URL: and nothing happen...Just an error page display that contains:
Im hosting my site over at some ISP, and when i try to use INSERT or UPDATE procedure, i get this error : "SELECT command denied to user 'KidumMac'@'localhost' for table 'proc' "Which is really wired for two reasons:
A. In my code i don't reference whatsoever to the MySql databse, nor the "proc" table B. In the myPHPadmin program the queries work just fine. Any insights?
the second problem is that when i try to import my database, the tables import fine, but when it gets to import the stored procedure, it tells me that the user needs SUPER PRIVILEGES for that. what is it ?
Not sure if this is the right forum area for this question, so feel free to move it where it needs to be.I have a client that has asked to move an existing ASP-based website to a new web host. I've done host transfers before, but never an ASP-driven one.
So my questions are: - Is there a way I can download the whole site as it exists and "test" it on my local machine somehow? (without having to install IIS preferebaly, it might already be installed to be honest)
- I'm sure the website uses a database back-end as it uses a CMS. What issues will I run into with regards to getting an identical database created on the new web host?Thanks all. I'm not feeling good about this transfer for some reason, mainly because I'm not that fluent with ASP, so if something doesn't transfer smoothly, I'm scared I may not be able to "fix" it in a timely manner.
