Re: Help needed on 'EXEC SQL CONNECT'

HI,
May be u need to trap the error message as following way...

/* Register sql_error() as the error handler. */

   EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE error--\n");

void sql_error(msg)
 char *msg;
{

    char err_msg[128];
    int buf_len, msg_len;

    EXEC SQL WHENEVER SQLERROR CONTINUE;         printf("SQLCODE =%ld\n",sqlca.sqlcode);     printf("\n%s\n", msg);
    buf_len = sizeof (err_msg);
    sqlglm(err_msg, &buf_len, &msg_len);     printf("%.*s\n", msg_len, err_msg);

    EXEC SQL ROLLBACK RELEASE;
    exit(1);
}
HTH,
Ashesh

In article <716vn4$ldp$1_at_minus.oleane.net>,   "sbe" <sbe_at_comx.fr> wrote:
> Hi,
>
> The first call my program is executing is an 'EXEC SQL CONNECT', but it
> never comes back from this call, the program crashes, and I can't get any
> error message.
>
> User and Password are OK, ORACLE_HOME and ORACLE_SID environement variables
> are also OK.
>
> Any suggestions ?
>
> Stephane Benteux. ( sbe_at_comx.fr )
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 30 1998 - 14:59:52 CST