MySQL connection problem

[shabonaa]

i'm facing a problem connecting to mysql using C# i'm using oledb and it gives me (MySQLProv' provider is not registered on the local machine) i downloaded and installed ADO.NET Driver for MySQL (Connector/NET) so does anybody know the problem

[Hayder Marzouk]

Hi, You have downloaded MySQl connector, so use it instead of oledb. It's a native driver and fully managed .Net so more performant than oledb driver. HTH. Hayder Marzouk

[shabonaa]

thanks Hayder. but i think we need to add reference first to use the name space