asp与sql server 数据库的连接
<%
'连接数据库————————————————————————————
set conn=server.createobject("adodb.connection")
Connstr="Provider=SQLOLEDB;Data Source=127.0.0.1;UID=sa;PWD=sa;DataBase=web"
'打开数据库——————————————————————————————————
conn.open connstr
'写数据查询语句————————————————————————
set rs=conn.execute("select * from asp where id>2")
'输出查询结果——————————————————————————
do until rs.eof
response.write rs("id")&"<br>"
response.write rs("name")&"<br>"
rs.movenext
loop
%>
************************************
asp与access 数据库的连接
********************************
<% dim conn
dim connstr
on error resume next
connstr="DBQ="+server.mappath("login.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err then
err.clear
else
conn.open connstr
if err then
err.clear
end if
end if
set rs=conn.execute("select * from login_info where id>1")
do until rs.eof
response.write rs("id")&"<br>"
response.write rs("username")&"<br>"
response.write rs("password")&"<br>"
rs.Movenext
loop %>
*****************************************************
*****************************************************
<!--#include file="conn.asp"-->
<%
set rs=conn.execute("select * from login_info where id>2")
'set rs=server.createobject("adodb.recordset")
'sql="select * from login_info where id > ='1' "
'rs.open sql,conn,1,1
do until rs.eof
response.write rs("id")&"<br>"
response.write rs("username")&"<br>"
response.write rs("password")&"<br>"
rs.Movenext
loop
%>
set objconn=server.createobject("adodb.connection")
objconn.open "dsn=mydb;database=db2;uid=;pwd=;"
却说错误Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
2.对在sql server数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={sql server};database=数据库名称;server=(local);uid=sa;pwd="
3.对在oracle数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft odbc for oracle};uid=xxx;pwd=yyy;server=sss"
4.对在excel而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft excel driver (*.xls)};dbq=数据库名称"
5.对在dbase数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft dbase driver (*.dbf)};dbq=数据库名称"
6.对在text名称而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver= {microsoft text driver (*.txt; *.csv)};dbq=数据库名称"