Provider=Sqloledb;是啥意思？

[missde]

用下句连接mssql
ConnStr = "Provider=Sqloledb; User ID = " & 用户名 & "; Password = " & 密码 & "; Initial Catalog = " &库名 & "; Data Source = " & 服务器IP & ";"
---------------
问：
ConnStr = "Provider=Sqloledb;......
与
ConnStr = "Provider = Sqloledb;......
--------
从语法上讲，有区别么？

为啥带空格的话，下面语句不能在update后显示rs("id")，而不带空格的，可以显示？

谢谢！！


---------------------
---------------------
set rs=server.createobject("adodb.recordset")
'--------------------------------------
sql="select * from [user] where (id is null)"
rs.open sql,conn,1,3
rs.addnew
rs("name")="sadassa"
rs.update
'---------------------------------------------
'得到歌曲编号
Newid=rs("Id")
response.Write(Newid)
---------------