unfortunately the code built with Visual Studio 2005 cannoy be opened from a older version f Visual Studio

You can create a new Visual Studio 2003 project and copy the code from the Visual Studio 2005 code files.

I will create a 2003 version as soon as I get 3 free minutes :).

this would be nice ;)
i'm a beginner and i can't get a connection to a mysql DB ... i've got only the standart version ... is that the reason? ... but it can't be ... i wont believe it

If you were to distribute this app, there would be the issue of the end-user requiring the ODBC drivers.

Indeed, that's the single major inconvenient.
However, you might be able to include it in the setup package of the application.

[MySQL][ODBC 3.51 Driver]Access Denied for user "*********@*************.com" (Using Password: Yes)

I get that error when I try to set up the information in the ODBC connection creater screen....why is that? I'm simply trying to access a database on a server - I'm hosted by voltagehosting.com. Thanks a lot!

There can be several reasons, but the best guess is that your IP isn't listed in the "Allowed Hosts" list of MySQL.

MySQL has a list of the IPs (hosts) allowed to connect to the database. Since you are connecting to a remote MySQL server, you need to first add your IP to that list, and the privileges. This can be done via the admin interface of your webhost, or (if you have the required access) through the "user" table on your "mysql" database of the MySQL server.

Good luck!

I didn't have to configure MyODBC at all, it worked great, thanks for helping me get my feet wet with C# and MySQL!

Thanks for short, simple and useful example.

Hey,

Great tutorial, but just one question. How would I go about saving the result of OdbcDR[0] into a string.....like string information = OdbcDR[0]; - but that gives me an error....can you help me?

Good and intresting tutorial. It helped me alot

i want to use a query like
" SELECT * FROM 'news' "
And i want to use a while loop to display all the selected data. Can anyone tell me how to do this?

Now show us how to do it in ASP :) There's this really annoying little problem with ODBC when you try to update a table. It gives you this error "Restricted data type attribute violation." What an enormous pain.

Thanks for this, managed to copy the code to 2003 and it worked like a treat.

Great, thanx..!

Thank a lot

i try to connect to a friends pc to retrieve data from his database and it says it cannot connect, my friend has no firewall, the database is running and the user data are correct. can you help me ? also i cannot find odbc anywhere in the control panel !

Have you installed ODBC?
Also make sure he has your IP in MySQL's "allowed" list (this is also a table in the database).

Hi, This might seem like a stupid question but i have to ask anyway:
You used the ODBC driver in your tutorial. I have downloaded from the MySql site the .Net connector .
What's the difference? (The .Net connector is working fine for me)

wowwww this code really helps me...

Thank you very much!!! and hope you continue helping otherss.....


wynette :) *philippines*

After searching the Internet for hours I finally found this great simple example. Thanks a lot!!

Hey I am really struggling with MySql and C#. I have installed Myodbc from this website and installed it. but i couldn\'t find Data sources(ODBC) option in my control panel will u plss help me with this. I need it urgently

when i run aplication from this site i got an error similar to "[MySQL][ODBC 3.51 Driver]Access Denied for user "*********@*************.com" (Using Password: Yes)"
What is a password for this database

hey I dunt want to access MySql database from Remote server.I have MySql on my laptop and want to access it thru my programm what changes i need to do.. I am new to this MySql and C#

hey I dunt want to access MySql database from Remote server.I have MySql on my laptop and want to access it thru my programm what changes i need to do.. I am new to this MySql and C#

Wow that was really helpful, thanks for putting in the time to help out

Great tutorial, the VS2005 project compiles the first time.

To answer the question above, go Control Panel->Administrative Tools->Data Sources (ODBC), then click the Add button on the Users tab.

about the \"[MySQL][ODBC 3.51 Driver]Access Denied for user \"*********@*************.com\" (Using Password: Yes)\"
you must type this command :
for example,
grant all on mp3collection.* to csharp@127.0.0.1 identified by ‘csharp’;
into the MySQL command line client.
Then, on the \"add data source form\" for odbc - type the server as 127.0.0.1 and password as csharp.
Then, it should work. You can create you own server and password not neccesarily follow what i have written.
for example,
grant all on book.*to csharp@198.1.3.2 identified by \'book\'.
\"book\" is the database that you have created

Great tutorial for people who never even heard of ODBC... Thank for that!

Thank you very much for this great tutorial!
I have been googling for last two days to find way to connect between MySQL and C#.
Finally,I could get it because of you.
I will try.
Will have ++More Thanks if it works well for me.

