职位关键字 工作地点
工作名称 公司名称 校园招聘
中国最好的工作搜索引擎!
  回复留言  
  Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
作者: ddone123  01-01 08:00   回复  
 <%



'--------定义部份------------------

Dim XH_Post,XH_Get,XH_In,XH_Inf,XH_Xh,XH_db,XH_dbstr

'自定义需要过滤的字串,用 "|" 分隔

XH_Xh = "'|and|exec|insert|select|delete%20from|update|count|*|%|chr|mid|master|truncate|char|declare|drop%20table|from|net%20user|xp_cmdshell|/add|net%20localgroup%20administ"

'----------------------------------

%>



<%

XH_Inf = split(XH_In,"|")

'--------POST部份------------------

If Request.Form<>"" Then

For Each XH_Post In Request.Form



For XH_Xh=0 To Ubound(XH_Inf)

If Instr(LCase(Request.Form(XH_Post)),XH_Inf(XH_Xh))<>0 Then

Response.Write "<Script Language=JavaScript>alert('臭小子,你找死呀?');</Script>"

Response.Write "非法操作!系统做了如下记录↓<br>"

Response.Write "操作IP:"&Request.ServerVariables("REMOTE_ADDR")&"<br>"

Response.Write "操作时间:"&Now&"<br>"

Response.Write "操作页面:"&Request.ServerVariables("URL")&"<br>"

Response.Write "提交方式:POST<br>"

Response.Write "提交参数:"&XH_Post&"<br>"

Response.Write "提交数据:"&Request.Form(XH_Post)

Response.End

End If

Next



Next

End If

'----------------------------------



'--------GET部份-------------------

If Request.QueryString<>"" Then

For Each XH_Get In Request.QueryString



For XH_Xh=0 To Ubound(XH_Inf)

If Instr(LCase(Request.QueryString(XH_Get)),XH_Inf(XH_Xh))<>0 Then

Response.Write "<Script Language=JavaScript>alert('臭小子,你找死呀?');</Script>"

Response.Write "非法操作!系统做了如下记录↓<br>"

Response.Write "操作IP:"&Request.ServerVariables("REMOTE_ADDR")&"<br>"

Response.Write "操作时间:"&Now&"<br>"

Response.Write "操作页面:"&Request.ServerVariables("URL")&"<br>"

Response.Write "提交方式:GET<br>"

Response.Write "提交参数:"&XH_Get&"<br>"

Response.Write "提交数据:"&Request.QueryString(XH_Get)

Response.End

End If

Next

Next

End If

'----------------------------------

%>

<%

dim conn

dim connstr

dim db

db="../etwl_dbs/etwldbs19.asa"

Set conn = Server.CreateObject("ADODB.Connection")

'connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)

'如果你的服务器采用较老版本Access驱动,请用下面连接方法

connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)

conn.Open connstr

%>

这是我个人网站的Conn。asp的原代码,原因是只要输入英文就要出现上面的问题,如过有好的答案,请回复:mjh@mengjihong.cn

  回复:Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
作者: q13131017672  01-01 08:00   回复  
 config.asp文件的配置问题,



修改成下面的那个,然后根据你的情况重新改一下即可



<%@ LANGUAGE = VBScript CodePage = 936%>

<%

Response.Buffer=True

IsSqlDataBase=0 '定义数据库类别,0为Access数据库,1为SQL数据库

If IsSqlDataBase=0 Then

'''''''''''''''''''''''''''''' Access数据库 '''''''''''''''''''''''''''''''''''''''''''''''''''''''''

datapath ="/" '数据库目录的相对路径

datafile ="#data#.asa" '数据库的文件名

connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(""&datapath&""&datafile&"")

'Connstr="DBQ="&server.mappath(""&datapath&""&datafile&"")&";DRIVER={Microsoft Access Driver (*.mdb)};"

SqlNowString="Now()"

SqlChar="'"

ver="1.0"

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Else

''''''''''' SQL数据库 ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

SqlLocalName ="(local)" '连接IP [ 本地用 (local) 外地用IP ]

SqlUsername ="name" '用户名

SqlPassword ="pass" '用户密码

SqlDatabaseName="data" '数据库名

ConnStr = "Provider=Sqloledb;User ID=" & SqlUsername & "; Password=" & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source=" & SqlLocalName & ";"

SqlNowString="GetDate()"

ver="1.0 SQL"

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

END IF

On Error Resume Next

Set conn=Server.CreateObject("ADODB.Connection")

conn.open ConnStr

If Err Then

err.Clear

Set Conn = Nothing

Response.Write "数据库连接出错,请检查连接字串。"

Response.End

End If

On Error GoTo 0

%>

标 题:
内 容:
用户名:
 游客
 
 
Copyright©2005-2007, 版权所有 WWW.JOBMET.COM
ICP证:京ICP备06019556号