Connect to MySQL from MFC Dlg

[QuickDeveloper]

hi I want to connect to MySQL database when i click a button in MFC dialog based application. 1)I searched web (including CP) but i didn't find exact info since there seems to be various methods to connect including DSN less (using MySQL++) 2)I have downloaded MySQL database & ODBC connector but i am not able to connect to it even while creating DSN(From Control Panel). 3)I am able to create tables etc on MySQL command line but not able to establish link between database & VC++ App. Can anyone point me to a simple article which explains connecting to MySQl and inserting a record into it(with DSN or without DSN) thanx in advance

"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"

[Kiran Pinjala]

MySql installation will provide you with soem documentation for api's to be used for all operations with MySql Database. Some of them are

void *mydata;
//initialize and connect to mysql database
mysql_init((MYSQL*) 0);
mysql_real_connect((MYSQL*) myData,dbHost,dbUID,dbPWD, NULL, MYSQL_PORT, NULL,0);
//select the database to futher operations
mysql_select_db( (MYSQL*)myData,"MYSQL");
// run aquery
mysql_query((MYSQL*)myData, "select * from mysql.host");

Saadhinchaali

[Kiran Pinjala]

See here

Saadhinchaali

[Hamid Taebi]

See Using Visual C++ 6.0 to connect to MySQL[^]. <blockquote class="FQ"><div class="FQA">QuickDeveloper wrote:</div>"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"</blockquote> if you find your name in that list do you go to work if see your name in the middle of list? ;)

[David Crow]

QuickDeveloper wrote:

I want to connect to MySQL database when i click a button in MFC dialog based application.

So what are you having trouble with: 1) connecting to the data source, or 2) responding to a button click?

"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

[QuickDeveloper]

DavidCrow wrote:

1. connecting to the data source,

Connecting to the datasource while creating DSN

"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"

[David Crow]

One way is to create a CRecordset-derived object. ClassWizard (Ctrl+W) will ask you what DSN to use.

"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne