Re: Technical Query regarding ODBC

Pavithra,

Do you see the MySQL driver through ODBC Manager? Are you able to 
connect using any other tool that uses ODBC?

I see that you do not have an ODBC DSN. I'd recommend you specify a DSN 
and see if that changes any thing. Once you have a DSN, your connection 
string will look like:

MySqlConnection conn = new 
MySQLConnection("DSN=YourDSN;Username=root;Password=test")

Regards,
Imran.


Pavithra wrote:
> 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(MySQL ODBC 3.51
> Driver). 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
>
>  
>
>  
>
>
>   

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]