我使用ADO连接oracle数据库,连接代码如下:
m_pConnection->Open((_bstr_t)("Provider='OraOLEDB.Oracle';Data Source='myname';User ID='sys';Password='mypasswd';"), "", "", adConnectUnspecified);
出现如下错误提示:Description = ORA-28009: connection to sys should be as sysdba or sysoper我把User ID改成'sysdba'则又提示: Description = ORA-01017: invalid username/password;logon denied安装数据库的时候上面不是有说SYS就是它的管理员用户吗?我刚刚接触oracle数据库,特请教高手!谢谢!
m_pConnection->Open((_bstr_t)("Provider='OraOLEDB.Oracle';Data Source='myname';User ID='sys';Password='mypasswd';"), "", "", adConnectUnspecified);
出现如下错误提示:Description = ORA-28009: connection to sys should be as sysdba or sysoper我把User ID改成'sysdba'则又提示: Description = ORA-01017: invalid username/password;logon denied安装数据库的时候上面不是有说SYS就是它的管理员用户吗?我刚刚接触oracle数据库,特请教高手!谢谢!
选择“本地net服务器配置”》服务名:oratest》最后新建网络服务》net_oratest,
通过odbc 选择net_oratest,选择服务器密码,看看odbc的testconnection能不能成功