Connecting to Oracle from a ProC program.

Hi..

I was wondering if anyone could help me in this problem. I'm very simply trying to connect up to my Oracle 8 server by calling from my ProC program but after returning it my username and password, it keeps going back in a loop and prompting me for my username and password again. The C program to do that is below:-

void connect()
{

	char user_name[MAXSIZE];
	char passwd[MAXSIZE];
	

   	printf("Please Enter USERNAME\n");
   	scanf("%s", user_name);
   	strncpy((char *) SQL_username.arr, user_name, MAXSIZE);
	SQL_username.len = strlen((char *) SQL_username.arr);

	printf("Please Enter Oracle PASSWORD\n");
   	scanf("%s", passwd);
	strncpy((char *) SQL_passwd.arr, passwd, MAXSIZE);
	SQL_passwd.len = strlen((char *) SQL_passwd.arr);

	EXEC SQL WHENEVER SQLERROR DO sqlerror("Cannot connect to ORACLE database!");

	EXEC SQL CONNECT :SQL_username IDENTIFIED BY :SQL_passwd;
	printf("\nConnected to Oracle as user: %s\n", SQL_username.arr);

A sqlnet.log file is then generated with the errors in it.

Any ideas or suggestions will be greatly appreciated. Thanks

James. Received on Thu Mar 05 1998 - 00:00:00 CET