7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Anyone Using MySQL on Windows Hosting?

by scriptkid
6 replies
Hey Warriors,
I needed your suggestions. I am planning to build a site in asp.net.
I am not comfortable with MsSQL as the backend database platform. Instead I am installing an plugin for Windows Visual Studio Ultimate which enables MySQL connections.

So I am wondering if this would turn out to be a problem when I deploy it on the server ?


If I had Windows Hosting, I would have tested it. Unfortunately I am currently on Linux Hosting.

Thanks
~SD
#hosting #mysql #windows
  • Profile picture of the author seopanther
    Yes I am using mysql on windows hosting and i dont face any problem as I have get hosting from local server and their support is helping me with it
    {{ DiscussionBoard.errors[5128015].message }}
    • Profile picture of the author scriptkid
      Thanks for replying.. But I dint get you exactly what you meant by this
      Originally Posted by seopanther View Post

      get hosting from local server
      {{ DiscussionBoard.errors[5128142].message }}
  • Profile picture of the author James90210
    MySQL has a windows installation. Many windows hosts include it in their standard package.

    All you need to do is make sure you have the server name, username and password set up in your MySQL for .NET connector.

    It is a proven connector, so you shouldn't have to test it. Just plug ang play.

    Make sure you make the project reference to the MySQL connector to keep a local copy. That way when you deploy the site, it will keep a copy in the bin folder and everything will work.
    {{ DiscussionBoard.errors[5132771].message }}
    • Profile picture of the author scriptkid
      Originally Posted by James90210 View Post

      MySQL has a windows installation. Many windows hosts include it in their standard package.

      All you need to do is make sure you have the server name, username and password set up in your MySQL for .NET connector.

      It is a proven connector, so you shouldn't have to test it. Just plug ang play.

      Make sure you make the project reference to the MySQL connector to keep a local copy. That way when you deploy the site, it will keep a copy in the bin folder and everything will work.
      Thanks for the information. I have already installed MsSQL 2008 on my local server. But I have the database in MySQL. There are about 103 tables in the database & about 70k+ entries. I find it difficult to move this database from MySQL to MsSQL.

      That's the reason I was preferring to use MySQL for this project.
      {{ DiscussionBoard.errors[5145728].message }}
      • Profile picture of the author tinyraysite
        Its easy to use MySql with ASP.NET. Please refer this post (hxxp://forum.tinyray.com/viewtopic.php?f=211&t=163) for how to asp.net with mysql. The connector DLL was compiled so that you can run your web application on any hosting service, including GD shared hosting.
        {{ DiscussionBoard.errors[5150880].message }}
  • Profile picture of the author ashmetry
    I've worked for years with ASP.NET, PHP and both MYSQL and MSSQL... why are you not comfortable with MsSQL. I would highly recommend you sticking with MSSQL if you are going down the ASP.NET route. If you are doing PHP then definitely MYSQL.
    If it's a learning curve then take the time to learn it...it's worth it for the long run. MsSQL Express is free and can be downloaded from here:
    Free Database Software | Database Applications | SQL Server Express
    {{ DiscussionBoard.errors[5143947].message }}

Trending Topics