Trying to connect to MySQL from Visual C++ 6 (Windows MFC Application)

You will find mysql.h file here:
http://www.distlab.dk/mysql-4.1/html/include_2mysql_8h-source.html

Also consider that you will need libmySQL.lib or libmySQL.dll available at www.mysql.com

Axter, I am aware of the possibility (and even have a book with a chapter on how to do that), but I need the program to be self-contained.
The target user for the app I'm building is not at all computer savvy and the simplest the installation/operation, the better.

jaime_olivares, the mysql.h you link to is the same one I have (that came in the mysql source code), so I'm still in the same place.
Can you tell me more about the libmySQL.* you are talking about? How do I install those?

(by the way, thanks for the lighning fast replies)

jkr, I think you are onto something.

My code now looks like this:

// mysql test.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"
#include <windows.h>
#include <winsock.h>
#include <mysql.h>

int main()
{

// create a pointer of the type mysql
MYSQL *conn;
// initialize your mysql connection
conn = mysql_init(NULL);
// connect to your database
mysql_real_connect(conn,"localhost","username","password","database",0,NULL,0);
// perform a query
mysql_query(conn,"UPDATE my_table SET somevalue = somevalue + 1 WHERE id = 5");
// close the connection
mysql_close(conn);

 return 0;
}


But I'm still getting these errors:

mysql test.obj : error LNK2001: unresolved external symbol _mysql_close@4
mysql test.obj : error LNK2001: unresolved external symbol _mysql_query@8
mysql test.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32
mysql test.obj : error LNK2001: unresolved external symbol _mysql_init@4
Debug/mysql test.exe : fatal error LNK1120: 4 unresolved externals

Try to locate the .lib file, it must be come with the mysql.h file, and then modify your project's setting to link this file with your source code.

jaime, you are right. I compiled libmysql.lib and linked it to my project and most of the errors went away.
I knew it had to do with libmysql.lib because you mentioned it earlier. Is there any way to know what lib is missing?

My only error now is:

======================
Linking...
LIBCD.LIB(wincrt0.obj) : error LNK2001: unresolved external symbol _WinMain@16
Debug/mysql test.exe : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.

mysql test.exe - 2 error(s), 0 warning(s)
======================


I'm assumming it has to do with LIBCD.LIB, but this file came with the VC++ 6 standard install. It doesn't matter if I link it to my project or not, it will still return the same error...

Since you have answered my question and these compilation errors have nothing to do with the original question, I will assign points to the corresponding answers.
I'm just going to ask you to help me to figure this small compilation error before you leave :)

Hi poisa, thanks for the points.
About the WinMain problem, that will depend on what kind of application (windows,console) you are trying to generate, it is not related with mysql at all.
Read this article from Microsoft:
http://support.microsoft.com/kb/q131204/
Also have a look to these previous questions discussing this problem:
http://www.experts-exchange.com/Programming/Programming_Languages/Cplusplus/Q_20547023.html
http://www.experts-exchange.com/Programming/Programming_Languages/Cplusplus/Q_20785765.html