great tutorial
worked strraight out the box ....

10x, a real help for someone who only has 15 minutes to do the connection and querries.

hi ! Great tutorial man !

can i save the changes i made to the table back to the MySql Server?

I made this code :

System.Data.Odbc.OdbcConnection OdbcCon;
System.Data.Odbc.OdbcCommand OdbcCom;
System.Data.Odbc.OdbcDataReader OdbcDR;
string ConStr;


ConStr = \"DRIVER={MySQL ODBC 3.51 Driver};SERVER=Localhost;PORT=3306;DATABASE=loan;UID=Secret;PWD=Secret;OPTION=3\";
OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr);

try
{
if (OdbcCon.State == ConnectionState.Closed)
{
OdbcCon.Open();
}
}
catch
{
MessageBox.Show(\"Could not Connect to the MySql Database, An Error Occured\");
}

DataSet MySqlDataSet = new DataSet();
DataTable Accdist = new DataTable();
Accdist.TableName = \"Accdist\";
MySqlDataSet.Tables.Add(Accdist);


System.Data.Odbc.OdbcDataAdapter AccdistTableAdapter = new System.Data.Odbc.OdbcDataAdapter(\"Select * from accdist\", OdbcCon);

AccdistTableAdapter.Fill(MySqlDataSet.Tables[\"Accdist\"]);


foreach (DataRow MyRows in MySqlDataSet.Tables[\"Accdist\"].Rows)
{
if (MyRows[\"at_control\"].ToString() == string.Empty)
{
MyRows[\"at_control\"] = \"Empty\";
}
}

//This repeatition is for checking if i have replace the value of empty field \"at_control\" with the word \"Empty\" in the dataset (in this case it was successfull)

foreach (DataRow MyRows in MySqlDataSet.Tables[\"Accdist\"].Rows)
{
MessageBox.Show(MyRows[\"at_control\"].ToString());
}

//Updating the table adapter causes an error saying *&^@#*^
//so maybe i thought i have to execute this accept changes first

MySqlDataSet.Tables[\"Accdist\"].AcceptChanges();

AccdistTableAdapter.Update(MySqlDataSet.Tables[\"Accdist\"]);


It ddnt give me any error anymore, but when i browse my MySql loans database using SqlYog , the changes i made was not thrown back to the Database

Help !!!

I agree with most of the others, this was an excellent resource putting together some pieces to the puzzle that I\'d been having trouble with.
Many thanks.

Great Tutorial, Ive looked thro\' 100s of tutorials on this topic but one gave me the solution what i want, simply brilliant great job :)

Greate tutorial! Does anyone know what the driver string is for the 5.0.8.1 connector?

Great Tutorial !!! Can we extend this tutorial to show how to take backup of mysql data from C# application?

Good job.simple article which gave me what i want.

hi, Odbc With LocalHost Works Fine. But I Am Not Able To Conect To The Database In My LAN

This is very good example that gave me good idea about Mysql database connectivity with c#.I have connected using the same pattern.But i am having error like{Unable to connect any of Mysql Host}.Database is hosted in Remote server via internet and i access that connection string in the same way as shown in your example.What could be the problem.Is it from server side or from my application side.On server there is Mysql 3.23.58 version running.Kindly tell me what setting else we have to make with server and with my local machine.Insted of mysql ODBC ,I also tried by incloding Bytefx .DLL file in my application but still could not connect.For last one month i am stuck on this kindly help me

Thank you so much. HOURS trying to find the right way to connect is finally to an end. :)

Good article... I got this far myself but am now having issues trying to write long strings to a MySQL column of datatype TEXT. Any tips or tricks would be greatfully recieved!! :)

THIS is the only tutorial I have seen that actually works and is in detail on how to set things up!!! Awesome job!

even iam trying 2 connect .net app with MYSQL DB but i could not connecting iam getting the error like The 'MySQLProv' provider is not registered on the local machine

Hi,
Thanks a lot for sharing this application and about MyODBC driver. I am new to MySql and now with ur help can easily migrated to mysql .net :)

Thanks again!
Happy working with mysql :)

Hy Andrew,,

great job!

I testet it and it works fine.
I made a new Project in C# an wants to show the values from my MySQL-Database "db_tb2_Einwohner" (xampp installed) in a DataGridView. There are no errors, but the Values from the "tbl_Ort" arent populated in the DataGridView1.
Can you help me? Do you find out the "error"?

Thanks a lot


****************
Hier is my code:
****************


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.Data.Common;
using System.Data.Odbc;
using System.Data.OleDb;
using System.Data.ProviderBase;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;

namespace a1
{
public partial class Form1 : Form
{
private System.Data.Odbc.OdbcConnection OdbcCon;
private System.Data.Odbc.OdbcCommand OdbcCom;
private System.Data.Odbc.OdbcDataReader OdbcDR;
private System.Data.Odbc.OdbcDataAdapter MyDA;
private string ConStr;

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
// Build the connection string
ConStr = "DRIVER={MySQL ODBC 5.1 Driver};SERVER="
"127.0.0.1"
";PORT="
"3306"
";DATABASE="
"db_tg2_Einwohner"
";UID="
"root"
";PWD="
""
";OPTION=3";
OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr);
OdbcCon.Open();
lbl_conn_tst.Text = "Connection opened";

OdbcDataAdapter MyDA = new OdbcDataAdapter();
string sqlSelectAll = "SELECT * FROM tbl_Ort";
MyDA.SelectCommand = new OdbcCommand(sqlSelectAll, OdbcCon);

DataTable table = new DataTable();
MyDA.Fill(table);

BindingSource bSource = new BindingSource();
bSource.DataSource = table;


DataGridView dataGridView1 = new DataGridView();

dataGridView1.DataSource = bSource;

}
}
}

Openning connection...
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

i set up my obdc drivers..

I do the same but...C# give me this error.

ERROR [HYC00] [MySQL][ODBC 5.1 Driver]Optional feature not supported

Why?

Version of ODBC driver in code must be the same as your installed version of ODBC!!! If you have 5.1, simple change number of version in code and will work it!;)

hello Sir..
we are developing an web application using c#

and mysql, this application works fine in my sytem. but when i deploy the same application in the server it is giving me HYT00 MySql ODBC 3.51 Driver access denied Error, i've given server's User Name Password

we are developing an web application using c# and mysql, this application works fine in my sytem. but when i deploy the same application in the server it is giving me HYT00 MySql ODBC 3.51 Driver access denied Error, i've given server's User Name Password and IP Address in the connection String Please Help me.....

Error occured. ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.16-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

I am using ODBC with mysql in c#

Error occured. ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.16-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

I am using ODBC with mysql in c#

please tellme how to connect c# with my sql

thanks a lot.

After installation, when I click Add, I do not see the MyODBC coonector in the list, so be able to enter the server and the description needed. I just see, sql server, and sql Native client. Please how do I get around this?

Help Me restore my Character on ninja saga.. the error is 1100 ididnt use any hack's software or cheats..softwares or anything just playing.. plss undisable my account.. ASAP.

Help Me restore my Character on ninja saga.. the error is 1100 ididnt use any hack's software or cheats..softwares or anything just playing.. plss undisable my account.. ASAP.

Help Me restore my Character on ninja saga.. the error is 1100 ididnt use any hack's software or cheats..softwares or anything just playing.. plss undisable my account.. ASAP.

Hello Sir,
As u know KOHA is a free library software developed using MySQL,perl,and PHP.
I can't understand is it window base or web based application?
I want to same application using MySQL and C#.
So i want to know that is it web or window based.
Please reply me fast.

Hello Sir,
As u know KOHA is a free library software developed using MySQL,perl,and PHP.
I can't understand is it window base or web based application?
I want to same application using MySQL and C#.
So i want to know that is it web or window based.
Please reply me fast.

Hello Sir,
As u know KOHA is a free library software developed using MySQL,perl,and PHP.
I can't understand is it window base or web based application?
I want to same application using MySQL and C#.
So i want to know that is it web or window based.
Please reply me fast.

thanks a lot,

Hello sir,
It's a great tutorial! But I still have some confusion with it.
In your ConStr, you specified the version of the ODBC driver with 5.1, but I'm not sure what my sql's version is. Can you give me some help?
Thanks!

I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

Hi! Great article, it helped me alot!

You could also add an example how to repeat an exception instead of letting the program just end. For example: we need an integer input, but an string was entered... how to repeat the try - catch block?

by Andrei Pociu on Monday, November 21st 2005 at 09:37 AM

Put everything in a method, and in the catch block you can recall the method (you can say the method calls itself).

Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view

There is perceptibly a lot to know about this. I feel you made some good points in features also.

Great article and it's all very well explained. Just one doubt, How will i connect MySQL database running on LINUX from my C# windows application?

I have heaard about MONO, is there any other alternative?

For example: we need an integer input, but an string was entered... how to repeat the try -

but an string was entered... how to repeat the try -