Re: core dump using Pro*C on CONNECT
From: Bit Twister <BitTwister_at_localhost.localdomain>
Date: Thu, 24 Jul 2003 18:42:52 GMT
Message-ID: <slrnbi0a15.3sh.BitTwister_at_wb.home>
>
> EXEC SQL CONNECT :Username IDENTIFIED BY :Userpass AT DB_NAME
> USING :DBname;
>
>
> if (sqlca.sqlcode != 0)
> {
> sprintf(Log_Msg, "Error %d (%s) Connecting Database
> ",sqlca.sqlcode,sqlca.sqlerrm);
> Log_Message(Waste_Log, "pods_init", FATAL, Log_Msg);
> }
> else
> {
> sprintf(Log_Msg, "Connection to Database Successful");
> Log_Message(Waste_Log, "pods_init", INFORM, Log_Msg);
> };
>
> I am running on HP-UX 10.2, ORACLE = 8.0.5
>
> I get core dumped on me after the CONNECT statement.
Date: Thu, 24 Jul 2003 18:42:52 GMT
Message-ID: <slrnbi0a15.3sh.BitTwister_at_wb.home>
On Thu, 24 Jul 2003 18:09:51 +0000, thumor wrote:
>
> Line of code in my Pro*C file:
>
><--BEGIN-->>
>
> strcpy(Username, user_id);
> strcpy(Userpass, user_pw);
> strcpy(DBname, db_name);
>
> strcat(Username, '\0');
> strcat(Userpass, '\0');
> strcat(DBname, '\0');
>
> EXEC SQL CONNECT :Username IDENTIFIED BY :Userpass AT DB_NAME
> USING :DBname;
>
>
> if (sqlca.sqlcode != 0)
> {
> sprintf(Log_Msg, "Error %d (%s) Connecting Database
> ",sqlca.sqlcode,sqlca.sqlerrm);
> Log_Message(Waste_Log, "pods_init", FATAL, Log_Msg);
> }
> else
> {
> sprintf(Log_Msg, "Connection to Database Successful");
> Log_Message(Waste_Log, "pods_init", INFORM, Log_Msg);
> };
><--- End -->
>
> I am running on HP-UX 10.2, ORACLE = 8.0.5
>
> I get core dumped on me after the CONNECT statement.
Well, set a debug breakpoint on both sprintf lines and tell us which line causes the core.
PS:
I use something like
Userpass.len = sprintf (userpass.arr, "%s", user_pw) ; to load varchar strings. Received on Thu Jul 24 2003 - 20:42:52 CEST