- 论坛徽章:
- 0
|
test.pc
#include
#include "sqlca.h"
int connect_db( char *_dbname )
{
char sdb_name[60+1];
EXEC SQL BEGIN DECLARE SECTION;
char dbname[20+1];
cha r username[20+1];
char password[20+1];
EXEC SQL END DECLARE SECTION;
memset( dbname, 0x00, sizeof(dbname) );
memset( username, 0x00, sizeof(username) );
memset( password, 0x00, sizeof(password) );
sprintf( sdb_name, "%.60s", _dbname );
strcpy( username, strtok(sdb_name, "/") );
strcpy( password, strtok(NULL, "@") );
strcpy( dbname, strtok(NULL, "@") );
EXEC SQL CONNECT :username IDENTIFIED BY :password USING :dbname;
if( sqlca.sqlcode )
{
return -1;
}
return 0;
}
int main()
{
int ret=0;
ret = connect_db(
[email=username/password@dbname]username/password@dbname[/email]
);
if (ret)
{
printf("Connect ERROR\n");
}
else
{
printf("Connect SUCCESS !!!\n");
}
return 0;
}
==========================
makefile
=========================
.SUFFIXES: .pc .c .o
.c.o:
$(CC) -c $(DFLAG) $(INCL) $
.pc.o:
#$(PROC) $(INCL_PC) $(PROCFLAGS) iname=$
VPATH=..:.
BINDIR= ../../bin
LIBDIR= ../../lib
LIB= -L$(LIBDIR) -L$(ORACLE_HOME)/lib -lclntsh
INCL_PC= include=/usr/include \
include=$(ORACLE_HOME)/precomp/public \
DFLAG= -q64 -DORACLE
INCL= -I../../include -I$(ORACLE_HOME)/precomp/public -I$(ORACLE_HOME)/rdbms/public
PROC=proc
CC=cc -q64
OBJT=test.o
all: clear test
clear:
@rm -f *.c
@rm -f *.lis
@rm -f *.o
test:$(OBJT)
$(CC) -o $@ $(?) $(LIB)
@chmod a+x $@
@echo "\033[7m Load $@ Successful!! \033[27m"
[email=#@mv]@mv[/email]
$@ ../../bin
@rm $?
=======================================================
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/73539/showart_2121410.html |
|