我看到可以用AT子句定义建立并发连接,不过没试过。语法如下:
EXEC SQL CONNETCT :username IDENTIFIED BY :password
[ AT {dbname|:host_varable }]
[ USING :server];
示例:
char usename[20],password[20],server[20,]temp[20];
EXEC SQL DECLARE system DATABASE; --定义ORACLE标识符
strcpy(username,"system");
strcpy(password,"manager");
strcpy(server,"orcl");
EXEX SQL CONNECT :username IDENTIFIED BY :password
AT system USING :server; --建立非默认连接
....
EXEC SQL AT system SELECT user INTO :temp FROM dual; --使用
printf("%s\n",temp);如果建立多个连接的话,把这个连接写成一个连接函数,可以多次调用;
EXEC SQL CONNETCT :username IDENTIFIED BY :password
[ AT {dbname|:host_varable }]
[ USING :server];
示例:
char usename[20],password[20],server[20,]temp[20];
EXEC SQL DECLARE system DATABASE; --定义ORACLE标识符
strcpy(username,"system");
strcpy(password,"manager");
strcpy(server,"orcl");
EXEX SQL CONNECT :username IDENTIFIED BY :password
AT system USING :server; --建立非默认连接
....
EXEC SQL AT system SELECT user INTO :temp FROM dual; --使用
printf("%s\n",temp);如果建立多个连接的话,把这个连接写成一个连接函数,可以多次调用;
来给大家共享:
网址http://www.xpbook.com/download.asp?id=1263&dp=2