HOME > ASP > ASP Forum > ช่วยด้วยครับ <% session("Uname") =" " Username=Request set [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ช่วยด้วยครับ <% session("Uname") =" " Username=Request set [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
<%
session("Uname") =" "
Username=Request ("Username")
Password=Request ("Password")
if Username <> " " and Password <> " " then
set objdb = server.createobject("ADODB.Connection")
objdb.open "bookshop"
set objdb = server.createobject("ADODB.Recordset")
SQL="select * from member where User=' " & Username & " ' And Password=' " & Password & " ' "
objrs.open sql,objdb,1,3
if objrs.recordcount<>0 then
session("Uname")=objrs("name")
end if
objrs.close
objdb.close
end if
if session("Uname")<> " " then
response.redirect("http://aca-03/member/member.asp")
else
%>
<html>
<body>
</body>
xxxxxxxxxxxxxxxxxxx
</html>
<%
end if
%>
แล้วมันขึ้น errer
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/member/check_user.asp, line 7
จะแก้ไขอย่างไรครับ
Load balance : Server 01
