以前都是用ACCESS做数据源知道这样连接provider=microsoft.jet.oledb.4.0;data source=x:\xx\xx\xx.mdb;
现在用SQL怎么连接,不想这样<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_m_STRING
MM_m_STRING = "dsn=LocalServer;"
%>

终于有人给我发了是这样的,给大家参考一下<%
set conn=server.createobject("adodb.connection")
connstr ="Provider=sqloledb;" & "Data Source=(local);Initial Catalog=qiye_5;User Id=sa;Password=123456;"
conn.open connstr
%>