Обсуждение: Database connectivity using ECPG

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

On 7/13/06, Jasbinder Bali <jsbali@gmail.com> wrote:
> Hi,
>
> I'm using ECPG to connect to my postgres database. Doing it for the very
> first time in my life.
>
>  In function `main':ecpg_test.c:(.text+0x5d): undefined
> reference to `ECPGconnect'

it looks like you are not linking to the ecpg library.  you need to
build it and link to it i think.  i don't know off the top of my head
if you can get ecpg library without building from source.

merlin

On Thu, 13 Jul 2006 13:22:49 -0400
"Jasbinder Bali" <jsbali@gmail.com> wrote:

> 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
>

It has been my impression that PosgreSQL REALLY likes to know who it's
talking to.  I'd include a user name with my connection string at the
least.

John Purser

--
Learn to pause -- or nothing worthwhile can catch up to you.

Hi Jasbinder,

You will have to build the libecpg lib from source first and then you can build your C source (got from .pgc file using ecpg) using something like this:

cc -I <postgres include folder> -c sample.c
cc -o sample sample.o -L <folder where libecpg is located> -lecpg

Thanks,

Shoaib Mir
EnterpriseDB