ecpg help - Mailing list pgsql-interfaces

Hello,I'm running Postgresql  7.2.2 on RedHat Linux 7.1.  I am trying to use
Postgres embedded sql       preprocessor (ECPG).  However, I get a loading shared library
problem when I attempt toexecute a program.  I included a simple example below...

Thanks

Error:
============
try: error while loading shared libraries: libecpg.so.3: cannot load shared
object file: No such file or directory

echo $LD_LIBRARY_PATH
======================
:/home/smith/lib:/usr/local/pgsql/lib:/usr/lib/qt/lib

ls -l /usr/localpgsql/lib
-rw-r--r--    1 root     root        46302 Aug 30 11:05 libecpg.a
lrwxrwxrwx    1 root     root           16 Aug 30 11:05 libecpg.so ->
libecpg.so.3.3.0
lrwxrwxrwx    1 root     root           16 Aug 30 11:05 libecpg.so.3 ->
libecpg.so.3.3.0
-rwxr-xr-x    1 root     root        40220 Aug 30 11:05 libecpg.so.3.3.0
-rw-r--r--    1 root     root         6664 Aug 30 11:05 libpgeasy.a
lrwxrwxrwx    1 root     root           16 Aug 30 11:05 libpgeasy.so ->
libpgeasy.so.2.2
lrwxrwxrwx    1 root     root           16 Aug 30 11:05 libpgeasy.so.2 ->
libpgeasy.so.2.2
-rwxr-xr-x    1 root     root        10809 Aug 30 11:05 libpgeasy.so.2.2
-rw-r--r--    1 root     root        30574 Aug 30 11:05 libpgtcl.a
lrwxrwxrwx    1 root     root           15 Aug 30 11:05 libpgtcl.so ->
libpgtcl.so.2.2
lrwxrwxrwx    1 root     root           15 Aug 30 11:05 libpgtcl.so.2 ->
libpgtcl.so.2.2
-rwxr-xr-x    1 root     root        35241 Aug 30 11:05 libpgtcl.so.2.2
-rw-r--r--    1 root     root        82598 Aug 30 11:05 libpq.a
-rw-r--r--    1 root     root        68982 Aug 30 11:05 libpq++.a
lrwxrwxrwx    1 root     root           12 Aug 30 11:05 libpq.so ->
libpq.so.2.2
lrwxrwxrwx    1 root     root           14 Aug 30 11:05 libpq++.so ->
libpq++.so.4.0
lrwxrwxrwx    1 root     root           12 Aug 30 11:05 libpq.so.2 ->
libpq.so.2.2
-rwxr-xr-x    1 root     root        74685 Aug 30 11:05 libpq.so.2.2
lrwxrwxrwx    1 root     root           14 Aug 30 11:05 libpq++.so.4 ->
libpq++.so.4.0
-rwxr-xr-x    1 root     root        47166 Aug 30 11:05 libpq++.so.4.0
-rwxr-xr-x    1 root     root      1041877 Aug 30 11:05 plperl.so
-rwxr-xr-x    1 root     root        90075 Aug 30 11:05 plpgsql.so
-rwxr-xr-x    1 root     root       540450 Aug 30 11:05 plpython.so
-rwxr-xr-x    1 root     root        33726 Aug 30 11:05 pltcl.so




##################### try.pc #########################
#include <stdio.h>

EXEC SQL BEGIN DECLARE SECTION;
int result;
EXEC SQL END DECLARE SECTION;

int main()
{ EXEC SQL CONNECT TO TmDB; EXEC SQL SELECT (1+1) INTO :result;
 printf("Result = %d\n",result);
 return 0;

}

##################### Makefile#######################
EC        = ecpg
CC        = gcc
INCPG     = /usr/local/pgsql/include   # Path for postgresql includes.

#Declaration header.
LIBPG     = /usr/local/pgsql/lib       # Path for ecpg libraries.
LIBSPG    = -lecpg -lpq                # Ecpg libraries.
CFLAGS    = -Wall -g -c


%.c: %.pc
$(EC) -t -o $@ $<

%.o: %.c
$(CC) $(CFLAGS) -I $(INCPG) -o $@ $<

all: try


try: try.o
$(CC) -o $@ $^ -L $(LIBPG) $(LIBSPG)

clean:
-rm -f *.o core