Skip site navigation (1) Skip section navigation (2)

[INTERFACES] Use ecpg

From: Margarita Barvinok <brita(at)math(dot)lsa(dot)umich(dot)edu>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES] Use ecpg
Date: 1999-01-28 15:16:00
Message-ID: Pine.SOL.3.96-4hack.990128091535.15513B-100000@sewerurchin.math.lsa.umich.edu (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello All,

I just began to use postgresql-6.4.2 and ecpg (version: 2.4.4).
I try t precompile simple
code ( I took it from a book) and get this error message:
prog:17: parse error
Perhaps this is stupid error, but I have no idea what to do, because I
don't have good manual on Embedded SQL. Can I find somewhere
documentation on C-Embedded SQL?
Thanks, in advance, for any help.

-Margarita Barvinok

File prog:

/*  *********************************************************** */
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
 
#define FAILURE 1
#define SUCCESS 0
 
void printError(void);
 
/* define the communication region   */
EXEC SQL INCLUDE sqlca;
 
int main()
{
  /* set error handler to bail out if we can't connect */
  EXEC SQL WHENEVER SQLERROR
    {                                            /* LINE 17     */
    printError();
    return FAILURE;
    };
 
  /* Connect to the database  */
  EXEC SQL CONNECT USER "dba" IDENTIFIED BY "sql";
  printf("test");
  EXEC SQL DISCONNECT;
  return SUCCESS;
}
/*
* printError()
* function to print a description of any SQL errors
*/
void printError()
{
  static char buffer[200];
  printf("SQL error -- %s\n", buffer,
          sqlerror_message( &sqlca, buffer, sizeof(buffer)));
}

/* ******************************************************************* */






Responses

pgsql-interfaces by date

Next:From: James ThompsonDate: 1999-01-28 16:36:30
Subject: Re: [INTERFACES] Use ecpg
Previous:From: Pavel PaJaSoft JanousekDate: 1999-01-28 12:43:22
Subject: EGCS & password connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group