请教：ASP中如何写连接到SQL数据库的命令字符

大家知道，用ASP连接ACCESS的数据可以用下面的字符串：
Cn.Open "DRIVER={Microsoft Access Driver (*.mdb)};dbq=C:\data.mdb;uid=NAME;pwd=PWD"
请教如何写连接到SQL数据库的连接字符串？
---------------------------------------------------------------

Cn.Open "Provider=SQLOLEDB;Server=YourServerNameOrUselocalhost;Database=YourDBName;uid=NAME;pwd=PWD"

see more at
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer

or

http://www.connectionstrings.com/