我是用的VS2010访问oracle 11g,oracle自带 OCI,我按照网上说的下载了occivc10_11202_win64.zip,解压到OCI目录下OCI\lib\MSVC\vc10,并且按照网上说的,加载库函数和头文件;但是总出问题,说找不到文件
#include
#include
using namespace std;
using namespace oracle::occi;
void main(){
try{
Environment env=Environment::createEnvironment();
cout<<"success-------Environment"<
Connection *conn=env->createConnection("hr","12345","localhost:1521/orcl");
cout<<"success-------Connection"<<endl;
/*string sql="select * from emp where employee_id=119";/
string sql="insert into emp values ('207','zhang','9800')";
Statement *stmt=conn->createStatement(sql);
stmt->executeUpdate();
cout<<"success-------insert"<
env->terminateConnection(conn);
Environment::terminateEnvironment(env);
}
catch(SQLException &e){
cout<<e.what()<<endl;
}
}
编译后总是出问题,出现两个error LNK2019: 无法解析的外部符号
1>OCITest.obj : error LNK2019: 无法解析的外部符号 "public: static void cdecl oracle::occi::Environment::terminateEnvironment(class oracle::occi::Environment *)" (?terminateEnvironment@Environment@occi@oracle@@SAXPAV123@@Z),该符号在函数 _main 中被引用
1>OCITest.obj : error LNK2019: 无法解析的外部符号 "public: static class oracle::occi::Environment * __cdecl oracle::occi::Environment::createEnvironment(enum oracle::occi::Environment::Mode,void *,void * (cdecl*)(void ,unsigned int),void * (__cdecl)(void ,void *,unsigned int),void (__cdecl)(void *,void *))" (?createEnvironment@Environment@occi@oracle@@SAPAV123@W4Mode@123@PAXP6APAX1I@ZP6APAX11I@ZP6AX11@Z@Z),该符号在函数 _main 中被引用
1>C:\Users\asus\documents\visual studio 2010\Projects\OCCITest2\Debug\OCCITest2.exe : fatal error LNK1120: 2 个无法解析的外部命令