Re: libpq connectivity

anuj wrote:
>
> Hello,
>
> I am working on Linux RH 6.0 platform.
> I want use PostgreSQL as a backend. 'C' language as a front-end.
> I am not able to connect to each other.
> I am using libpq.
> The program is :-
>
> /*conn2.c*/
> #include <stdio.h>
> #include "/usr/include/pgsql/libpq-fe.h"
> main()
> {
> char *pghost, *pgport, *pgoptions,*pgtty;
> char *dbName;
> PGconn *conn;
> pghost = NULL; /* host name of the backend server */
> pgport = NULL; /* port of the backend server */
> pgoptions = NULL; /* special options to start up the backend
> * server */
> pgtty = NULL; /* debugging tty for the backend server */
> dbName = "template1";
>
> /* make a connection to the database */
> conn = PQsetdb(pghost, pgport, pgoptions, pgtty, dbName);
> }
>
> The compiling is ok, but linking have error.
> $ gcc conn2.c -c -o conn2
> No error
>
> The program compile and linking result :-
> *****************
> $ gcc conn2.c -o conn2
> /tmp/cchKU26L.o: In function `main':
> /tmp/cchKU26L.o(.text+0x47): undefined reference to `PQsetdbLogin'
> collect2: ld returned 1 exit status
> *****************
>
> How to remove this linking error, or how to make link between PostgreSQL and
> 'C'?
> Thanks in advance
> Anuj

You have to include the libraries. -lpq
--
Dave Smith
Candata Systems Ltd.
(416) 493-9020
dave(at)candata(dot)com