chenyu5188(来自东方的狼),你好。我使用你关于如何使用ado打开dbf自由表的源代码,按F5启动时系统老是提示:
实时错误'-2147327865(80040e37)':
[Microsoft][ODBC Visual FoxPro Driver]File 'ccmon04.dbf' does not exits.
在rs.Open "select * from Ccmon04.dbf", cn, adOpenKeyset, adLockBatchOptimistic行我的源代码如下:Private Sub QueryCommand_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cnstr As String
cnstr = "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=" & App.Path & "\data" & _
"Exclusive=No"
cn.Open cnstr
rs.CursorLocation = adUseClient
rs.Open "select * from Ccmon04.dbf", cn, adOpenKeyset, adLockBatchOptimistic
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
实时错误'-2147327865(80040e37)':
[Microsoft][ODBC Visual FoxPro Driver]File 'ccmon04.dbf' does not exits.
在rs.Open "select * from Ccmon04.dbf", cn, adOpenKeyset, adLockBatchOptimistic行我的源代码如下:Private Sub QueryCommand_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cnstr As String
cnstr = "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=" & App.Path & "\data" & _
"Exclusive=No"
cn.Open cnstr
rs.CursorLocation = adUseClient
rs.Open "select * from Ccmon04.dbf", cn, adOpenKeyset, adLockBatchOptimistic
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
End Sub
解决方案 »
- listview 如何设置每列宽度
- 请问:要用户在程序中输入时间,用什么控件好?
- 请教各位,谢谢!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 一个CHECKBOX,一个LISTVIEW,如何实现在CHECKBOX上打勾后,LISTVIEW的各项被全部选中。。。
- 我想做个用户控件,但思路不明确,集思广益欢迎进来指点,做好后,我将其整理成文档跟大家共享
- 关于窗体重载问题
- 类似于腾讯新闻等自动在桌面打开的小页面,如何实现呢?
- 如何转换控件焦点?在线等待,分不够可再加!!
- 怎样用一个API下载文件?
- 恳求大家帮助:1 vsflexGrid 如何只能让某些特定列可编辑?2:一个Ado 的记录集Update, 如果记录集是关联出来的,只想更新其中的一个表
- 送分!请教初级问题(关于vba打包,能提供有价值线索者均有分)
- 请教打印换页
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBF;"
DBPath = "SourceDB=" & app.path & "\Dbf"
' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源,参数二为Connection对象
rs.Open "Select * From sample", conn, 2, 2
%>
打个比方。如果你的VB工程文件存放的目录为d:\myprg,那么数据文件应放在
d:\myprg\data目录下你再试试。
还专在D盘上专了个myprg目录,结果还是一样:(会不会和dbf文件的版本用关呢?狼兄,我刚开始学VB,能不能介绍一些关于ado应该方面的文章,我看msdn里关于ado的很晕啊!郁闷中!!:(
<%
' 建立Connection 对象
Set conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Visual FoxPro Driver};"
SourceType = "SourceType=DBC;"
DBPath = "SourceDB=" & Server.MapPath( "Dbf/Sample.dbc" ) ' 调用Open 方法连接数据库
conn.Open Driver & SourceType & DBPath Set rs = Server.CreateObject("ADODB.Recordset")
' 打开数据源,参数二为Connection对象
rs.Open "Select * From sample", conn, 2, 2
Set conn = Server.CreateObject("ADODB.Connection")
老是提示424错误!