hello everybody;

this is my code

<%
Dim sqlstring

dim objConn
  set objConn = server.CreateObject("ADODB.Connection")
  'objConn.ConnectionString ="DSN=ostad.dsn"
  objConn.open("ostad") 
  sqlstring = "SELECT * FROM ostad"

If Request.Form("TypeSearch") = "lname" Then
sqlstring = sqlstring & " WHERE lname LIKE '%"& Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "skill" Then
sqlstring = sqlstring & " WHERE skill LIKE '%"& Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "study_paper" Then
sqlstring= sqlstring & " WHERE study_paper LIKE '%"& Request.Form("DaInBox") & "%'"
End If

dim rsSearch
set rsSearch = server.CreateObject("ADODB.Recordset")
line 32rsSearch.open sqlstring,objConn,, adLockOptimistic, adCmdTable

and this is the error i get

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

/asatid/search.asp, line 32

plz help me to fiz it.whats wrong!?

Hello, try using the other driver than MS Access driver. Might be the driver is causing the error.

the problem is that line 32 should be changed like this:

rsSearch.open sqlstring,objConn,, adLockOptimistic, adCmdText