I'm having a problem connecting to a MySQL database through my c++ programs. I use Borland 5.5.1 C++ Builder and I used the "MySQL++ 1.7.1 for Borland C++ 5.* for Windows (contributed by Arturs Aboltins", which can be found the sixth from the bottom at http://www.mysql.com/downloads/api-mysql++.html. I installed it, and I tried to compile this test program:


But I get this error:

Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
test.cpp:
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external 'mysql_init' referenced from C:\BORLAND\BCC55\BIN\TEST.OBJ
Error: Unresolved external 'mysql_options' referenced from C:\BORLAND\BCC55\BIN\TEST.OBJ
Error: Unresolved external 'mysql_real_connect' referenced from C:\BORLAND\BCC55\BIN\TEST.OBJ
Error: Unresolved external 'mysql_error' referenced from C:\BORLAND\BCC55\BIN\TEST.OBJ


What can I do to fix this? If I can't fix it, what other options do I have to use MySQL databases in my programs (without paying for anything!)?

I've never used this library, but this is a linker error. Are you linking your program with the library? This would either be a precompiled library (lib-dll) or the c file. If you are and having this problem, then it is something that I would need to look into further before I could help.

Thanks - I just realized you're the same person who helped me with my earlier problem, the one with cin.

Anyway, sorry for being a total idiot. But how do you do that? Is it different with different compilers, or do you include it with the code?

I'm such a newbie

I haven't used the borland c compiler, but if it is similar to the Visual C compiler, you should be able to make a project somehow. What you want to do is include the source code for the library into that project along with your source code above. Your compiler should handle compiling both your project and the library and then passing them to the linker to be linked together.

Sorry, I can't be of more help. If you are still struggling with this let me know and I can take a closer look at the mysql library that you downloaded tommorow.

I got it to work. Since Borland C++ Builder is a command-line tool, you can't make projects. But I just had to list the .lib file with the file I was compiling, and it linked it. Thanks for your help, I wouldn't have been able to figure it out without you.

Hello,

I am facing the same problem as you were before. I'm a newbie and don't know how to make projects to work.
I'm coding with Borland CBuilder 6, need to code with mySQL++ API.

If you got it work let me know how. Please help, the more details the better.

Thanks.

Hi Roy. I am a little unfamiliar with Borland Builder, but if it does use a command line, then you should be able to add libraries quite easily. use the -l to add a library to be linked to your project and a -L to add a search path for a library to your compile command. (This is based on gcc, but most compilers follow this convention.) So, if you compile from the commmand line, you should be able to type something like:

Hopefully, TRS can give you the exact commandline that he used.

Good luck!