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

[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.

 

[Mark Rae]

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?

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...

 

[Vjekoslav Babic]

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,

 

[DalePres]

Why not use MSDE? http://www.microsoft.com/sql/msde/downloads/download.asp

Dale

 

[William Ryan [eMVP]]

Yes, and there if you check out http://sourceforge.net/projects/mysqlnet/

Or
http://www.mysql.com/articles/dotnet/

YOu'll find a lot more info

 

[Vjekoslav Babic]

Why not use MSDE?
http://www.microsoft.com/sql/msde/downloads/download.asp

Dale

Because it is not MySQL - it is quite a different technology. Check it out
at http://www.mysql.com/.

Cheers,

 

[Flip]

Thank you to everyone who responded. Thank you for your clarification and
help! :>