先将数据库所在目录完全共享. 很简单的,先引用ado2.5再使用如下的函数: '用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密 '码为DataBasePassword '并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset Dim MyConnectString As String Dim sql As String
Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Sqloledb;Server=XXX.XXX.XXX.XXX;Database=test;Uid=User;Pwd=Password"
先将数据库所在目录完全共享. 很简单的,先引用ado2.5再使用如下的函数: '用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密 '码为DataBasePassword '并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset Dim MyConnectString As String Dim sql As String
Thank you
Set cn = New ADODB.Connection
cn.Open "provider=sqloledb;server=61.202.12.33;database=test;uid=sa;pwd=password"
为什么说效率最高的是ADO控件,真是这样吗?
Set cn = New ADODB.Connection
cn.Open "provider=sqloledb;server=61.202.12.33;database=test;uid=sa;pwd=password"
多谢各位的支持(深深一鞠)
请问:test如何定义?
包不包含路径,还是在ODBC是定义!!
(能给出详细例子吗?[email protected])
高兴相送!
说得简单,做起却难!能给例子吗?能在本机测试吗?
很简单的,先引用ado2.5再使用如下的函数:
'用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密
'码为DataBasePassword
'并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset
Dim MyConnectString As String
Dim sql As String
''' 打开连接。
MyPath =+ "192.168.9.1\database\"
MyConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & MyPath & MyDatabase & ";Jet OLEDB:Database Password=" & DataBasePassword
Set MyCnn = New ADODB.Connection
MyCnn.Open MyConnectString
''建立RecordSet
Set MyRs = New ADODB.Recordset
sql = "SELECT " & MyFields & " FROM " & MyTable & MySQLCondition1
MyRs.CursorLocation = adUseClient
MyRs.LockType = adLockBatchOptimistic
MyRs.CursorType = adOpenKeyset
''给函数赋值
MyRs.Open sql, MyCnn
Set adoconnect3 = MyRs
End Function
我的是ADO2.1,可以吗?
哪里有ADO2.5下载!!!
错误!
”\\127.0.0.1\lwx\db01.mdb“ ———————— 提示错误路径!
”127.0.0.1\lwx\db01.mdb“ —————————'E:\Program Files\Microsoft Visual Studio\VB98\127.0.0.1\lwx\db01.mdb'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
Set cn = New ADODB.Connection
cn.Open "Provider=Sqloledb;Server=XXX.XXX.XXX.XXX;Database=test;Uid=User;Pwd=Password"
很简单的,先引用ado2.5再使用如下的函数:
'用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密
'码为DataBasePassword
'并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset
Dim MyConnectString As String
Dim sql As String
''' 打开连接。
MyPath = "\\192.168.9.211\" + "database\" '主要是这儿,笔误,sorry
MyConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & MyPath & MyDatabase & ";Jet OLEDB:Database Password=" & DataBasePassword
Set MyCnn = New ADODB.Connection
MyCnn.Open MyConnectString
''建立RecordSet
Set MyRs = New ADODB.Recordset
sql = "SELECT " & MyFields & " FROM " & MyTable & MySQLCondition1
MyRs.CursorLocation = adUseClient
MyRs.LockType = adLockBatchOptimistic
MyRs.CursorType = adOpenKeyset
''给函数赋值
MyRs.Open sql, MyCnn
Set adoconnect3 = MyRs
End Function