###asp连sql server,access都连不上,哪的问题呀,急死我了###
ghmm 2002-08-02 12:18:03 这是连sql server的:
<%
set conn=server.createobject("adodb.connection")
conn.open"provider=sqloledb.1;user id=sa;password=;initial catalog=C:\Program Files\Microsoft SQL Server\MSSQL\Data\mm;data source=local"
set rst=server.createobject("adodb.recordset")
rst.Open "select * from table1 ", conn, adOpenDynamic, adLockOptimistic
do while not rst.eof
response.write rst.fields("姓名").value
rst.movenext
loop
%>
显示错误:Microsoft OLE DB Provider for SQL Server 错误 '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]未找到指定的 SQL Server
这是连access的:
<%
set conn=server.createobject("adodb.connection")
conn.ConnectionString = "provider=microsoft.jet.oledb.4.0; data source=c:\my documents\db2000.mdb"
conn.CursorLocation = adUseClient
conn.Open
set rst=server.createobject("adodb.recordset")
rst.Open "select * from t1 ", conn, adOpenDynamic, adLockOptimistic
do while not rst.eof
response.write rst.fields("地区").value
rst.movenext
loop
%>
显示错误:ADODB.Connection 错误 '800a0bb9'
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
可是以前我用vb连access时,连接字符串也是这样写的,就能连上,这里怎么就不行呢?
请问我错在哪里,应该怎样写????