is it possible to use MySQL as the database instead of SQL Server?

  • Thread starter Thread starter Flip
  • Start date Start date
F

Flip

Is it possible to use another DB instead of SQL Server? I don't have SQL
Server, but I do have IIS, FP Extensions as well as MySQL and would like to
use that. Is it possible?

Thanks.
 
Is it possible to use another DB instead of SQL Server? I don't have SQL
Server, but I do have IIS, FP Extensions as well as MySQL and would like to
use that. Is it possible?
Click to expand...

Yes, though I don't believe there is a native .NET data provider for MySQL,
so I believe you'd have to connect to it via OleDb or Odbc...
 
You can use any DBMS or database as long as there is an OLEDB provider or
ODBC driver, in which case you can use either System.Data.OleDb or
System.Data.Odbc namespaces.

However, you might want to check out some native MySQL .NET providers such
as http://crlab.com/mysqlnet/. It will probably work much better than any
OLEDB or ODBC drivers, which are reportedly not very reliable.

Regards,
 
Back
Top