- 论坛徽章:
- 0
|
我用secure CRT登陆到指定的LINUX 9I服务器上
进行PROC 编程,当我程序:
- #include <stdio.h>
- #include <sqlca.h>
- #include <string.h>
- #include <stdlib.h>
- #include <time.h>
- #include <pthread.h>
- #include <unistd.h>
- /* EXEC SQL INCLUDE SQLCA;*/
- void connect_oracle()
- {
- char strusername[20];
- char strpassword[20];
- char stralias[20];
- char v_name[20];
- EXEC SQL INCLUDE SQLCA;
- EXEC SQL BEGIN DECLARE SECTION;
- VARCHAR varusername[30];
- VARCHAR varpassword[30];
- VARCHAR varUserName[30];
- VARCHAR varename[20];
- int varno=7926;
- EXEC SQL END DECLARE SECTION;
- memset(v_name,'\0',sizeof(v_name));
- strcpy(strusername,"scott");
- strcpy(strpassword,"tiger");
- strcpy(stralias,"test");
- strcpy(v_name,"RABIT");
- strusername[strlen(strusername)]='\0';
- strpassword[strlen(strpassword)]='\0';
- stralias[strlen(stralias)]='\0';
- sprintf((char *)varUserName.arr, "%s/%s@%s", strusername, strpassword, stralias); /*EdVCA,=S4.*/
- varUserName.len = strlen((char *)varUserName.arr);
- sprintf((char *)varename.arr,"%s",v_name);
-
- varename.len=strlen((char *)varename.arr);
-
- EXEC SQL WHENEVER SQLERROR goto sqlerror;
- EXEC SQL CONNECT :varUserName;
- printf("\nconnect oracle succ\n");
- EXEC SQL UPDATE EMP SET ENAME=:varename where EMPNO=:varno;
- EXEC SQL COMMIT RELEASE;
-
- sqlerror:
- EXEC SQL WHENEVER SQLERROR CONTINUE;
- printf("\n%s\n",sqlca.sqlerrm.sqlerrmc);
- EXEC SQL ROLLBACK WORK RELEASE;
- }
- main()
- {
- printf("connect oracle server\n");
- connect_oracle();
- printf("conect server ok\n");
-
- }
复制代码
编译后提示:could not resolve service name (无法解析服务器名)
请问如何解决!!! |
|