DaniWeb Forum Index > Web Development > ASP

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

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2005

Posts: 14

Reputation: zizi is an unknown quantity at this point

Solved Threads: 0

zizi

Offline

Newbie Poster

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

Sep 30th, 2006

hello everybody;

this is my code

Help with Code Tags

(Toggle Plain Text)

<%
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!?