Public Function ConnectString() As String
'returns a DB ConnectString
ConnectString = "FileDSN=studentinfo.dsn;UID=sa;PWD="
End FunctionPublic Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
'executes SQL and returns Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(SQL)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE",UCase$(sTokens(0))) Then
cnn.Execute SQL
MsgString = sTokens(0) & " query successful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim$(SQL), cnn,adOpenKeyset,adLockOptimistic
'rst.MoveLast 'get RecordCount
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & " 条记录 "
End If
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "查询错误: " & Err.Description
Resume ExecuteSQL_Exit
End Function
然后在窗体模块中调用它我的material.dsn是这样的:通过sqlserver生成的
[ODBC]
DRIVER=SQL Server
UID=sa
Regional=Yes
StatsLogFile=D:\materialManage\STATS.LOG
StatsLog_On=Yes
QueryLogFile=D:\materialManage\QUERY.LOG
QueryLog_On=Yes
DATABASE=material_Manage
WSID=WANGJING
APP=Microsoft Open Database Connectivity
SERVER=(local)
Description=material file data source
'returns a DB ConnectString
ConnectString = "FileDSN=studentinfo.dsn;UID=sa;PWD="
End FunctionPublic Function ExecuteSQL(ByVal SQL As String, MsgString As String) As ADODB.Recordset
'executes SQL and returns Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(SQL)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE",UCase$(sTokens(0))) Then
cnn.Execute SQL
MsgString = sTokens(0) & " query successful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim$(SQL), cnn,adOpenKeyset,adLockOptimistic
'rst.MoveLast 'get RecordCount
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & " 条记录 "
End If
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "查询错误: " & Err.Description
Resume ExecuteSQL_Exit
End Function
然后在窗体模块中调用它我的material.dsn是这样的:通过sqlserver生成的
[ODBC]
DRIVER=SQL Server
UID=sa
Regional=Yes
StatsLogFile=D:\materialManage\STATS.LOG
StatsLog_On=Yes
QueryLogFile=D:\materialManage\QUERY.LOG
QueryLog_On=Yes
DATABASE=material_Manage
WSID=WANGJING
APP=Microsoft Open Database Connectivity
SERVER=(local)
Description=material file data source
解决方案 »
- VB中如何用API实现在任意计算机里面添加自定义大小的纸张?
- 数据库加密问题
- vb使用mscomm控件来接收短消息的问题!
- 请教高手 treeview 与 imagelist的关系
- 急!如何在MDI父窗体中层叠排列DLL中的窗体?
- 毕业设计着急啊,有好心人帮我吗?高分哦!!!
- 关于用VB自动生成‘拔号连结’连接程序问题。
- 如何在WINDOWS98下监控,捕获用户在本地电脑的文件夹或某文件按鼠标右键选取了删除功能??
- 关于VB中的处理键盘F10按键的困惑,高手来帮忙!!!!
- 如何在两个form之间传递参数?
- SOS!SOS!SOS!急!急!急!哪位高手能给出在WIN2K的NTFS中实现磁盘配额限制vb api的原程序!谢谢!^_^
- HeapCreate、GlobalAlloc和VirtualAlloc之间有什么差别?
在说你的问题,你用的是server2000对吧,生成的连接.dsn文件是studentinfo.dsn ,我不知道你那个material.dsn是什么,我都用操作系统\控制面板\管理工具\数据源 下做数据连接,那里面提示的很清楚,也很方便,去试试吧,祝你好运!
这位兄弟的代码是来自一本叫做《Visual Basic 6.0 数据库系统开发实例导航>>得吧,而且是人民邮电大学出版社的。我说得对吗?错误关键处在FileName 后面 把这一句改成
Public Function ConnectString() As String
ConnectString = "FileName=DNS的路径;(一般默认是C:\Program Files\Common Files\ODBC\Data Sources\material.dsn;)"
End Function
这样就OK了。
Best of luck to you!