Re: Technical Query on MySQL

[Bonjo]

If you use ODBC you dont'n use MySql.Data.MySqlClient, because this namespace is intended
only for MySql data provider, not for ODBC drivers.

Regards 



----- Mensaje original ----
De: Pavithra <pavithra@stripped>
Para: dotnet@stripped
Enviado: martes, 22 de julio, 2008 7:21:22
Asunto: Technical Query on MySQL

Hello,



I am using VS 2005 with MySQL as Back End. I tried using ODBC connection ,
but showing me an error in VS Connection String as " MySQL ODBC 3.51 Driver
not found" even though ODBC connection is set up correctly. I am unable to
figure out where exactly the problem is of course its in ODBC Driver. My
connection string is like this, my code is working fine in others system but
not in mine.I am scratching my head since 3 days.



using MySql.Data.MySqlClient;



MySqlConnection con = new MySqlConnection("Driver={MySQL ODBC 3.51
Driver};Server=127.0.0.1;Database=tcz;Username=root;Password=test;Port=3306;
")



Kindly resolve this as soon as possible. I need it urgently.



Cheers 

Pavithra


     
____________________________________________________________________________________
Yahoo! MTV Blog & Rock &gt;¡Cuéntanos tu historia, inspira una
canción y gánate un viaje a los Premios MTV! Participa aquí
http://mtvla.yahoo.com/