I have tried to use some SQL functions - SQLAllocHandle, etc etc in my application. I have written a console app using it which works great. However, when I add the code to an MFC app, when I compile I get something like:

Code:
DuplicateManager.obj : error LNK2001: unresolved external symbol _SQLAllocHandle@12
Release/DuplicateManager.exe : fatal error LNK1120: 1 unresolved externals
Can anyone tell me why? And also how to sort it out. In the meantime I have moved the SQL access functions into a dll, where they can be called - but this is inefficient.

Thanks

HD