Question

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=;PassWord=;Initial Catalog=;Data Source="

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=;PassWord=;Initial Catalog=;Data Source="
请高手解释一下这句话每个关键题的含义,

Answer 1

如果用odbc则可以先把指针移到最后一条记录，然后取值.
dim
conn
as
new
adodb.connection
dim
rs
as
new
adodb.recordset
conn.connectionstring
=
"provider=sqloledb.1;integrated
security=sspi;persist
security
info=false;initial
catalog=db_student;data
source=(local)"
conn.open
'打开
rs.open
"pswrd",
conn,
adopenkeyset,
adlockpessimistic'
申请空间可用于存放记录
rs.movelast'指针移到最后一条记录
text1.text=rs.fields("字段")
'关闭释放
rs.close
set
re
=
nothing
conn.close
set
conn
=
nothing

Answer 2

Provider=SQLOLEDB.1
------打开数据库用oledb的方式连接
Persist
Security
Info
----是否保存
安全信息
User
ID-------------------用户名
PassWord------------------密码
Initial
Catalog-----------数据库的名称或者数据库ip或者目录
Data
Source---------------数据源

Answer 3

提供者＝
持续安全通知＝错误
用户ID＝
密码＝
首字母目录＝
数据资源＝