database connect in Pro*C

Keywords:database connection, pro*c error

Hi,

I am trying to run a Pro*C sample program that came with Oracle package, but it gets a connection error. As there is no error message returned from the program, I cannot figure out how to solve this problem. Actually this program worked before we did a system upgrading. We just upgraded our Unix OS from Solaris 2.6 to 2.7. Our Oracle database server 8.0.3 has been running on this unix workstation.

Could anyone advise me how to obtain the error msg and figure out the exact connection error that I got? In the source code of the sample file, there is a function to return the error msg, but it does not work on the connection error. The following is the source code of the function.

void
sql_error(msg)
char *msg;
{

    char err_msg[128];
    size_t buf_len, msg_len;

    EXEC SQL WHENEVER SQLERROR CONTINUE;     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(EXIT_FAILURE);

Thank you in advance.

Zhao Fu

 -- Received on Tue Dec 28 1999 - 02:57:18 CST