试试下面这样!EXEC SQL BEGIN DECLARE SECTION;
char *username = "sys@my_10.200.1.195";
char *password = "123";
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT :username IDENTIFIED BY :password ;
char *username = "sys@my_10.200.1.195";
char *password = "123";
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT :username IDENTIFIED BY :password ;
解决方案 »
- 请教:SQL语句
- 安装oracle ,SQL developer不能用 但是SQL plus可以用
- 用ADO连接ORACLE时,报错信息为:ORA-12154
- 求一条SQL语句
- 如何使用sql生成一个状态的列
- 关于数据库死锁问题,用PLSQL Developer 执行for update后,出现死锁现象,请问怎么解决啊?
- 求教索引专家: 终于找到查询缓慢的原因了? 但不知该如何解决!
- 在函数里面能不能实现查询?就是能不能在函数里写select语句查询,而不是select into 的赋值语句?
- oracle 9i 怎么备份数据库的的?进来告诉我一下吧
- oracle安装问题
- 请教各位,一个链表如何用数据库来存贮呢?
- 如何把一个字段的数据移到另一个字段???
我的oracle的sid=my,ip=10.200.1.195
BJSR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
2) pc代码片断:EXEC SQL BEGIN DECLARE SECTION;
VARCHAR uid[80]; /* username */
VARCHAR pwd[20]; /* password */int empno; /* employee number */
VARCHAR ename[15]; /* employee name */
int deptno; /* department number */
VARCHAR dname[15]; /* department name */VARCHAR job[15]; /* employee job */
int sal; /* employee salary */
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE SQLCA.H;void main()
{
strcpy((char *)uid.arr,"SCOTT@bjsr");
uid.len = (short) strlen((char *)uid.arr);
strcpy((char *)pwd.arr,"TIGER");
pwd.len = (short) strlen((char *)pwd.arr); EXEC SQL WHENEVER SQLERROR GOTO errexit;
EXEC SQL CONNECT :uid IDENTIFIED BY :pwd; ...
}