|
 |
| |
Run Web แล้วขึ้นแบบนี้ Microsoft OLE DB Provider for ODBC Drivers error '80040e21' |
| |
 |
|
|
 |
 |
|
ขอดู Code ด้วยครับ
|
 |
 |
 |
 |
| Date :
2009-04-30 17:06:45 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
---- Code -----
<%
Set Conn=Server.CreateObject("ADODB.Connection")
ConnStr = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=chinupakorn_com;User=chinupa_chinupa;Password=XXXXX;Option=3;"
conn.Open ConnStr
dim AsPath,AsPath_del
AsPath ="c:\test\"
AsPath_del="c:\test"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<meta http-equiv="Content-Language" content="th">
<title>CHINUPAKORN (1976)</title>
<script id=clientEventHandlersJS language=javascript>
<!--
function Login_onclick() {
if (document.Check_user.Txt_User.value ==""){
alert("กรุณากรอก UserName");
return false;
}
if (document.Check_user.Txt_Password.value ==""){
alert("กรุณากรอก PassWord");
return false;
}
}
//-->
</script>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" style="text-align: right">
.
.
.
.
.
.
บรรทัดที่ 124 <%
' connext to news database
Set rs_news =server.CreateObject("ADODB.RECORDSET")
sql =" Select * from tb_news"
rs_news.Open sql,conn,1,3
%>
<td width="606"><%
if rs_news.EOF then
else
Response.Write "<center><b><font style='font-size: 10pt'>"&rs_news("subject")&"</font></b></center>"
if len(rs_news("news_detail")) > 250 then
response.Write "<font style='font-size: 8pt'> "&left(replace(rs_news("news_detail"),"<br>",vbcrlf),250)&"</font>"
response.Write "<i><font style='font-size: 8pt'><a href='Show_News.asp' target=_blank> more>></a></font></i>"
else
response.Write"<font style='font-size: 8pt'>"&replace(rs_news("news_detail"),"<br>",vbcrlf)&"</font>"
end if
end if
rs_news.Close
'replace(Trim(txt_news),"<br>",vbcrlf)
%>
</td>
<td width="13"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<%
if Request.QueryString("product_list") ="" then
%>
<!--#include file="Default_mainList.asp"-->
<%
else
%>
<!--#include file="Default_Prod_List.asp"-->
<%
end if
%>
-- END CODE--
|
| |
|
|
| |
| Date :
2009-04-30 17:15:10 |
By :
chainuwat |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
น่าจะต้องติดตั้ง MySQL ODBC 3.51 Driver ด้วยน่ะครับ
|
| |
|
|
| |
| Date :
2009-04-30 17:59:38 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองเปลี่ยนเป็นแบบนี้ดูนะ
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;UID=root; " & _
"pwd=root;database=mydatabase;option=16384;"
|
| |
|
|
| |
| Date :
2009-05-06 14:17:18 |
By :
koozysky |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
