HOME > ASP > ASP Forum > ต้องการผู้รู้ด่วน code คือ Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
ต้องการผู้รู้ด่วน code คือ Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
<body bgcolor="#deedfc">
<p>
<%
'On error resume next
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "DBQ=" & Server.MapPath ("test_project_update.mdb" )&";Driver={Microsoft Access Driver (*.mdb)}"
if session("clearance") = 1 OR session("clearance") = 2 OR session("clearance") = 3 then
Sql1= " SELECT [EMPLOYEE].EMP_ID, [EMPLOYEE].TITLE_NAME, [EMPLOYEE].NAME_THAI, [EMPLOYEE].SURENAME_THAI, [EMPLOYEE].E_MAIL, [EMPLOYEE].TEL, ORGANIZATION.ORGNAMETHAI, POSITION.POSNAMETHAI FROM [POSITION] INNER JOIN (ORGANIZATION INNER JOIN EMPLOYEE ON ORGANIZATION.[ORGID]=[EMPLOYEE].ORG_ID) ON POSITION.POSID=[EMPLOYEE].POST_ID WHERE EMP_ID= "&EMP_IDs
'On error resume next
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " & Server.MapPath ("test_project_update.mdb")
เอาไปลองดู ถ้าไม่ได้ก็ลองใช้ DNS Less เหมือนเดิม ไม่รู้ว่าเกี่ยวไหมกับ
Load balance : Server 00
