Dim oleDbConnection1 As OleDb.OleDbConnection
Dim strConnect As String = "server=ORCL;Provider=MSDAORA;UserId=system;PASSWORD=manager;database=admin"
oleDbConnection1 = New System.Data.OleDb.OleDbConnection(strConnect)
Dim objDataSet As New DataSet
Dim strSql As String = "select userid,password from users;"
Dim objAdapter As OleDbDataAdapter = New OleDbDataAdapter(strSql, oleDbConnection1)
objAdapter.Fill(objDataSet, "users")
Dim objDataView As New DataView(objDataSet.Tables("users"))提示错误是:
ORA-01017: invalid username/password; logon denied 可是我在oracle下试过了admin,admin用户名和密码是一样的能进入数据库啊...怎么会是这个错误那..错误指向--->objAdapter.Fill(objDataSet, "users")
这里有错误??
到底是什么错误啊....救命啊....大侠帮帮我啊!!!!!
Dim strConnect As String = "server=ORCL;Provider=MSDAORA;UserId=system;PASSWORD=manager;database=admin"
oleDbConnection1 = New System.Data.OleDb.OleDbConnection(strConnect)
Dim objDataSet As New DataSet
Dim strSql As String = "select userid,password from users;"
Dim objAdapter As OleDbDataAdapter = New OleDbDataAdapter(strSql, oleDbConnection1)
objAdapter.Fill(objDataSet, "users")
Dim objDataView As New DataView(objDataSet.Tables("users"))提示错误是:
ORA-01017: invalid username/password; logon denied 可是我在oracle下试过了admin,admin用户名和密码是一样的能进入数据库啊...怎么会是这个错误那..错误指向--->objAdapter.Fill(objDataSet, "users")
这里有错误??
到底是什么错误啊....救命啊....大侠帮帮我啊!!!!!
连接字符串确认没有问题?
我作的是dataGrid数据绑定.可是到这里就出错了...错误如上...
到底什么地方出错了?????
Dim strConnect As String = "server=ORCL;Provider=MSDAORA;UserId=admin;PASSWORD=admin;Data Source=admin"就出现这个错误:ORA-12154: TNS:could not resolve service name
为什么啊?????服务开了啊?????
New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer;Uid=Username;Pwd=asdasd;"
Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;" server可以是odbc中系统DNS数据原的名称
选择表可以在sql语句中来写。如system.表名
我也用过OleDb连,但是没有成功,而用ODBC实现了。哪位可以说下用OleDb怎么连远程的oracle服务器,不是本机哈
http://www.able-consulting.com/ADO_Conn.htm