ADODB.Recordset.1 error ’80004005’

ADODB.Recordset.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1


/intra2003/announcement_add.asp, line 15

I don't know why I got this error. I can't locate where is the error.

tmpTitle = request.form("ann_title_fr")
tmpContent = request.form("ann_content_fr")
tmpFrom = request.form("ann_from_fr")

Dim conn 'declare connection object.
Dim rs
Dim conString 'declare a temp object.

Session.timeout = 15

set conn = Server.CreateObject("ADODB.Connection") 'create connection object.
set rs = Server.CreateObject("ADODB.Recordset") 'create connection object.
set Session("MyDB_conn") = conn 'set a session timeout.

conString = "Driver={Mysql};Server=localhost; Database=intranet;UID=citylink; PWD=city12017;"
conn.Open( conString ) 'open the connection object to connect to citylink database.

'sql = "SELECT * FROM announcement"
rs.Open "announcement", conn, 3, 3

rs.addnew

rs("title") = tmpTitle
rs("content") = tmpContent
rs("from") = tmpFrom

rs.update
response.write "Done."

Actually, I found out the problem later.

rs("from") = tmpFrom

I got a reserved word (from) for my field.

After I took this out, it works.

Thanks nevertheless.