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]

"Flip" <[remove]ph******@hotmail.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

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,

--
Vjekoslav Babic, MCSA, MCDBA

"Flip" <[remove]ph******@hotmail.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

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.

[DalePres]

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

Dale
"Vjekoslav Babic" <[e-mail]> wrote in message
news:OA**************@tk2msftngp13.phx.gbl...

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,

--
Vjekoslav Babic, MCSA, MCDBA

"Flip" <[remove]ph******@hotmail.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

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.

[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
"Flip" <[remove]ph******@hotmail.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

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.

[Vjekoslav Babic]

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

Dale

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

Cheers,

--
Vjekoslav Babic, MCSA, MCDBA

[Flip]

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