Home » Developer & Programmer » JDeveloper, Java & XML » Connection problem with Pro*C/C++
Connection problem with Pro*C/C++ [message #366581] Thu, 27 May 1999 12:52 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
Please help !!!

I’m trying to run an a c/c++ program using Pro*C/C++, I’m clicking the “rebuilt all” on the “build” menu and I get following error:

Deleting intermediate files and output files for project 'Cv_demo - Win32 Debug'.
--------------------Configuration: Cv_demo - Win32 Debug--------------------
Performing Custom Build Step on .\CV_DEMO.PC
SQL*Plus: Release 8.0.5.0.0 - Production on Thu May 27 12:6:26 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.
ERROR:
ORA-12203: TNS:unable to connect to destination
Enter user-name:
Pro*C/C++: Release 8.0.5.0.0 - Production on Thu May 27 12:6:27 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Message 1024 not found; No message file for product=pro80, facility=PGOd:\apps\ORANT\pro80\pcscfg.cfg
PCC-F-02104, Unable to connect to Oracle
Error executing c:\winnt\system32\cmd.exe.

CV_DEMO.exe - 1 error(s), 0 warning(s)

I tried to recompile CV_DEMO.PC in Proc*C/C++ and it compiled ok, however when I try to do this in C/C++ I get this error.

I will greatly appreciate it if any one can help me with this problem (I started with Pro*C/C++ last week).

I’m using : Oracle 7.3 and 8, Pro*C/C++ 8.0.5.00, Visual C++ 6.0

The CV_DEMO.PC is as follow:

#include <STDIO.H>
#include <STDLIB.H>
#include <SQLCA.H>

/* Error handling function. */
void sql_error(void)
{
EXEC SQL WHENEVER SQLERROR continue;
printf("%.70s\n", sqlca.sqlerrm.sqlerrmc);
exit(1);
}

void main()
{
char temp32;

EXEC SQL BEGIN DECLARE SECTION;
char db_string20 = "PROD";
char password20 = "highlander";
char userid 10 = "lsagi";
char db_name10 = "PROD";

SQL_CURSOR emp_cursor;
int dept_num;
struct
{
int emp_num;
char emp_name11;
char job10;
int manager;
char hire_date10;
float salary;
float commission;
int dept_num;
} emp_info;

struct
{
short emp_num_ind;
short emp_name_ind;
short job_ind;
short manager_ind;
short hire_date_ind;
short salary_ind;
short commission_ind;
short dept_num_ind;
} emp_info_ind;
EXEC SQL END DECLARE SECTION;

EXEC SQL WHENEVER SQLERROR do sql_error();

EXEC SQL DECLARE prod DATABASE;

/* Connect to Oracle. */

EXEC SQL CONNECT :userid IDENTIFIED BY :password
at :db_name using :db_string;

/* Allocate the cursor variable. */
EXEC SQL ALLOCATE :emp_cursor;

/* Exit the inner for (;;) loop when NO DATA FOUND. */
EXEC SQL WHENEVER NOTFOUND DO break;

for (;;)
{
printf("\nEnter department number (0 to exit): ");
gets(temp);
dept_num = atoi(temp);
if (dept_num <= 0)
break;

EXEC SQL EXECUTE
begin
emp_demo_pkg.open_cur(:emp_cursor, :dept_num);
end;
END-EXEC;

printf("\nFor department %d--\n", dept_num);
printf("ENAME\t SAL\t COMM\n");
printf("-----\t ---\t ----\n");

/* Fetch each row in the EMP table into the data struct.
Note the use of a parallel indicator struct. */
for (;;)
{
EXEC SQL FETCH :emp_cursor
INTO :emp_info INDICATOR :emp_info_ind;

printf("%s\t", emp_info.emp_name);
printf("%8.2f\t\t", emp_info.salary);
if (emp_info_ind.commission_ind != 0)
printf(" NULL\n");
else
printf("%8.2f\n", emp_info.commission);
}
}

/* Close the cursor. */
EXEC SQL CLOSE :emp_cursor;

exit(0);
}
Re: Connection problem with Pro*C/C++ [message #366584 is a reply to message #366581] Thu, 08 July 1999 08:28 Go to previous messageGo to next message
Lars O Sjöström
Messages: 25
Registered: May 1999
Junior Member
Do you reach thru SQL the user/password on that node?
Re: Connection problem with Pro*C/C++ [message #366588 is a reply to message #366581] Fri, 27 August 1999 09:17 Go to previous message
Jeff Kish
Messages: 5
Registered: August 1999
Junior Member
did you ever get an answer?
sound like you are configured to have the proc-c application do some queries to validate your sql dynamically, so you need to be logged into your database.

try your login dynamically to make sure it works, otherwise don't dynamically verify your sql.
HTH
Jeff
jeff.kish@ait-mmii.com
Previous Topic: jdbc thin and jdbc odbc differences oracle 7.3
Next Topic: wanting!!!!
Goto Forum:
  


Current Time: Thu Mar 28 02:55:29 CDT 2024