Compiler error on database connection

Hi all,

I am having trouble in compiling the code written C language on windows platform.
The compiler throws error as below,

test.obj : error LNK2019: unresolved external symbol SQLDriverConnect@32 referenced in function _main test.exe : fatal error LNK1120: 1 unresolved externals

Source code:

Code:

#include <stdio.h>
#include <windows.h>
#include <winnt.h>
#include <sql.h>
#include <sqlext.h>
main() {
SQLRETURN ret;
SQLHDBC dbc; /* assume already allocated */
ret = SQLDriverConnect(dbc, NULL, "DSN=mydsn;", SQL_NTS,
                       NULL, 0, NULL, SQL_DRIVER_COMPLETE);
}

Compiler: VS 2010 command line
cl test.c

When I try to link the odbc with /link odbc switch in the command line it throws error. Basically, I am not able to find out as how to link odbc.

Could you anyone please help me out to compile successfully.

Do we have any step-by-step approch for ODBC connection from c language?

Thanks,
Sundar

That's a linker error... you need to add the sql libraries to your linker's list.

Since I am new to c programming, it would be very helpful if I get all command line paramenters to complie successfully.

Where is the list of files available and what are the files to add in the command line?

An unresolved external error usually means you have not included a library or DLL that contains the function you are calling.

Have you linked your project to odbc32.lib?

Just I added the odbc32.lib file with path in the command line and works fine.

Thank you so CommanTater and novacain for your help.

-- Sundar