问题描述
MicrosoftOLEDBProviderforODBCDrivers错误'80004005'[Microsoft][ODBCSQLServerDriver][SharedMemory]SQLServer不存在或访问被拒绝/Inc/Conn.asp，行24我用的是诺哈程序，空间商帮我安装好组件了，现在网站打不开，显示上面这个，这个怎么解决呀呀，Conn.asp的代码是<!--#includefile="Data.asp"--><%'CallNuoHa_kg()'升级时去掉最前面那一个的'。DimNuoHa_Timer_Start,NuoHaNuoHa_Timer_Start=timer()SetNuoHa=server.CreateObject("NuoHa.Com")'NuoHa建站系统Asp测试版'程序设计：诺哈'官方网址：Http://NuoHa.Com'联系QQ：2234809'联系MSN：NuoHa@msn.hb.cn'电子邮箱：NuoHa@NuoHa.Com'作品时间：2010-5-18'●●●●●●●●●MSSQLSERVER2000数据库●●●●●●●●●DimNuoHa_Conn_Str,ConnNuoHa_Conn_Str="driver={SQLServer};server="&NuoHa_SQL_SERVERIP&";uid="&NuoHa_SQL_UserName&";pwd="&NuoHa_SQL_PassWord&";database="&NuoHa_SQL_DataNameSetConn=server.CreateObject("ADODB.connection")Conn.openNuoHa_Conn_Str'SQL防注入过滤的字串,用"|"分隔DimNuoHa_Sql_H,NuoHa_Sql_H_D,NuoHa_Sql_H_A,NuoHa_Sql_H_P_G_C,NuoHa_Sql_H_N,NuoHa_Sql_H_C,NuoHa_Sql_H_UANuoHa_Sql_H="and|update|exec|insert|delete|count|master|truncate|declare|drop|create|eval|xp_|sp_|command|dir|update"NuoHa_Sql_H_D=Split(NuoHa_Sql_H,"|")NuoHa_Sql_H_A=UBound(NuoHa_Sql_H_D)'●●●POST部份●●●IfRequest.Form<>""ThenForEachNuoHa_Sql_H_P_G_CInRequest.FormForNuoHa_Sql_H_N=0ToNuoHa_Sql_H_AIfInStr(LCase(Request.Form(NuoHa_Sql_H_P_G_C)),NuoHa_Sql_H_D(NuoHa_Sql_H_N))<>0Then'记录注入NuoHa_Sql_H_C="注入时间："&Now()&Chr(13)&Chr(10)&"注入方式：POST"&Chr(13)&Chr(10)&"注入内容："&Request.Form(""&NuoHa_Sql_H_P_G_C&"")&"[参数:"&NuoHa_Sql_H_P_G_C&"]"&Chr(13)&Chr(10)&"注入ＩＰ："&Request.ServerVariables("HTTP_X_UP_CALLING_LINE_ID")&"|"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")&"|"&Request.ServerVariables("REMOTE_ADDR")&Chr(13)&Chr(10)&"页面地址：http://"&request.ServerVariables("SERVER_NAME")&request.ServerVariables("HTTP_URL")&Chr(13)&Chr(10)&"注入浏览器："&request.ServerVariables("HTTP_USER_AGENT")&Chr(13)&Chr(10)&Chr(13)&Chr(10)Response.writeNuoHa.Add_Txt("/Wap_log/Injection/"&year(date)&month(date)&day(date)&hour(time)&minute(time)&second(time)&timer&".txt",NuoHa_Sql_H_C)NuoHa_Sql_H_UA=LCase(Request.ServerVariables("HTTP_USER_AGENT"))IfInStr(NuoHa_Sql_H_UA,"msie")=0andInStr(NuoHa_Sql_H_UA,"winw")=0ThenCallWap_Head("出错啦")response.write"<palign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<anchor><prev/>返回</anchor>"CallWap_End()ElseCallWeb_Head("出错啦")response.write"<divalign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<ahref=""javascript:history.go(-1)"">返回</a>"CallWeb_End()EndIfCallNuoHa_Conn()Response.EndEndIfNextNextEndIf'●●●GET部份●●●IfRequest.QueryString<>""ThenForEachNuoHa_Sql_H_P_G_CInRequest.QueryStringForNuoHa_Sql_H_N=0ToNuoHa_Sql_H_AIfInStr(LCase(Request.QueryString(NuoHa_Sql_H_P_G_C)),NuoHa_Sql_H_D(NuoHa_Sql_H_N))<>0Then'记录注入NuoHa_Sql_H_C="注入时间："&Now()&Chr(13)&Chr(10)&"注入方式：GET"&Chr(13)&Chr(10)&"注入内容："&Request.QueryString(""&NuoHa_Sql_H_P_G_C&"")&"[参数:"&NuoHa_Sql_H_P_G_C&"]"&Chr(13)&Chr(10)&"注入ＩＰ："&Request.ServerVariables("HTTP_X_UP_CALLING_LINE_ID")&"|"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")&"|"&Request.ServerVariables("REMOTE_ADDR")&Chr(13)&Chr(10)&"页面地址：http://"&request.ServerVariables("SERVER_NAME")&request.ServerVariables("HTTP_URL")&Chr(13)&Chr(10)&"注入浏览器："&request.ServerVariables("HTTP_USER_AGENT")&Chr(13)&Chr(10)&Chr(13)&Chr(10)Response.writeNuoHa.Add_Txt("/Wap_log/Injection/"&year(date)&month(date)&day(date)&hour(time)&minute(time)&second(time)&timer&".txt",NuoHa_Sql_H_C)NuoHa_Sql_H_UA=LCase(Request.ServerVariables("HTTP_USER_AGENT"))IfInStr(NuoHa_Sql_H_UA,"msie")=0andInStr(NuoHa_Sql_H_UA,"winw")=0ThenCallWap_Head("出错啦")response.write"<palign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<anchor><prev/>返回</anchor>"CallWap_End()ElseCallWeb_Head("出错啦")response.write"<divalign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<ahref=""javascript:history.go(-1)"">返回</a>"CallWeb_End()EndIfCallNuoHa_Conn()Response.EndEndIfNextNextEndIf'--------Cookies部份-------------------IfRequest.Cookies<>""ThenForEachNuoHa_Sql_H_P_G_CInRequest.CookiesForNuoHa_Sql_H_N=0ToNuoHa_Sql_H_AIfInStr(LCase(Request.Cookies(NuoHa_Sql_H_P_G_C)),NuoHa_Sql_H_D(NuoHa_Sql_H_N))<>0Then'记录注入NuoHa_Sql_H_C="注入时间："&Now()&Chr(13)&Chr(10)&"注入方式：Cookies"&Chr(13)&Chr(10)&"注入内容："&Request.Cookies(""&NuoHa_Sql_H_P_G_C&"")&"[参数:"&NuoHa_Sql_H_P_G_C&"]"&Chr(13)&Chr(10)&"注入ＩＰ："&Request.ServerVariables("HTTP_X_UP_CALLING_LINE_ID")&"|"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")&"|"&Request.ServerVariables("REMOTE_ADDR")&Chr(13)&Chr(10)&"页面地址：http://"&request.ServerVariables("SERVER_NAME")&request.ServerVariables("HTTP_URL")&Chr(13)&Chr(10)&"注入浏览器："&request.ServerVariables("HTTP_USER_AGENT")&Chr(13)&Chr(10)&Chr(13)&Chr(10)Response.writeNuoHa.Add_Txt("/Wap_log/Injection/"&year(date)&month(date)&day(date)&hour(time)&minute(time)&second(time)&timer&".txt",NuoHa_Sql_H_C)NuoHa_Sql_H_UA=LCase(Request.ServerVariables("HTTP_USER_AGENT"))IfInStr(NuoHa_Sql_H_UA,"msie")=0andInStr(NuoHa_Sql_H_UA,"winw")=0ThenCallWap_Head("出错啦")response.write"<palign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<anchor><prev/>返回</anchor>"CallWap_End()ElseCallWeb_Head("出错啦")response.write"<divalign=""left"">"Response.write"提交参数内容含有不允许字符："&NuoHa_Sql_H_D(NuoHa_Sql_H_N)&"<br/>"Response.write"<ahref=""javascript:history.go(-1)"">返回</a>"CallWeb_End()EndIfCallNuoHa_Conn()Response.EndEndIfNextNextEndIfSubWeb_Head(Head_Title)'Response.ContentType="application/vnd.wap.xhtml+xml;charset=utf-8"Response.write"<?xmlversion=""1.0""encoding=""UTF-8""?>"Response.write"<!DOCTYPEhtmlPUBLIC""-//WAPFORUM//DTDXHTMLMobile1.0//EN""""http://www.wapforum.org/DTD/xhtml-mobile10.dtd"">"Response.write"<htmlxmlns=""http://www.w3.org/1999/xhtml"">"Response.write"<head>"Response.write"<metahttp-equiv=""Content-Type""content=""text/html;charset=UTF-8""/>"Response.write"<metahttp-equiv=""Content-Language""content=""zh-CN""/>"Response.write"<metaname=""Website""content="""&website_d&"""/>"Response.write"<metaname=""Description""content="""&website_n&"""/>"Response.write"<metaname=""Keywords""content="""&Head_Title&"""/>"Response.write"<title>"&Head_Title&"</title>"Response.Write"<linkrel=""icon""href=""/Icon.gif""/>"IfNH_wap_c<>"0"ThenResponse.Write"<linkrel=""stylesheet""href=""/Style/Css/"&NH_wap_c&"_"&NH_wap_s&".css""type=""text/css""/>"'Response.write"<bgsoundsrc=""/Style/Mid/"&Random_N(1,15)&".mid""loop=""infinite""/>"EndIfResponse.write"</head><body>"EndSubSubWeb_End()Response.write"</div></body></html>"EndSubSubWap_Head(Head_Title)Response.ContentType="text/vnd.wap.wml;charset=utf-8"Response.write"<?xmlversion=""1.0""encoding=""utf-8""?>"Response.write"<!DOCTYPEwmlPUBLIC""-//WAPFORUM//DTDWML1.1//EN""""http://www.wapforum.org/DTD/wml_1.1.xml"">"Response.write"<wml>"Response.write"<head>"Response.write"<metahttp-equiv=""Cache-Control""content=""max-age=0""/>"Response.write"<metahttp-equiv=""Cache-Control""content=""no-cache""/>"Response.write"</head>"Response.write"<cardtitle="""&Head_Title&""">"EndSubSubWap_End()Response.write"</p></card></wml>"EndSubSubNuoHa_kg()DimNuoHa_kg_UANuoHa_kg_UA=LCase(Request.ServerVariables("HTTP_USER_AGENT"))IfInStr(NuoHa_kg_UA,"msie")=0andInStr(NuoHa_kg_UA,"winw")=0ThenCallWap_Head("网站升级中")response.write"<palign=""left"">"Response.write"网站升级中,请稍后访问，谢谢！"CallWap_End()ElseCallWeb_Head("网站升级中")response.write"<divalign=""left"">"Response.write"网站升级中,请稍后访问，谢谢！"CallWeb_End()EndIfResponse.EndEndSubSubNuoHa_Conn()Conn.CloseSetConn=NothingSetNuoHa=NothingEndSubSubRemove_All_Application()DimApplication_list,Application_n,Application_aApplication_list=split(Get_All_Application(),",")Application_a=UBound(Application_list)-1IfApplication_a>0ThenForApplication_n=0toApplication_aCallDel_All_Application(Application_list(Application_n))NextEndIfEndSubFunctionGet_All_Application()DimGet_ApplicationForEachGet_ApplicationInApplication.ContentsGet_All_Application=Get_All_Application&Get_Application&","NextEndFunctionSubDel_All_Application(Get_A)Application.LockApplication.Contents.Remove(Get_A)Application.unLockEndSubFunctionRandom_N(Min,Max)RandomizeRandom_N=Int((Max-Min+1)*Rnd()+Min)EndFunction%><!--#includefile="../Install/Asp/Set.asp"-->第24行的是Conn.openNuoHa_Conn_Str高手教我怎么解决呀
解决方案
解决方案二：
高手能说详细点不，本人对程序代码纯不懂，
解决方案三：
25:response.writeNuoHa_Conn_Str
解决方案四：
在线等
解决方案五：
什么意思呀，高手
解决方案六：
DimNuoHa_Conn_Str,ConnNuoHa_Conn_Str="driver={SQLServer};server="&NuoHa_SQL_SERVERIP&";uid="&NuoHa_SQL_UserName&";pwd="&NuoHa_SQL_PassWord&";database="&NuoHa_SQL_DataNameresponse.writeNuoHa_Conn_strresponse.end用浏览器找个读写数据库的地址砍下，是否数据库的信息都定义了？
解决方案七：
还要加25行的代码？
解决方案八：
我不懂那个，我可以在FTP上修改的，
解决方案九：
你QQ多少，我加你，你教我吧我的51081042
解决方案十：
引用7楼hujunwei85的回复:
我不懂那个，我可以在FTP上修改的，
那你知道这个程序的数据库信息在哪里配置吗？去那个配置文件里面查看所有的数据库信息（地址，端口，用户名，密码，数据库名称）是否都正确无误？
解决方案十一：
不知道程序的数据库信息在哪里配置
解决方案十二：
我只知道数据库文件放在INC目录下，有好几个文件不知道是哪个
解决方案十三：
Admin_inc.aspConn.aspData.aspInc.aspNH_ubb.aspTs_ubb.aspUbb.aspYk_inc.asp就这几个文件
解决方案十四：
这样看来你都没有配置过数据库的信息，程序怎么知道你用的是哪个数据库？去data.asp里面看下
解决方案十五：
<%DimNuoHa_SQL_SERVERIP,NuoHa_SQL_UserName,NuoHa_SQL_PassWord,NuoHa_SQL_DataNameNuoHa_SQL_SERVERIP="63.141.232.118"'数据库IP或数据库服务名NuoHa_SQL_UserName="sq_9990"'登录数据库用户名NuoHa_SQL_PassWord="131315"'登录数据库密码NuoHa_SQL_DataName="wwws3z3z3z"'主数据库名%>我修改好了，是这样吗，那个主数据库名我不知道怎么设置
解决方案：
高手可以做我师付吗
解决方案：
人家给你什么名，你填上去试一下
解决方案：
sq_9990@localhost这个是吗服务器版本:5.1.52-communityProtocolversion:10服务器:localhostviaTCP/IP用户:sq_9990@localhostMySQL字符集:UTF-8Unicode(utf8)MySQL连接校对:整理armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cibinarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1250_polish_cicp1251_bincp1251_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cidec8_bindec8_swedish_cieucjpms_bineucjpms_japanese_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish_ciucs2_esperanto_ciucs2_estonian_ciucs2_general_ciucs2_hungarian_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_esperanto_ciutf8_estonian_ciutf8_general_ciutf8_hungarian_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci创建一个新的数据库整理armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cibinarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1250_polish_cicp1251_bincp1251_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cidec8_bindec8_swedish_cieucjpms_bineucjpms_japanese_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish_ciucs2_esperanto_ciucs2_estonian_ciucs2_general_ciucs2_hungarian_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_esperanto_ciutf8_estonian_ciutf8_general_ciutf8_hungarian_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci显示MySQL的运行信息显示MySQL的系统变量进程字符集和整理StorageEngines数据库导出Import登出
解决方案：
%DimNuoHa_SQL_SERVERIP,NuoHa_SQL_UserName,NuoHa_SQL_PassWord,NuoHa_SQL_DataNameNuoHa_SQL_SERVERIP="63.141.232.118"'数据库IP或数据库服务名NuoHa_SQL_UserName="sq_9990"'登录数据库用户名NuoHa_SQL_PassWord="131315"'登录数据库密码NuoHa_SQL_DataName="sq_9990@localhost"'主数据库名%>我改好后的
解决方案：
MicrosoftVBScript编译器错误错误'800a0409'未结束的字符串常量/Inc/Data.asp，行6NuoHa_SQL_DataName="sq_9990@localhost-------------------------------------^打开网站还是不行呀
解决方案：
NuoHa_SQL_DataName="sq_9990@localhost"'主数据库名这个怎么换行了？应该在一行
解决方案：
改不过来呀，
解决方案：
改不过来？啥意思？
解决方案：
我改好几次了，都改不过来
解决方案：
改不了一行的，保存了后来再看又是那样的不在一行上
解决方案：
你不是ftp的吗？怎么会改不过来？下下来改，改好后放上去，一定要放对位置
解决方案：
改好了
解决方案：
还不行呀MicrosoftOLEDBProviderforODBCDrivers错误'80004005'[Microsoft][ODBCSQLServerDriver][DBNETLIB]SQLServer不存在或访问被拒绝/Inc/Conn.asp，行24
解决方案：
引用17楼hujunwei85的回复:
sq_9990@localhost这个是吗服务器版本:5.1.52-communityProtocolversion:10服务器:localhostviaTCP/IP用户:sq_9990@localhostMySQL字符集:UTF-8Unicode(utf8)MySQL连接校对:整理armscii8_binarmscii8_general_……
这个是哪里来的？你的服务商给你的是mysql数据库？
解决方案：
老大还不行呀怎么办
解决方案：
引用28楼hanpoyangtitan的回复:
引用17楼hujunwei85的回复:sq_9990@localhost这个是吗服务器版本:5.1.52-communityProtocolversion:10服务器:localhostviaTCP/IP用户:sq_9990@localhostMySQL字符集:UTF-8Unicode(utf8)MySQL连接校对:整理armscii8……
是地
解决方案：
师付你有QQ没，这样太慢了
解决方案：
那没得搞了，你的程序看样子只支持sqlserver,数据库的语法不一样啊而且要脸mysql，服务器上要装mysql的驱动。默认windows似乎是没有的。
解决方案：
引用32楼hanpoyangtitan的回复:
那没得搞了，你的程序看样子只支持sqlserver,数据库的语法不一样啊而且要脸mysql，服务器上要装mysql的驱动。默认windows似乎是没有的。
不懂
解决方案：
那有没办法搞的
解决方案：
要不我把我的空间，数据库密码告诉你，你帮我看下有没有搞的
解决方案：
唯一的办法就是租个sqlserver或者是买服务器自己装你这是自己用还是商业用？
解决方案：
自己用的
解决方案：
哦，那没搞头了，这个空间就是免费的，哈哈，谢谢你呀这么晚还教我那么多
解决方案：
把上面的代码里的sqlserver改城mysql不行吗
解决方案：
引用39楼hujunwei85的回复:
把上面的代码里的sqlserver改城mysql不行吗
老弟，不行啊。
解决方案：
改不过来啊,没好办法.
解决方案：
该回复于2011-11-08 10:33:48被版主删除