1.添加odbc數據源
![](https://i-blog.csdnimg.cn/blog_migrate/ff4b509dd51410b03c88f203514219bf.png)
2.添加dsn
![](https://i-blog.csdnimg.cn/blog_migrate/1c165636b7d8146c0ca71c926a29b85f.png)
3.配置dsn
![](https://i-blog.csdnimg.cn/blog_migrate/7a26b8b250bdb6b2df79d7a382ace00b.png)
4.測試連接
tns為服務名
![](https://i-blog.csdnimg.cn/blog_migrate/6c20621b226939c065f089bfd9ba303a.png)
5.添加數據庫連接配置
<%
set conn=server.createobject("adodb.connection")
conn.ConnectionTimeout = 1000
conn.CommandTimeout = 2000
conn.Open "DSN=myweb;UID=lin;PWD=lin123;"
%>
6.代碼連接
<!-- #include file="./lib/conn.inc"-->
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>Demo</title>
</head>
<body>
<table>
<tr>
<td>頁面測試</td>
<td>
<select name="user_name" id="user_name" value="">
<%
sql=" select * from MY_CSV "
set rs = conn.execute(sql)
if not rs.eof then
do while not rs.eof
%>
<option value="<%=rs("A")%>"><%=rs("A")%></option>
<%
rs.movenext
loop
end if
%>
</select>
</td>
</tr>
</table>
</body>
</html>
![](https://i-blog.csdnimg.cn/blog_migrate/03b6afb0e52e80b2c7c4238f9465710f.png)