Is there any way to use SQL C++ library in mfc program?

Question

0.00/5 (No votes)

See more:

hi ALL
I wrote a library for my database tasks in c++ console environment
then when I added that lib to my MFC program it gives me some linker errors:
LNK2001 unresolved external symbol _SQLSetEnvAttr@16
LNK2001 unresolved external symbol _SQLAllocHandle@12
I want to know if there was a way to link my MFC program to my sql database;
any comment appreciated.

What I have tried:

my program work fine in console application

Posted 6-Aug-18 21:54pm

saide_a

Updated 6-Aug-18 22:32pm

Add a Solution

2 solutions

Solution 2

You can include C++ library into, but there are a lot of pitfalls. Have you include the lib file into the linker settings (or link in code). The binaries must also match x32 or x64. If the dll uses MFC it is better to static link it (or you use the MFC dll typ).

Another big problem is, that you need to export the function in the dll in the correct way. Read this Microsoft documentation which options you have. Normally the

C++

__declspec(dllexport)

is the best way.

Posted 6-Aug-18 22:32pm

KarstenK

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Accepted Answer · 2018-08-06T22:30:00

Solution 1

You have to link your application with the library containing these functions which is odbc32.lib like you have done for your console application.

You can do that in the project settings at Linker - Input - Additional Dependencies or using a pragma statement in one of your source files:

C++

#pragma comment(lib, "odbc32.lib")

Posted 6-Aug-18 22:30pm

Jochen Arndt

Comments

KarstenK 7-Aug-18 13:50pm

The error message sounds that he including the lib BUT the exported names arent matching. Thats why my answer includes some more tips.

PS: if it doesnt help we need more information.

Jochen Arndt 7-Aug-18 14:15pm

My solution has been accepted. I guess he just forgot to add the library to the dependencies. Note also that it is a MS system library and not a self written one.

KarstenK 8-Aug-18 4:43am

I see - so simple ;-)