I made a site by using asp+access.
When I use the system DSN, the site run in gear. But it doesn't work in user DSN mode. What can I do next?
The following is a part codes of the site about connection the DSN:
---------------------
<%Pid = Request.Cookies("Pid")
SRNO=Request("sr")
Set connTemp = Server.CreateObject("ADODB.Connection")
connTemp.Open "shenrong","",""
Set rsTemp = Server.CreateObject("ADODB.Recordset")
sql = "Select * from product Where SRNo='"&SRNo&"'"
rsTemp.Open sql,connTemp,1,1,1%>
<style type="text/css"><!--
.style1{
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;}
--></style><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"><html><head><title>Shenrong Accessorize</title></head>
<body style="margin:0px"><center>
<table width="560" border="0" cellspacing="0" cellpadding="0">
<tr><td width="400" valign="middle">
<div align="center"><img src="../products/<%=rsTemp("SRNo")%>.jpg" border="0"></div>
</td><td width="20"> </td><td width="100">
<span class="style1">SR No.: <%=rsTemp("SRNo")%><br>Description: <%=rsTemp("Descr")%><br><br><a href="plugin/mooop.asp?sr=<%=SRNo%>">
<font color="#009900">Add To MOO</font></a></span></td><td width="20">
</td></tr><%rsTemp.close
connTemp.close%><tr><td> </td><td> </td><td> </td><td> </td></tr></table></center></body></html>
dBforums
>
DSN Connetion error
03-25-04, 03:22
Linear Mode
