Dim CON
Dim RS
Private Sub Form_Load()
Set CON=CreateObject("adodb.connection")
CON.Open "UID=CDITS;PWD=CDITS;driver={Microsoft ODBC for Oracle};SERVER=CDITS;"
Dim mysql As String
mysql = "select distinct(vid) from HTELEFEEINFORMATION where driverid=0 "
CON.Execute mysql
Set RS = CON.Execute(mysql)
Do While Not RS.EOF
Text1.Text = Text1.Text & RS("vid") & Chr(13) & Chr(10)
RS.MoveNext
Loop
End Sub 或
Conn.Open "PROVIDER=MSDAORA.1;Password=Test;User ID=TestUser;Data Source=LocalOracle;Persist Security Info=True"
Dim RS
Private Sub Form_Load()
Set CON=CreateObject("adodb.connection")
CON.Open "UID=CDITS;PWD=CDITS;driver={Microsoft ODBC for Oracle};SERVER=CDITS;"
Dim mysql As String
mysql = "select distinct(vid) from HTELEFEEINFORMATION where driverid=0 "
CON.Execute mysql
Set RS = CON.Execute(mysql)
Do While Not RS.EOF
Text1.Text = Text1.Text & RS("vid") & Chr(13) & Chr(10)
RS.MoveNext
Loop
End Sub 或
Conn.Open "PROVIDER=MSDAORA.1;Password=Test;User ID=TestUser;Data Source=LocalOracle;Persist Security Info=True"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货