t = Format(Now(), "yyyymmdd")
tt = PATH1 & "\" & t & ".dbf"
If Dir(tt, vbHidden) = "" Then '' 判断文件是否存在
Label2.Caption = Now() & " 1#生产数据库连接失败!"
Label2.ForeColor = vbRed
Exit Sub
Else
t = Format(Now(), "yyyymmdd")
End If
If (dbcon.State <> 1) Then
Set dbcon = New ADODB.Connection
str = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" & PATH1 & ";SourceType=DBF;"
dbcon.CursorLocation = adUseClient
On Error Resume Next
dbcon.Open str ''打开A楼数据库
If dbcon.State <> 1 Then
Label2.Caption = Now() & " 1#生产数据库连接失败!"
Label2.ForeColor = vbRed
Exit Sub
Else Label2.Caption = Now() & " 1#生产数据库连接成功!"
Label2.ForeColor = vbWhite
End If
End If
Set db_rs = New ADODB.Recordset
sql = "select * from " & tt & " order by SJ"
db_rs.Open sql, dbcon, adOpenKeyset, adLockOptimistic
If db_rs.RecordCount > 0 Then
db_rs.MoveFirst
Do While Not db_rs.EOF
pTime = Trim(db_rs.Fields("SJ"))
GCMC = Trim(db_rs.Fields("GCMC"))
If Trim(db_rs.Fields("GCBW")) <> "" Then
GCBW = Trim(db_rs.Fields("GCBW"))
Else
GCBW = ""
End If
db_rs.MoveNext
Loop
db_rs.RecordCount > 0 这句提示数据提供程序或其他服务返回 E_FAIL 状态
tt = PATH1 & "\" & t & ".dbf"
If Dir(tt, vbHidden) = "" Then '' 判断文件是否存在
Label2.Caption = Now() & " 1#生产数据库连接失败!"
Label2.ForeColor = vbRed
Exit Sub
Else
t = Format(Now(), "yyyymmdd")
End If
If (dbcon.State <> 1) Then
Set dbcon = New ADODB.Connection
str = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" & PATH1 & ";SourceType=DBF;"
dbcon.CursorLocation = adUseClient
On Error Resume Next
dbcon.Open str ''打开A楼数据库
If dbcon.State <> 1 Then
Label2.Caption = Now() & " 1#生产数据库连接失败!"
Label2.ForeColor = vbRed
Exit Sub
Else Label2.Caption = Now() & " 1#生产数据库连接成功!"
Label2.ForeColor = vbWhite
End If
End If
Set db_rs = New ADODB.Recordset
sql = "select * from " & tt & " order by SJ"
db_rs.Open sql, dbcon, adOpenKeyset, adLockOptimistic
If db_rs.RecordCount > 0 Then
db_rs.MoveFirst
Do While Not db_rs.EOF
pTime = Trim(db_rs.Fields("SJ"))
GCMC = Trim(db_rs.Fields("GCMC"))
If Trim(db_rs.Fields("GCBW")) <> "" Then
GCBW = Trim(db_rs.Fields("GCBW"))
Else
GCBW = ""
End If
db_rs.MoveNext
Loop
db_rs.RecordCount > 0 这句提示数据提供程序或其他服务返回 E_FAIL 状态
解决方案 »
- 谁能帮我解释这几句代码(关于WMI的) 谢谢
- 高分求救:VB复制文件问题,在线苦等
- VB6编译程序误报木马的解决方案求教
- 怎么样能在VB程序中播放动态的GIF?
- 一个十分头痛的问题
- 关于access数据库的问题???
- 请问怎样用 ado 连接 *.dbf 和 *.xml 文件 ???
- 关于Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'CMailCOM.Admin.1' 错误解决的方法
- 陈辉老师:知道我做的有点过分
- 怎样在程序中得到在资源管理器中选中的文件???
- vb只能跨进程子类,才能得到另一个进程的消息吗?
- 我菜鸟一个,想学VB 希望高手给我建议或教程 谢谢!!
这个表里是不是真的有数据
db_rs.RecordCount > 0 这句提示数据提供程序或其他服务返回 E_FAIL 状态
不是路径名
DBF 数据库,数据库名就是路径名,文件名才是表名
还是连接参数的问题改为
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + PATH1 + ";Extended Properties=dBASE IV;User ID=Admin;Password="