数据库怎么联接啊,下面这个哪里有问题啊?我的是ORACLE10g visualstdio2008 vb.net project Dim data As OleDb.OleDbDataReader
Dim connStr As String = "Provider=MSDAORA;Data Source=SYDB;User Id=tengy;Password=tengy;"
Dim strSel As String
strSel = "select * from w_test t"
Dim myconn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
Dim mycomm As OleDb.OleDbCommand = New OleDb.OleDbCommand(strSel, myconn)
mycomm.Connection.Open()
data = mycomm.ExecuteReader()
Dim connStr As String = "Provider=MSDAORA;Data Source=SYDB;User Id=tengy;Password=tengy;"
Dim strSel As String
strSel = "select * from w_test t"
Dim myconn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
Dim mycomm As OleDb.OleDbCommand = New OleDb.OleDbCommand(strSel, myconn)
mycomm.Connection.Open()
data = mycomm.ExecuteReader()
这个t是干嘛的??
是这里面没有写好,好像少什么东西,或没有配置好吧.
哪位高人有更好的联接数据库的方法发来看看哇,最好有注释哦,,要倒什么文件,什么包的
这里面很全的
去掉之后直接加上connStr.open()
那个怎么能OPEN呢,那个不可以
DataSet ds = new DataSet();
da.Fill(ds);1、客户机上装有Oracle客户端;
2、Oracle的连接字符串里没有Provider项;
3、凡是涉及到DataAdapter的代码,你不用手动打开或关闭连接,DataAdapter会自动帮你打开/关闭数据库连接。
Dim data As OleDb.OleDbDataReader
Dim connStr As String = "Provider=MSDAORA;Data Source=SYDB;User Id=tengy;Password=tengy;"
Dim strSel As String
strSel = "select * from w_test t"
Dim myconn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
myconn.Open()
Dim mycomm As OleDb.OleDbCommand = New OleDb.OleDbCommand(strSel, myconn)
data = mycomm.ExecuteReader()
Dim connStr As String = "Provider=MSDAORA;Data Source=SYDB;User Id=tengy;Password=tengy;"
Dim strSel As String
strSel = "select * from w_test t"
Dim myconn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
mycomm.Connection.Open()
Dim mycomm As OleDb.OleDbCommand = New OleDb.OleDbCommand(strSel, myconn)
data = mycomm.ExecuteReader()
建议用装 OO4O 或者 ODP.NET
Dim connStr As String = "Server=(local);Data Source=SYDB;User Id=tengy;Password=tengy;"
Dim strSel As String
strSel = "select * from w_test t"
Dim myconn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
Dim mycomm As OleDb.OleDbCommand = New OleDb.OleDbCommand(strSel, myconn)
myconn.Open()
data = mycomm.ExecuteReader()可以么?
Provider=MSDAORA