怎样在程序中建立ODBC与Access 或 SQL Server的连接!!
希望大家能给个例子。谢谢!!
希望大家能给个例子。谢谢!!
解决方案 »
- 请问VB能不能在编写代码时象VS一样随意切换代码窗口
- 做了个c/s程序,想通过菜单限制用户的使用功能,如何做呀?急呀!
- [求助]如何扩充datagrid的以下功能???
- 我是在编WORD的宏时遇到的问题。
- 请教!!急!在线等!
- Data1_Reposition()里如何得到当前记录的序号啊??
- 关于用MSCOMM控件通讯程序时,如何进行文件的传输??谢谢!
- 如果shape控件是画在form上的 ,那为什么cls清除不了呢
- 希望现在的论坛能够解决贴图的问题.
- 用API建立一个菜单后怎样让菜单响应点击事件
- 有大虾用过VBExplorer(或EnumDeskVB)吗?有问题请教!
- 有大虾用过VBExplorer(或EnumDeskVB)吗?有问题请教!
Public MyConnectLoca As ADODB.Connection '连接
Public MyRecordLoca As ADODB.Recordset '记录集 '连接 本地数据库(Access2000数据库)得到程序所需资料清单
Set MyConnectLoca = New Connection
With MyConnectLoca
.CursorLocation = adUseClient
.ConnectionTimeout = 120
.CommandTimeout = 60
.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & YouFilePath & ";Jet OLEDB:Database Password=youpassword"
strTable = "YouTable"
End With想连接SQL Server的话将“.Open "PROV ...”改成
.Open "PROVIDER=MSDASQL;driver={SQL Server};server=" & ServerName & ";uid=" & LogonUsr & ";pwd=" & LogonPwd & ";database=" & DatabaseName & ";Address=" & ServerAddressIP & ";"
'记录集的使用 Set MyRecord = New Recordset
With MyRecord
.CursorType = adOpenStatic
.LockType = adLockOptimistic
strSelect = "select * from YouTableName"
.Open strSelect, MyConnectLoca If (Not (.EOF) And Not (.BOF)) Then
MyRecord!FieldA = XXXX
...
...
... .Close
Else
.Close
MsgBox "数据库中的“YouTableName”资料不完整,请确认后再运行本程序!"
End
End If
End With
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;" CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = Rs
Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False"
CN.Open Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic Set DataGrid1.DataSource = Rs
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q171/1/46.asp&NoWebContent=1
.CommandTimeout = 60
.CursorLocation = adUseClient
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & DBPath & "\*.mdb;Persist Security Info=False"
.Open
连接SQL Server:
strConnect = "Provider=MSDASQl;driver={SQL server};server=SQLServer ;uid=sa;pwd=;database=DatabaseOfSQLServer "
cnnPrimaryServer.ConnectionTimeout = LoginTimeOut
cnnPrimaryServer.CursorLocation = adUseClient
cnnPrimaryServer.Open strConnect
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q171/1/46.asp&NoWebContent=1