如何建立ＳｑｌＳｅｒｖｅｒ的数据源，如何用ＡＳＰ打开ＳｑｌＳｅｒｖｅｒ的数据源并进行简单的操作？最好能有例子，我在机器上试了Ｎ次，都不好使，另外，这个数据源能否被自己作的ＶＣ或是ＶＢ在远程进行连接并进行操作？
我在安装完SQL Server 后，又安装了Rational Rose 98i版，是否是它所在的OCBC共享文件版本与SQL 2000的冲突造成的呢？
---------------------------------------------------------------
do not use ODBC, use DSN-less connection instead, try
1<table border="1">
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Server=localhost;Database=pubs;UID=sa;PWD=;"
set rs = conn.Execute ("select * from authors")
Response.Write "<tr>"
for n=0 to rs.fields.count - 1
Response.Write "<th>" & rs.fields(n).Name & "</th>"
next
Response.Write "</tr>"
do until rs.EOF
Response.Write "<tr>"
for n=0 to rs.fields.count - 1
Response.Write "<td>" & rs.fields(n).Value & "</td>"
next
Response.Write "</tr>"
rs.MoveNext
loop
rs.Close
conn.Close
set conn=nothing
1</table>