mysql connection with visual studio c++

Question

I have visual studio 10 and mysql workbench installed.I have created a new win32 console application project and to include the files done the following:

in project properties under c/c++ -> general, I have added C:\Program Files\MySQL\MySQL Server 5.6\include

in linker -> general -> additional library directories I have added C:\Program Files\MySQL\MySQL Server 5.6\lib

in linker -> general -> input -> additional dependencies I have added libmysql.lib

i have copied libmysql.lib to system32 folder.

#include<iostream>
#include<my_global.h>
#include<mysql.h>
MYSQL* con=mysql_init(NULL);
MYSQL_RES* result;

the above code gives the following error->

error LNK2019: unresolved external symbol _mysql_init@4 referenced in function "void __cdecl `dynamic initializer for 'con''(void)" (??__Econ@@YAXXZ)
1>c:\users\dell\documents\visual studio 2010\Projects\dmrc2\Debug\dmrc2.exe : fatal error LNK1120: 1 unresolved externals

Jerry YY Rain · Answer 1 · 2014-07-09T08:20:16.757

0

unresolved external symbol this is linker error. In other words, your code is OK to compile but is not correct when attempting to link library into an executable because you input wrong library file name.

You need input library name instead of dll name.
In linker -> general -> input -> additional dependencies I have added libmysql.lib

edited Jul 09 '14 at 08:20

answered Jul 09 '14 at 08:13

Jerry YY Rain

4,134
7
35
52

yes i have added libmysql.lib and not libmysql.dll sory...but why does'nt it work – user3819404 Jul 09 '14 at 08:20
where do you put this line `MYSQL* con=mysql_init(NULL);`? – Jerry YY Rain Jul 09 '14 at 08:22

score 0 · Answer 2 · answered Jul 09 '14 at 08:45

0

place your libmysql.lib file in debug folder which is located in your project directory

answered Jul 09 '14 at 08:45

Faisal Jamil

1
1

please add this type of answer as a comment – Nandu Jul 18 '14 at 03:39

mysql connection with visual studio c++

2 Answers2

Linked