MySQL and .NET

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tim Mulholland (TimMulholland_at_nospamaddress.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 10:37:47 -0500

My company is considering scaling up a database application that previously
used Microsoft Access. The database has about 25-30 tables in it. The amount
of daily transactions to the database is fairly small for that number of
tables, but is growing.

The web application that uses this database is written in ASP.NET/C#. Our
hosting provider has MySQL available on the servers, so that seems like the
logical choice to use.

I have heard however, that there are some problems in connecting to a MySQL
database from .NET. I tried to dig up some of the things i heard about it,
but i couldn't find any. I do however see alot of potential ways to connect
between the two (the mysql website lists many: MyODBC, dbProvider,
MySQLNetProvider, MyOLEDB, MySQLDriverCS, and the one from ByteFX to name a
few).

Are there problems with connecting between the two? Or am i just imagining
that i read that somewhere? Whats the best way to connect between the two?
Use the native ODBC provider? Or use one of the many listed on MySQL's site?

Any thoughts are appreciated. Thanks in advance,

Tim

Relevant Pages

  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)