该连接串又何问题：
objconn.open "provider=sqloledb;persist security info=false;"& _
"user id=sa;initial catalog=eployees;"& _
"initial file name=e:\program files\microsoft sql server\mssql\data\asp_data.mdf"
不行阿！！ 我有sql server服务器！！按照annkie你的写法我写了，可还是不好使！！！急死我了！set objconn=server.createobject("adodb.connection")objconn.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=asp.mdf;Data Source=rogers"
我的数据库是在e:\program files\microsoft sqlserver\mssql\data\asp.mdf
我的机器名是： rogers
还有什摩错误呢？？请告诉我1！！！！
---------------------------------------------------------------
set objconn=server.createobject("adodb.connection")
connStr="Driver={Sql Server};Server=(local);UID=sa;PWD=;DataBase=eployees"
objconn.Open connStr
---------------------------------------------------------------
<%
Set objConn = Server.CreateObject( "ADODB.CONNECTION ")
objConn.provider= "sqloledb "
StrConn= "driver={SQL server};server= "127.0.0.1 ";uid= " ";pwd=123@45#;database=star "
objConn.Open StrConn% >