Ê·ÉÏ×î¼òµ¥ÔªµÄpro*c³ÌÐò
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
EXEC SQL include sqlca;
EXEC ORACLE OPTION (RELEASE_CURSOR = YES);
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20];
VARCHAR password[20];
EXEC SQL END DECLARE SECTION;
void sql_error()
{
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("\n Oracle error detected:\n");
printf("\n%.70s\n",sqlca.sqlerrm.sqlerrmc);
EXEC SQL ROLLBACK RELEASE;
exit(1);
}
main()
{
strcpy(username.arr,"gdnum_true");
strcpy(password.arr,"gdnumtrue_10");
username.len=strlen(username.arr);
password.len=strlen(password.arr);
EXEC SQL CONNECT :username IDENTIFIED BY :password;
prin
Ïà¹ØÎĵµ£º
½âÎöHostsÎļþ
ºÜ¶àÓû§¶¼ÖªµÀÔÚWindowϵͳÖÐÓиöHostsÎļþ£¨Ã»Óкó׺Ãû£©£¬ÔÚWindows98ϵͳϸÃÎļþÔÚWindowsĿ¼£¬ÔÚWindows2000/XPϵͳÖÐλÓÚC:\Winnt\System32\Drivers\Etc Ŀ¼ÖС£¸ÃÎļþÆäʵÊÇÒ»¸ö´¿Îı¾µÄÎļþ£¬ÓÃÆÕͨµÄÎı¾±à¼Èí¼þÈç¼Çʱ¾µÈ¶¼ÄÜ´ò¿ª¡£
ÓüÇʱ¾´ò¿ªhostsÎļþ£¬Ê×ÏÈ¿´¼ûÁËÎ ......
1.3 µ¥Ôª²âÊÔÄܲúÉúÄÄÐ©Ð§Òæ£¿
µ¥Ôª²âÊÔµÄÐ§ÒæÒѾµÃµ½¹ã·ºµÄÈÏͬ£¬ÏÖÔÚµÄÎÊÌâÒѾ²»ÊÇÓÐûÓбØÒª×ö£¬Öµ²»ÖµµÃ×ö£¬¶øÊÇÈçºÎ¶à¿ìºÃÊ¡µØ×öºÃµ¥Ôª²âÊÔ£¬ËùÒÔ£¬¹ØÓÚÐ§Òæ£¬ÕâÀïÖ»ÊǼòµ¥µÄ½éÉÜһϡ£
Ð§ÒæÒ»£¬±£Ö¤´úÂëÖÊÁ¿
Ö»Óе¥Ôª²âÊÔ²ÅÄÜÍêÕû¼ì²â´úÂëµ¥ÔªµÄ¹¦Ä ......
step one£º½«.pcÎļþÔ¤±àÒëΪ.c
[ecif@localhost zyctest]$ proc sample1.pc
ÏÔʾÐÅÏ¢£º
Pro*C/C++: Release 10.2.0.1.0 - Production on Tue Apr 13 14:07:05 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
&nbs ......