用ADO,数据库为access
先引用:Microsoft ActionX Data Object 2.0 Library
dim conn as new adodb.connection
dim rs as new adodb.recordset
dim str
str = App.Path
If Right(str, 1) <> "\" Then
str = str + "\"
End If
str = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & str & "\tsl.mdb"
conn.open str
rs.cursorlocation=aduseclient
rs.open "数据表名",conn,adopenkeyset.adlockpessimistic
用完之后关闭数据库:
conn.close
set conn=nothing
先引用:Microsoft ActionX Data Object 2.0 Library
dim conn as new adodb.connection
dim rs as new adodb.recordset
dim str
str = App.Path
If Right(str, 1) <> "\" Then
str = str + "\"
End If
str = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & str & "\tsl.mdb"
conn.open str
rs.cursorlocation=aduseclient
rs.open "数据表名",conn,adopenkeyset.adlockpessimistic
用完之后关闭数据库:
conn.close
set conn=nothing
adodc1.databasename=app.path & "\XXXXXX.XXX"
来设定吗?
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path
& "\子目录\数据库全称;Persist Security Info=False;
dim conn as new adodb.connection
dim rs as new adodb.recordset
dim Cnnstr
Cnnstr = "PROVIDER=MSDASQL;Driver=SQL Server;Server=192.168.0.1;UID=sa;PWD=;Database=数据库名;"
Conn.Open Cnnstr
rs.open "select * from 表名" Cnnstr
& "\子目录\数据库全称;Persist Security Info=False;
还是不能连接
不知道是什么原因?
可以说具体一些吗?
Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Program Files\DataBase\数据库全称;Persist Security Info=False;
如能连上,再换App.Path,下面加上一句:
Debug.Print App.Path
看是否与实际路径相符。