MySQL provides connector/.NET. These are a set of classes equivalent to the
SQL classes. So, for example, where you have SqlConnection for SQL Server,
you have MySqlConnection for MySQL. As long as you have used the correct
classes (i.e. the ones from connector/.NET) the code is practically
identical. I've added the connector/.NET classes to my toolbox in Visual
Studio, so I can drag and drop them onto a design surface in just the same
way, and configure their properties.
http://dev.mysql.com/downloads/connector/net/1.0.html
Don't know about firebird. Never used it.
HTH
Peter
"Ignacio Machin ( .NET/ C# MVP )" <machin TA laceupsolutions.comwrote in
message news:eM**************@TK2MSFTNGP04.phx.gbl...
Hi,
"Alan T" <al*************@yahoo.com.auwrote in message
news:OA**************@TK2MSFTNGP03.phx.gbl...
|I am going to connect to the MySQL and Firebird database.
| Is there any differenc in the connection string format from that of SQL
| Server?
For sure yes, first of all you will have to connect to them using ODBC
whether to SQL server you connect using the OLEDB provider.
--
Ignacio Machin
machin AT laceupsolutions com