Sorry accidentally posted last response before i finished the post.

1. I realized this was a gcc problem so in order to debug the issue, i
stopped using make. i simply started using the gcc command on command
line.
2. On my machine the following two commands produced the same output
(error)
gcc -L. -lodbc32 -o ODBCTest.exe ODBCTest.o
and
gcc -L/lib/w32api -lodbc32 -o ODBCTest.exe ODBCTest.o
gcc was able to find libodbc32.a without specifying -L/lib/w32api.

Thanks Hans

PG

On Mar 5, 8:18 am, PG <gosa...@gmail.com> wrote:
> 1. I realized this was a gcc problem so in order to debug the issue, i
> stopped using make. i simply started using the gcc command on command
> line.
> 2. On my machine the following two commands produced the same output
> (error)
> gcc -L. -lodbc32 -o ODBCTest.exe ODBCTest.o
> and
> gcc -L/lib/w32api -lodbc32 -o ODBCTest.exe ODBCTest.o
>
> On Mar 5, 12:56 am, Huber Hans <hans.hu...@gmail.com> wrote:
>
> > PG schrieb:
>
> > > I did not know if this was a problem with makefile, cygwin, or the
> > > specific odbc library, hence i submitted this question to multiple
> > > groups.
>
> > > Anyway, after some more work, found out that the makefile is resulting
> > > in this command
> > > gcc -L/lib/w32api -lodbc32 -o ODBCTest.exe ODBCTest.o <-- Fails with
> > > link errors.
>
> > But that is not what you posted earlier on, see your previously posted
> > error output:
>
> > rm: cannot remove `*.exe': No such file or directory
> > make: [clean] Error 1 (ignored)
> > gcc -I/usr/include -Iinclude -o ODBCTest.o -c ODBCTest.c
> > gcc -L. -lodbc32 -o ODBCTest.exe ODBCTest.o
> > ODBCTest.o:ODBCTest.c.text+0x4a): undefined reference to
> > `_SQLAllocHandle@12'
>
> > no -L/lib/w32api :-)
>
> > And hey, this is has nothing to do with databases, this is a simple
> > gcc,make problem!
>
> > Cheers Hans