Thread: Compilation fails everytime while using SQLAllocHandle

Hi All,

Im stuck with this error for a week and I cant move on... Please help me out... I have been trying to compile this simple C program on my AIX machine but getting the below error.

Code:

#include <stdio.h>
#include "sql.h"
#include "sqlext.h"
main() {
SQLHENV env;
char dsn[256];
char desc[256];
SQLSMALLINT dsn_ret;
SQLSMALLINT desc_ret;
SQLUSMALLINT direction;
SQLRETURN ret;
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
}

I used below compilation and got the error :

Code:

/apps//scripts$gcc data.c -o data
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocHandle
ld: 0711-317 ERROR: Undefined symbol: .SQLExecDirect
ld: 0711-317 ERROR: Undefined symbol: .SQLFreeHandle
ld: 0711-317 ERROR: Undefined symbol: .SQLBindCol
ld: 0711-317 ERROR: Undefined symbol: .SQLFetch
ld: 0711-317 ERROR: Undefined symbol: .SQLDisconnect
ld: 0711-317 ERROR: Undefined symbol: .SQLSetEnvAttr
ld: 0711-317 ERROR: Undefined symbol: .SQLDriverConnect
ld: 0711-317 ERROR: Undefined symbol: .SQLGetDiagRec
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status

UNIX odbc is installed in

Code:

/usr/local/easysoft/unixODBC

The header files are located in

Code:

/usr/local/easysoft/unixODBC/include

I copy pasted the header files from here to my current directory and compiled my program.

Don't know what is missing ...

Please throw some light .......

Have you tried googling on "Undefined symbol: .SQLAllocHandle" etc?

Originally Posted by gemera

Have you tried googling on "Undefined symbol: .SQLAllocHandle" etc?

Yes, I have tried various solutions provided in different sides, but could not solve it.

One of the solution was to include the lib file "libodbc.a".

It was not present inside /usr/lib but inside /usr/local/easysoft/unixODBC/lib.

I copy paseted that lib file to my current directory which is /apps/scripts.

And I ran the below command

Code:

 /apps/rmb/scripts$gcc database.c -L/apps/rmb/scripts -lodbc -o database
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocHandle
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
/apps/rmb/scripts$

Originally Posted by Salem

> I copy pasted the header files from here to my current directory and compiled my program.

Your gcc command line should look something like this

Code:

gcc -I/usr/local/easysoft/unixODBC/include -L/usr/local/easysoft/unixODBC/lib data.c -o data -lodbc

.

Hi Salem ,

Thanks for the advise... I tried your command, it still throws the same error... please advise

Code:

 /apps/rmb/scripts$gcc -I/usr/local/easysoft/unixODBC/include -L/usr/local/easysoft/unixODBC/lib data.c -o data -lodbc
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocHandle
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status

Please advise

Originally Posted by Jimmy

Did you do as Salem said and checked where your header files and library files actually are, or did you just copy and paste what he wrote as an example?

Hi Jimmy,

I already provided the installation path in the first post itself, based on that only salem provided the example... It is the same path.... Still its not working...
Don't know how to solve it

Hi,

Sorry for the late reply,

Please find all the details below. Library path is correct. Still it wont compile.

Code:

/usr/local/easysoft/unixODBC/lib$ls
libodbc.a         libodbc.so.1      libodbccr.a.1     libodbcinst.a     libodbcinst.so.1
libodbc.a.1       libodbccr.a       libodbccr.so.1    libodbcinst.a.1




/usr/local/easysoft/unixODBC/include$ls
odbcinst.h       odbcinstext.h    sql.h            sqlext.h         sqltypes.h       sqlucode.h       unixodbc_conf.h


/apps/rmb/scripts$gcc -I/usr/local/easysoft/unixODBC/include -L/usr/local/easysoft/unixODBC/lib database.c -o data -lodbc
ld: 0711-317 ERROR: Undefined symbol: .SQLAllocHandle
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
/apps/rmb/scripts$

Hi Salem,

Finally it worked.. I tried the below command

gcc -maix64 -I/usr/local/easysoft/unixODBC/include -I. -L/usr/local/easysoft/unixODBC/lib -lodbc -o data database.c