OLE DB Provider for Oracle (from Oracle).
For Standard security:
Collapse | Copy Code
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;"
"User Id=myUsername;Password=myPassword;");
For a Trusted connection:
OS Authenticated connect setting user ID to "/":
Collapse | Copy Code
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;"
"User Id=/;Password=;");
OS Authenticated connect using OSAuthent:
Collapse | Copy Code
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;")
Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.
For more information, see: Oracle Provider for OLE DB Developer's Guide.
求大神指导啊,好几天了,就是无法用系统的验证连接数据库(Administrator用户已经加入到SYSDBA组里面了的)
你不用ADO,使用OLEDE 使用者模板!你添加模板的时候,就叫你选择provider,登陆的id和密码,并且可以测试数据库连接,连接成功之后,就可以选择数据库中你要操作的表,最后确定,就可以了
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。