10/10/2018, 09:51

ket noi trong ASP voi SQL 2000

hien tai toi dang su dung ASP ket noi database tu access, gio tui chuyen qua ben SQL 2000 ma bi loi sau, anh em giup do dum toi voi.

Khai bao bien trong file inc_conn.asp

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB.1; Data Source=ACER;User ID=sa;PWD=sa;Initial Catalog=otoviet"

%>

chay thi bao loi file index.asp nhu sau:

Error Type:
ADODB.Connection (0x800A0E79)
Operation is not allowed when the object is open.
/website/weboto/index.asp, line 6

Code cua index.asp nhu sau( noi thiet la em ko biet cau lenh lam sao de ket noi toi' SQL trong cai nay)



<%
Dim newProducts(7,4)
Dim productDetail,productdtkt
conn.Open--------------(line 6.--loi o day ne............)
'Lay thong tin tu tb_products
sqlProductsView="Select * From tb_products Where spmoi=true Order by ngaynhap desc"
set rsProductsView=Conn.Execute(sqlProductsView)
If rsProductsView.EOF=True AND rsProductsView.BOF=True then
'Khong lam gi ca
else
newProducts(1,1)=rsProductsView("hang_ID")
newProducts(1,2)=rsProductsView("tenhang")
newProducts(1,3)=rsProductsView("giaxuat")
productDetail=rsProductsView("mieuta")
newProducts(1,4)=rsProductsView("anh")
productdtkt=rsProductsView("dtkt")
End if

'Lay cac thong tin cua cac tin tiep theo
For i=2 to 7
If rsProductsView.EOF=False AND rsProductsView.BOF=False then
newProducts(i,1)=rsProductsView("hang_ID")
newProducts(i,2)=rsProductsView("tenhang")
newProducts(i,3)=rsProductsView("giaxuat")
rsProductsView.MoveNext
Else
Exit For
End if
Next
rsProductsView.close
Conn.Execute
Conn.Close
%>


<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>HITECH Company</title>
<SCRIPT language="JavaScript" src="images/menu/marquee.js"></SCRIPT>
<SCRIPT language="JavaScript" src="images/vietuni.js" type=text/javascript></SCRIPT>
<SCRIPT language="JavaScript"> setTypingMode(1); </SCRIPT>
</head>

<body leftMargin=0 topMargin=0>
<CENTER>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="780" id="AutoNumber1">
<tr>
<td width="780" colspan="3">




</td>
</tr>
<tr>
<td width="158" valign="top" background="Images/Menu/menu_bottom_bg.gif">







</td>
<td width="470" valign="top">



<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber11">
<tr>
<td width="1%"> </td>
<td width="99%">

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber12">
<tr>
<td width="100%"> </td>
</tr>
<tr>
<td width="100%">
<img border="0" src="Images/head_gioithieu_new.gif" width="425" height="18"></td>
</tr>
<tr>
<td width="100%">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#DFDFDB" width="100%" id="AutoNumber13" bgcolor="#F5F5F5">
<tr>
<td width="100%">
<p style="margin-top: 2; margin-bottom: 2">
<font color="#0000FF" size="2" face="Verdana">  <b>Chào
mừng bạn đến với chúng tôi</b></font></p>
<p class=fontstyle>
       &nbsp ; <font color="#FF0000">
<b>Công ty Phát triển và Ứng dụng Công nghệ Tin học HITECH</b></font></p>
<blockquote>
<p class=fontstyle align="justify">
   Chuyên cung cấp các sản phẩm thuộc lĩnh vực công
nghệ thông tin, bao gồm cả phần cứng và phần mềm. Ðể đáp ứng
nhu cầu ngày càng tăng của thị trường tin học, chúng tôi có
đội ngũ nhân viên có trình độ, kinh nghiệm, tận tình, chu đáo
cùng với lượng hàng hoá phong phú được nhập khẩu trực tiếp từ
các nước Mỹ, Ðài Loan, Singapore, Hồng Kông, Trung Quốc ...
cũng như các sản phẩm của các hãng sản xuất và phân phối có
tên tuổi trong nước. Quý khách sẽ hoàn toàn hài lòng về giá cả
và chất lượng phục vụ tại công ty chúng tôi.</p>
</blockquote>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" size="1">      &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;      
<font color="#808080" onmouseout="this.style.color='" onmouseover="this.style.color='#0000FF'" style="cursor:hand" onclick="document.location.href='aboutus.asp';">.. :: More Info </font><img border="0" src="Images/here.gif" width="10" height="9"></p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" size="1"> </font></td>
</tr>
</table>
</td>
</tr>
</table>

</td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%"> </td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%">
<table border="1" cellpadding="0" cellspacing="4" style="border-collapse: collapse" bordercolor="#DFDFDB" width="100%">
<tr>
<td valign="middle">
<p align="center">
<img border="0" src="Images/factory.gif" width="427" height="40"></td>
</tr>
</table>
</td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%"> </td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%">
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="18">
<tr>
<td width="21">
<img border="0" src="Images/head_1.gif"></td>
<td width="150" bgcolor="#D50000"><b>
<font face="Tahoma" style="font-size: 8.5pt" color="#FFFFFF">SẢN PHẨM
MỚI</font></b></td>
<td><img border="0" src="Images/head_2.gif"></td>
</tr>
</table></td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#DFDFDF" width="100%" id="AutoNumber15" bgcolor="#F5F5F5">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber16">
<tr>
<td width="33%" rowspan="2">
<p align="center">
<%If newProducts(1,4)<>"" and not isNull(newProducts(1,4)) then%>
<img border="0" src="<%=newProducts(1,4)%>">
<%End if%>
</td>
<td width="67%" valign="top" colspan="2">
<p style="margin-top: 2; margin-bottom: 2">
<font face="Symbol" size="1" color="#0000FF">·</font>
<font size="2" face="Arial" color="#0000FF"><%=newProducts(1,2)%></font>
<%if Session("No") = True then Response.Write "  <a class=""edit"" href=""admin_editProduct.asp?hangID="&newProducts( 1,1)&"&pageback=thissite"">[Edit]</a>"%>
</p>
<p class=fontstyle>
  
<%
If productDetail="" then
productDetail=productdtkt
End if
If Len(productDetail)>400 then
Response.Write(FormatStr(Left(productDetail,InStr( 400,productDetail," "))))
Else
Response.Write(FormatStr(productDetail))
End if
%>...</td>
</tr>
<tr>
<td width="33%" height="27"><b><font size="1" face="Verdana">
<font color="#FF9933">Giá:</font>   $<%=newProducts(1,3)%></font></b></td>
<td width="34%" height="27"><a href=shoppingCart.asp?hangID=<%=newProducts(1,1)%> >
<img border="0" src="Images/addtocart.jpg" width="87" height="18"></a></td>
</tr>
<tr>
<td width="100%" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber17">
<tr>
<td width="3%" height="10"></td>
<td width="77%" height="10">
<hr color="#E2E2E2" size="1" align="left"></td>
<td width="15%" height="10"><font face="Verdana" size="1"> 
<a href="chitiet.asp?hangID=<%=newProducts(1,1)%>">
<font style="font-size: 7.5pt" color="#333399">Chi tiết </font>
<img border="0" src="Images/here.gif" width="10" height="9"></a></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber18">
<tr>
<td width="6%"> </td>
<td width="94%">

<SCRIPT language=JavaScript>
var scrollerwidth=400
var scrollerheight=45
var scrollerbgcolor='#00000'
var scrollerbackground='
var messages=new Array();

messages[2]='<p style="margin-top: 2; margin-bottom: 2"><font face="Verdana" color="#808080" size="3">***9642; <font size="1"><a class="grey" href="chitiet.asp?hangID=dvd0000001">DVDRewrite LG 48/24/48 - Giá: $78</a></font></font></P><p style="margin-top: 2; margin-bottom: 2"><font color="#808080"><font face="Verdana" size="3">***9642; </font><font face="Verdana" size="1"><a class="grey" href="chitiet.asp?hangID=print0000001">Máy in Laser Canon 1500 - Giá: $250</A></font></font></P>';
messages[1]='<p style="margin-top: 2; margin-bottom: 2"><font face="Verdana" color="#808080" size="3">***9642; <font size="1"><a class="grey" href="chitiet.asp?hangID=mh0000001">Monitor LCD Samsung Synmaster 15" - Giá: $250</a></font></font></P><p style="margin-top: 2; margin-bottom: 2"><font color="#808080"><font face="Verdana" size="3">***9642; </font><font face="Verdana" size="1"><a class="grey" href="chitiet.asp?hangID=hdd0000001">HDD Maxtor 80GB 72000rpm/minute - Giá: $82</A></font></font></P>';
messages[0]='<p style="margin-top: 2; margin-bottom: 2"><font face="Verdana" color="#808080" size="3">***9642; <font size="1"><a class="grey" href="chitiet.asp?hangID=hand0000001">USB Flash Driver Transend 128MB - Giá: $50</a></font></font></P><p style="margin-top: 2; margin-bottom: 2"><font color="#808080"><font face="Verdana" size="3">***9642; </font><font face="Verdana" size="1"><a class="grey" href="chitiet.asp?hangID=cpu0000001">Intel Pentium IV CPU 2.5GHz - Giá: $123</A></font></font></P>';

if (messages.length>1)
i=2
else
i=0

function move1(whichlayer){
tlayer=eval(whichlayer)
if
(tlayer.top>0&&tlayer.top<=1){
tlayer.top=0
setTimeout("move1(tlayer)",5000)
setTimeout("move2(document.main.document.second)", 5000)
return
}
if (tlayer.top>=tlayer.document.height*-1){
tlayer.top-=5
setTimeout("move1(tlayer)",5000)
}
else{
tlayer.top=scrollerheight
tlayer.document.write(messages[i])
tlayer.document.close()
if (i==(messages.length-1))
i=0
else
i++
}
}
function move2(whichlayer){
tlayer2=eval(whichlayer)
if (tlayer2.top>0&&tlayer2.top<=5){
tlayer2.top=0
setTimeout("move2(tlayer2)",5000)
setTimeout("move1(document.main.document.first)",5 000)
return
}
if (tlayer2.top>=tlayer2.document.height*-1){
tlayer2.top-=5
setTimeout("move2(tlayer2)",50)
}
else{
tlayer2.top=scrollerheight
tlayer2.document.write(messages[i])
tlayer2.document.close()
if (i==(messages.length-1))
i=0
else
i++
}
}

function move3(whichdiv)
{
tdiv=eval(whichdiv)
if (tdiv.style.pixelTop>0&&tdiv.style.pixelTop<=5)
{
tdiv.style.pixelTop=0
setTimeout("move3(tdiv)",5000)
setTimeout("move4(second2)",5000)
return
}
if (tdiv.style.pixelTop>=tdiv.offsetHeight*-1)
{
tdiv.style.pixelTop-=5
setTimeout("move3(tdiv)",50)
}
else
{
tdiv.style.pixelTop=scrollerheight
tdiv.innerHTML=messages[i]
if (i==(messages.length-1))
i=0
else
i++
}
}

function move4(whichdiv)
{
tdiv2=eval(whichdiv)
if (tdiv2.style.pixelTop>0&&tdiv2.style.pixelTop<=5)
{
tdiv2.style.pixelTop=0
setTimeout("move4(tdiv2)",5000)
setTimeout("move3(first2)",5000)
return
}
if (tdiv2.style.pixelTop>=tdiv2.offsetHeight*-1)
{
tdiv2.style.pixelTop-=5
setTimeout("move4(second2)",50)
}
else
{
tdiv2.style.pixelTop=scrollerheight
tdiv2.innerHTML=messages[i]
if (i==(messages.length-1))
i=0
else
i++
}
}

function startscroll()
{
if (document.all)
{
move3(first2)
second2.style.top=scrollerheight
second2.style.visibility='visible'
}
else if (document.layers)
{
document.main.visibility='show'
move1(document.main.document.first)
document.main.document.second.top=scrollerheight+5
document.main.document.second.visibility='show'
}
}

window.onload=startscroll</SCRIPT>
<ILAYER id=main width="&{scrollerwidth};"
height="&{scrollerheight};;"
background="&{scrollerbackground};"
visibility="show"><LAYER id=first
width="&{scrollerwidth};" left="0" top="1">
<SCRIPT language=JavaScript1.2>if (document.layers)
document.write(messages[0])</SCRIPT>
</LAYER><LAYER id=second
width="&{scrollerwidth};" visibility="show"
left="0" top="0">
<SCRIPT language=JavaScript1.2>if (document.layers)
document.write(messages[1])</SCRIPT>
</LAYER><LAYER id=troisieme
width="&{scrollerwidth};" visibility="show"
left="0" top="0">
<SCRIPT language=JavaScript1.2>if (document.layers)
document.write(messages[2])</SCRIPT>
</LAYER><LAYER id=quatrieme
width="&{scrollerwidth};" visibility="show"
left="0" top="0">
<SCRIPT language=JavaScript1.2>if (document.layers)
document.write(messages[3])</SCRIPT>
</LAYER><LAYER id=quatrieme
width="&{scrollerwidth};" visibility="show"
left="0" top="0">
<SCRIPT language=JavaScript1.2>if (document.layers)
document.write(messages[4])</SCRIPT>
</LAYER></ILAYER>
<SCRIPT language=JavaScript1.2>if (document.all){
document.writeln('<span id="main2" style="position:relative;width:'+scrollerwidth+';h eight:'+scrollerheight+';overflow:hiden;background-color:'+scrollerbgcolor+' ;background-image:url('+scrollerbackground+')">')
document.writeln('<div style="position:absolute;width:'+scrollerwidth+';h eight:'+scrollerheight+';clip:rect(0 '+scrollerwidth+' '+scrollerheight+' 0);left:0;top:0">')

document.writeln('<div id="first2" style="position:absolute;width:'+scrollerwidth+';l eft:0;top:1;">')
document.write(messages[0])
document.writeln('</div>')

document.writeln('<div id="second2" style="position:absolute;width:'+scrollerwidth+';l eft:0;top:0;visibility:hidden">')
document.write(messages[1])
document.writeln('</div>')

document.writeln('<div id="troisieme2" style="position:absolute;width:'+scrollerwidth+';l eft:0;top:0;visibility:hidden">')
document.write(messages[2])
document.writeln('</div>')

document.writeln('<div id="quatrieme2" style="position:absolute;width:'+scrollerwidth+';l eft:0;top:0;visibility:hidden">')
document.write(messages[3])
document.writeln('</div>')

document.writeln('</div>')
document.writeln('</span>')
}</SCRIPT>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" height="10"></td>
<td width="33%" height="10"></td>
<td width="34%" height="10"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%"> </td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%">
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="18">
<tr>
<td width="21">
<img border="0" src="Images/head_1.gif"></td>
<td width="150" bgcolor="#D50000"><b>
<font face="Tahoma" style="font-size: 8.5pt" color="#FFFFFF">PHẦN MỀM - CD MỚI</font></b></td>
<td><img border="0" src="Images/head_2.gif"></td>
</tr>
</table>
</td>
<td width="1%"> </td>
</tr>
<tr>
<td width="1%"> </td>
<td width="98%">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#DFDFDF" width="100%" id="AutoNumber15" bgcolor="#F5F5F5">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber16">
<tr>
<td width="33%" rowspan="2">
<p align="center">
<img border="0" src="Images/Sanpham/ACDSee40.jpg"></td>
<td width="67%" valign="top" colspan="2">
<p style="margin-top: 2; margin-bottom: 2">
<font face="Symbol" size="1" color="#0000FF">·</font>
<font size="2" face="Arial" color="#0000FF">ACDSee Version 4.0</font></p>
<p class=fontstyle>
   Phần mềm xem ảnh chuyên nghiệp được đánh giá là tốt
nhất hiện nay trên thế giới. Chương trình hỗ trợ hầu hết các
format ảnh, hỗ trợ tạo các Screen Saver, cung cấp trình xử lý
ảnh riêng...</td>
</tr>
<tr>
<td width="33%" height="27"><b><font size="1" face="Verdana">
<font color="#FF9933">Giá:</font>   $58</font></b></td>
<td width="34%" height="27"><a href=shoppingCart.asp?hangID=cpuPen4006>
<img border="0" src="Images/addtocart.jpg" width="87" height="18"></a></td>
</tr>
<tr>
<td width="100%" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber17">
<tr>
<td width="3%" height="10"></td>
<td width="77%" height="10">
<hr color="#E2E2E2" size="1" align="left"></td>
<td width="15%" height="10"><font size="1" face="Verdana"> <font color="#333399">Chi
tiết </font>
<img border="0" src="Images/here.gif" width="10" height="9"></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber18">
<tr>
<td width="6%"> </td>
<td width="94%">
<table border="0" cellspacing="1" width="100%" id="AutoNumber19">
<tr>
<td width="100%">
<font face="Verdana" color="#808080" size="3">▪<font size="1">
<a class="grey" href="chitiet.asp?producID=HDrv">Skin
Visual 2.0 - Phần mềm tạo Skin cho các ứng dụng viết
bằng VB</a></font></font>
</td>
</tr>
<tr>
<td width="100%"><font face="Verdana" color="#808080" size="3">
▪<font size="1">
<a class="grey" href="chitiet.asp?producID=HDrv">
Haftlife 7.0 - Trò chơi chiến đấu ảo 3D âm thanh sống
động</a></font></font></td>
</tr>
<tr>
<td width="100%"><font face="Verdana" color="#808080" size="3">
▪<font size="1">
<a class="grey" href="chitiet.asp?producID=HDrv">CDROM
English Study 5.0 - CD Học tiếng Anh</a></font></font></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" height="10"></td>
<td width="33%" height="10"></td>
<td width="34%" height="10"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="1%"> </td>
<tr><td width=1%></td><td width=98% height=20> </td><td width=1%></td></tr>
</tr>
</table>

</td>
<td width="152" bgcolor="#EBEBEB" valign="top">





</td>
</tr>
<tr>
<td width="780" colspan="3">





</td>
</tr>
</table>
</CENTER>
</body>
</html>

Mong tra loi gap gap, thanks lam'

thanhbinh101287 viết 12:06 ngày 10/10/2018

del 6 di ..........................

haitac061 viết 11:53 ngày 10/10/2018

là sao hả thanhbinh101287 ?

haitac061 viết 11:56 ngày 10/10/2018

Các pac làm ơn giúp với,

xuanitdlu viết 11:59 ngày 10/10/2018

co the giai thich ro hon khong duoc ban iu.
co nhieu cai minh hem hieu gi het ca !

[=========> Bổ sung bài viết <=========]

co the giai thich ro hon khong duoc ban iu.
co nhieu cai minh hem hieu gi het ca !

Bình luận về bài viết này

Chia sẻ tin đăng đến bạn bè

Gửi Messenger

Bài liên quan

haitac061

0 chủ đề

0 bài viết

Tác giả nổi bật