请问下面这段ADO连接Oracle8i数据库的程序问题出在哪儿??~(连不上!!)
(注:我需要的是ADO无DSN的连接!!)
'该程序先用ADO无DSN连接Oracle8i数据库,再将数据库与DataGrid控件相关联。)
Dim conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim str1 As String
Dim str2 As Stringstr1 = "driver={Oracle ODBC Driver};" & _
"server=服务器名;uid=用户名;pwd=密码;database=数据库名"str2 = "SQL语句"
conn.ConnectionString = str1
rst.ActiveConnection = conn
set rst.Open str2, conn
set DataGrid1.DataSource=rst ‘将数据库与DataGrid控件相关联
DataGrid1.refresh
(注:我需要的是ADO无DSN的连接!!)
'该程序先用ADO无DSN连接Oracle8i数据库,再将数据库与DataGrid控件相关联。)
Dim conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim str1 As String
Dim str2 As Stringstr1 = "driver={Oracle ODBC Driver};" & _
"server=服务器名;uid=用户名;pwd=密码;database=数据库名"str2 = "SQL语句"
conn.ConnectionString = str1
rst.ActiveConnection = conn
set rst.Open str2, conn
set DataGrid1.DataSource=rst ‘将数据库与DataGrid控件相关联
DataGrid1.refresh
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货