[GENERAL] Database connectivity using ECPG

[Jasbinder Bali]

Hi,

I'm using ECPG to connect to my postgres database. Doing it for the very first time in my life.

The name of my database is postgres and uses a trusted connection. So, i don't think it needs any authentication parameteres like a
user name and password.

I have the follwoing line of code in my .pgc file for the database connectivity:-

EXEC SQL CONNECT TO postgres;

after compiling my .c file, i get the following error

In function `main':ecpg_test.c:(.text+0x5d): undefined reference to `ECPGconnect'

Can any1 tell me wot is this all about???

EXEC SQL CONNECT TO postgres; gets converted to
{ ECPGconnect(__LINE__, 0, "postgres" , NULL,NULL , NULL, 0); }
after ECPG does its internal conversion from .pgc to .c

Regards,
~Jas