mySQL, what do you think?
-
Can some tell me about his experience using mySQL with .NET? what are the advantages and disadvantages? any limitations or restrications? I want to build a corporate application which will have a network access as well as remote access and I'm planning to use mySQL because of the limitation inb MS Access and SQL server with MSDE. Many Thanks, Jassim Rahma Jassim Rahma
-
Can some tell me about his experience using mySQL with .NET? what are the advantages and disadvantages? any limitations or restrications? I want to build a corporate application which will have a network access as well as remote access and I'm planning to use mySQL because of the limitation inb MS Access and SQL server with MSDE. Many Thanks, Jassim Rahma Jassim Rahma
You should really only post things in one forum. Pick the one suited to your post the most and then stick with it. However, I will tell you that dealing with mySQL in general is a pain for any form of Windows development. The myODBC driver that comes along with it is such a bother to configure. If you already have it, I'd stick with SQL Server. If not, I'd go with MSDE (a scaled down version of SQL Server).
I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past. -Chris Maunder Microsoft has reinvented the wheel, this time they made it round. -Peterchen on VS.NET
-
Can some tell me about his experience using mySQL with .NET? what are the advantages and disadvantages? any limitations or restrications? I want to build a corporate application which will have a network access as well as remote access and I'm planning to use mySQL because of the limitation inb MS Access and SQL server with MSDE. Many Thanks, Jassim Rahma Jassim Rahma
Disclaimer: Although I use MySQL, I have not used MySQL with C# That being said, MySQL does have an ODBC driver at www.mysql.com and there is a supported version (via MySQL AB) although you will have to ask for a quote, since in a corporate edition, this can get quite pricy. ... and my experience with C# and ODBC is quite good. Regards, Adrian
-
Disclaimer: Although I use MySQL, I have not used MySQL with C# That being said, MySQL does have an ODBC driver at www.mysql.com and there is a supported version (via MySQL AB) although you will have to ask for a quote, since in a corporate edition, this can get quite pricy. ... and my experience with C# and ODBC is quite good. Regards, Adrian
then, do you recommend mySQL for corporate application, or let me ask it the other way: which database you recommend for corporate if not MS Access and MS SQL server? Jassim
-
then, do you recommend mySQL for corporate application, or let me ask it the other way: which database you recommend for corporate if not MS Access and MS SQL server? Jassim
Thats a good question. Since I am a consultant by day and programmer by night, I'll put my consultant hat on for you. For small deployments, it really doesn't matter what you choose. I would recommend SQL Server simply because of the ease of deployment. For larger deployments, where performance becomes an issue (and this point is dependent on the application and the environment), I tend to recommend Oracle. For web deployments where the data is not as critical, or other programming languages (such as PHP or Perl) need to get involved, I tend to recommend MySQL. I say "tend to" since I sometimes come across sites which already have a database in place, and that would have a bearing on the overall cost of the solution. -Adrian