Connection string

[Alan T]

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?

 

[pigeonrandle]

Hi,

http://www.connectionstrings.com/

it's the ultimate!

HTH,
James.

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

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

 

[Peter Bradley]

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

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

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

????

You use SqlClient for SQLServer and MySQL Connector/.NET for MySQL.

Arne

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi

| ????
|
| You use SqlClient for SQLServer and MySQL Connector/.NET for MySQL.

Yes, Now I know there is a data provider for MySQL, I had no idea it existed
before

 

[Barry Kelly]

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

There is a .NET provider for Firebird too. The documentation contains
info on the connection strings, IIRC.

-- Barry