Thread: ODBC + MySQL - HOW TO???Q

Hi
I have a problem with compiling a c++ with ODBC statements inside. Here is a sample:

#include <iostream.h>
#include <iomanip.h>
#include <string.h>
#include <windows.h>
#include <sql.h>
#include <sqlext.h>

void main(){
.../*some code here */...
//SQL Connection Part
SQLHENV henv1; //Environment handler
SQLHDBC hdbc1; //Connection handler
SQLHSTMT hstmt; //Statement handler

//Create environment for SQL operations
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv1);

//Select database driver
SQLConnect(hdbc1, rhost, strlen(rhost), ruser, strlen(ruser), rpassword, strlen(rpassword));
}

The problem is that whenever i add any of SQL functions i get:
Unresolved external 'SQLAllocHandle' referenced from my.obj
Unresolved external 'SQLConnect' referenced from my.obj

I already tried to import those two libraries into compilers lib dir
implib myodbc3.lib c:\winnt\system32\myodbc3.dll and
implib odbc32.lib c:\winnt\system32\odbc32.dll
but the result is the same

Can someone help??

ps. (I'm using borland c++ compiler 5.5)

Thx
I guess I almost have it.
i used

Code:

bcc32 -c my.cpp

and then an incremental linker:

Code:

ilink32 my.obj,,,odbc32.lib

But there's still a problem the executable is to small 2KB - not a Win32 app. When linking I also try to include import32.lib and cw32.lib, and next myodbc3.lib - but with no effects. It's strange but the executable compiles without errors that I wrote in first post but it does not want to run.

Its been a while since I've used Borland, but you could try explicitely telling it the name of the output file. I think it was ilink32 /o my.exe, but just do a ilink /? to make sure.

nope same thing happens even if I type ilink32 with my.exe