Thread: compile error

compile error

From
George Esperanza
Date:
Hi!


I got the latest release of postgres 7.2.3 and after
extracting the tar file. I issued this command:

/configure --prefix=/usr/local/pgsql/ --with-perl
--enable-odbc --with-unixodbc

gmake

After a couple of minutes of it shows me this:

gmake[3]: Entering directory
`/home/george/Install/postgresql-7.2.3/src/interfaces/odbc'
gcc -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -fpic -I.
-I../../../src/include  -DFRONTEND -DMD5_ODBC  -c -o
info.o info.c
In file included from info.c:19:
psqlodbc.h:30: sql.h: No such file or directory
psqlodbc.h:31: sqlext.h: No such file or directory
psqlodbc.h:41: odbcinst.h: No such file or directory
gmake[3]: *** [info.o] Error 1
gmake[3]: Leaving directory
`/home/george/Install/postgresql-7.2.3/src/interfaces/odbc'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory
`/home/george/Install/postgresql-7.2.3/src/interfaces'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/home/george/Install/postgresql-7.2.3/src'
gmake: *** [all] Error 2


I looks that i'm missing some files. Can somebody help
me how to fix this problem.

I wan't to compile postgres to support ODBC, because
i'm planning to develop a system to be written in VB6
and i prefer to use postgres as my Database server.

Thanks in advance....

George 

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com


Re: compile error

From
Peter Eisentraut
Date:
George Esperanza writes:

> In file included from info.c:19:
> psqlodbc.h:30: sql.h: No such file or directory
> psqlodbc.h:31: sqlext.h: No such file or directory
> psqlodbc.h:41: odbcinst.h: No such file or directory
> gmake[3]: *** [info.o] Error 1

You need to install unixODBC ...

> I wan't to compile postgres to support ODBC, because
> i'm planning to develop a system to be written in VB6
> and i prefer to use postgres as my Database server.

... or just download the driver for Windows from
http://odbc.postgresql.org.  There is no "ODBC support".  All
--enable-odbc does it do turn on the build of the ODBC driver for Unix
systems, which is apparently not what you really want.

-- 
Peter Eisentraut   peter_e@gmx.net