我的网站数据库原来用的是SQL的,我把数据导出成Access的后,有把CONN文件内容改了下
结果注册用户时提示注册成功了但是没有写到数据库里,还有所有的信息都不能写到数据库里了,
是怎么回事?
没改前CONN文件内容:
<!--#include file="inc/md5.asp"-->
<!--#include file="inc/base64.asp"-->
<%
Session.Timeout=5
'if request("b_rules")=1 then
'Response.Buffer = True
'else
'Response.Buffer = True 
'Response.ExpiresAbsolute = Now() - 1 
'Response.Expires = 0 
'Response.CacheControl = "no-cache" 
'end if
sitetitle=" - cici"
 dim conn   
 dim connstr   
 on error resume next
 '连接数据库
 '---------------------------------------------------------------------------
 connServerName = "(local)" '数据库服务器名或者IP,本机填“(local)”即可。
 connDatabase = "111"    '数据库名称
 connUserName = "sa"        '数据库用户名
 connPassword = "111111"   '数据库密码
 '---------------------------------------------------------------------------
 Set conn = Server.CreateObject("ADODB.Connection")
   connstr="Provider=SQLOLEDB;Data Source="&connServerName&";Initial Catalog="&connDatabase&";User ID="&connUserName&";Password="&connPassword&";"
 if err.number<>0 then 
  err.clear
  set conn=nothing
  response.write "数据库连接错误,请检查"
  Response.End
 else
  conn.open connstr
  if err then 
   err.clear
   set conn=nothing
   response.write "数据库连接错误,请检查"
   Response.End 
  end if
 end if   
 
 sub endConnection()
  conn.close
  set conn=nothing
 end sub
%>
改后的MONN内容:
<!--#include file="inc/md5.asp"-->
<!--#include file="inc/base64.asp"-->
<%
Session.Timeout=5
'if request("b_rules")=1 then
'Response.Buffer = True
'else
'Response.Buffer = True 
'Response.ExpiresAbsolute = Now() - 1 
'Response.Expires = 0 
'Response.CacheControl = "no-cache" 
'end if
sitetitle=" - cici"
 dim conn   
 dim connstr   
 on error resume next
 Set conn = Server.CreateObject("ADODB.Connection")
   connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+server.mappath("admin/DB/11.mdb")
 if err.number<>0 then 
  err.clear
  set conn=nothing
  response.write "数据库连接错误,请检查"
  Response.End
 else
  conn.open connstr
  if err then 
   err.clear
   set conn=nothing
   response.write "数据库连接错误,请检查"
   Response.End 
  end if
 end if   
 
 sub endConnection()
  conn.close
  set conn=nothing
 end sub
%>



 
											





 
	    

 
	