我知道SQL Sever数据库的连接串可以这样子:
strConnect.Format("Provider=SQLOLEDB.1; Data Source=%s; Initial Catalog=%s; User ID=%s; PWD=%s","220.168.99.5,1234","jjxt","abc","pw");
但是Oracle的连接串应该怎么写啊?
高手帮帮忙啊~~~~~~~~在线等
strConnect.Format("Provider=SQLOLEDB.1; Data Source=%s; Initial Catalog=%s; User ID=%s; PWD=%s","220.168.99.5,1234","jjxt","abc","pw");
但是Oracle的连接串应该怎么写啊?
高手帮帮忙啊~~~~~~~~在线等
hr = m_pConnection.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
hr=m_pConnection->Open("Provider=OraOLEDB.Oracle;Data Source=IMAGEDB;user id=imagedb;password=123", "","",adModeUnknown);如果不行就新建一个文本文件,后缀改成*.udl
双击这个文件,会自动打开数据库连接对话框
在里面选择Oracle的驱动,
如果有密码,勾选允许保存密码
第二步测试连接,看看通不通,
确定,正确的连接字符串会保存到那个udl文件里面复制过来,这样得到的连接串还不能用就是你的ORACLE问题了
m_pConnection->Open("Provider=OraOLEDB.Oracle; Data Source=220.168.99.5,1234; Initial Catalog=jjxt; User ID=abc; PWD=pw","","",adModeUnknown):
或者是不要Initial Catalog=jjxt;?
m_pConnection->Open("Provider=OraOLEDB.Oracle; Data Source=220.168.99.5,1234; Initial Catalog=jjxt; User ID=abc; PWD=pw","","",adModeUnknown):IDispatch error #3105
用
m_pConnection->Open("Provider=OraOLEDB.Oracle; Data Source=220.168.99.5,1234; User ID=abc; PWD=pw","","",adModeUnknown): 未指定的错误
用
m_pConnection->Open("Provider=OraOLEDB.Oracle; Data Source=220.168.99.5,1234; user id=abc; password=pw","","",adModeUnknown): 未指定的错误
大哥帮帮忙嘎……~~~~~~~~~~~~
还有,请问我可以单独安装这些OLE DB 提供程序么?如果可以的话我应该到什么地方去下载呢?谢谢