论坛: 网站建设 标题: sqlserver的dsn 复制本贴地址    
作者: nothing [eson]    论坛用户   登录
我编了个asp程序:
<html><head></head><body><%
strDSN="FILEDSN=dark.dsn"
Set cn =Server.CreateObject("ADODB.Connection")
cn.Open strDSN
Set rsCustomers =Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM jobs"
rsCustomers.Open strSQL, cn
Set objFirstName =rsCustomers("job_desc")
Set objLastName =rsCustomers("min_lvl")
Do Until rsCustomers.EOF
Response.Write objFirstName & " " & objLastName & "<BR>"
rsCustomers.MoveNext
Loop
%>

successful</body></html>
但是出错,估计是strDSN="FILEDSN=dark.dsn" 这句出错,但我已确定我的
数据源设置没错呀(我是在系统dsn中设数据源为dark,测试数据源是也成功,这是为啥呀?,请高手指教呀!!thank you..


地主 发表时间: 10/05 22:24

论坛: 网站建设

20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写:NetDemon

粤ICP备05087286号