装的oracle10g,创建数据库oradb,能用plsql developer连接上,用plsql developer创建了用户dbcr,密码dbcr.
下面是连接对象的代码
//读取ini文件,保存了数据库名字oradb,用户名字dbcr和用户密码dbcr
GetPrivateProfileString("General","数据库数据源","",DBsourse.GetBuffer(200),200,strFileName);
DBsourse.ReleaseBuffer();
GetPrivateProfileString("General","数据库用户","",DBname.GetBuffer(200),200,strFileName);
DBname.ReleaseBuffer();
GetPrivateProfileString("General","数据库密码","",DBpassword.GetBuffer(200),200,strFileName);
DBpassword.ReleaseBuffer();
//连接数据库
::CoInitialize(NULL);
try
{
CString str;
str.Format("Provider=OraOLEDB.Oracle.1;Password=%s;Persist Security Info=True;User ID=%s;Data Source=%s",
DBpassword,DBname,DBsourse);
_bstr_t strConnect=str;
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch (_com_error e)
{
MessageBox(e.Description());
return;
}
m_pConnection->Open 就是连接不上,弹出MessageBox。用ActiveX 控件Microsoft ADO DATA Control 能连接上,创建的连接字符串和m_pConnection一样,为什么m_pConnection连不上?求解!!!
下面是连接对象的代码
//读取ini文件,保存了数据库名字oradb,用户名字dbcr和用户密码dbcr
GetPrivateProfileString("General","数据库数据源","",DBsourse.GetBuffer(200),200,strFileName);
DBsourse.ReleaseBuffer();
GetPrivateProfileString("General","数据库用户","",DBname.GetBuffer(200),200,strFileName);
DBname.ReleaseBuffer();
GetPrivateProfileString("General","数据库密码","",DBpassword.GetBuffer(200),200,strFileName);
DBpassword.ReleaseBuffer();
//连接数据库
::CoInitialize(NULL);
try
{
CString str;
str.Format("Provider=OraOLEDB.Oracle.1;Password=%s;Persist Security Info=True;User ID=%s;Data Source=%s",
DBpassword,DBname,DBsourse);
_bstr_t strConnect=str;
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch (_com_error e)
{
MessageBox(e.Description());
return;
}
m_pConnection->Open 就是连接不上,弹出MessageBox。用ActiveX 控件Microsoft ADO DATA Control 能连接上,创建的连接字符串和m_pConnection一样,为什么m_pConnection连不上?求解!!!
解决方案 »
- 问个弱智的问题,rman恢复目录数据库是实时运行的吗
- 菜鸟求助:oracle 10g的net configuration assistant 选择本地net服务名配置时,点击下一步没反应怎么回事?oracle net manager的本地/服务命名下为空,无法创建net服务名是怎么回事?
- oracle10 start with报错.路过请进.
- 请教SQL语句
- ORACLE监听程序的异常,求助各位
- 查看Oracle数据库操作
- 安装完oracle,不知道怎么连接数据库
- 一个触发器的问题?
- 这个insert语句该如何写?
- 如何查看oracle11g在何时进行了表空间扩展
- 紧急求助!怎么把dmp文件成功导入??
- oracle User/IO很高问题???
只是把str.Format("Provider=OraOLEDB.Oracle.1;Password=%s;Persist Security Info=True;User ID=%s;Data Source=%s",DBpassword,DBname,DBsourse);
替换成str.Format("Provider=OraOLEDB.Oracle.1;Password=dbcr;Persist Security Info=True;User ID=dbcr;Data Source=oradb");
连接没有问题。
之后又换回原来的str.Format("Provider=OraOLEDB.Oracle.1;Password=%s;Persist Security Info=True;User ID=%s;Data Source=%s",DBpassword,DBname,DBsourse);
以后连接都成功。迷惑了。?