Public conn As New ADODB.Connection
Public rs1 As New ADODB.Recordset
Dim connStr As String
connStr = "Provider=SQLOLEDB.1;Persist Security Info=False;Initial File Name=" & App.Path & "\SW_DATA.MDF;uid=sa;pwd=;"
conn.Open connStr
sql = "select * from sysusers"
rs1.Open sql, conn, adOpenKeyset, adLockPessimistic
可实现
当sql="select * from log" 时提示我 invalid object name 'log'
但log 数据表是存在的。
sysusers ---建库时系统自带的数据表
log--------- 自建的数据表
数据库SQL SEVER7.0
Public rs1 As New ADODB.Recordset
Dim connStr As String
connStr = "Provider=SQLOLEDB.1;Persist Security Info=False;Initial File Name=" & App.Path & "\SW_DATA.MDF;uid=sa;pwd=;"
conn.Open connStr
sql = "select * from sysusers"
rs1.Open sql, conn, adOpenKeyset, adLockPessimistic
可实现
当sql="select * from log" 时提示我 invalid object name 'log'
但log 数据表是存在的。
sysusers ---建库时系统自带的数据表
log--------- 自建的数据表
数据库SQL SEVER7.0
你换个表名试试
如tblLog
数据表换其他名也不行,好象只要是自己建的表就不行
是不是数据库连接有问题?
用其他连接方法提示我 can not open database SW-data.MDF,login failed