error using rdoConnection

[Goha]

I get the following error message when I run the (on last line)

sql_string = "select * from report_def where Description = '" & Trim(strNodeText) & "' and param_name = '" & RDEF(I).PARAM_NAME & "'"

Set rdofind = cn.OpenResultset(sql_string, rdOpenForwardOnly, rdConcurReadOnly)

-------------------------------------------------

Run-time error '40002': 37000:[Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s)could not be prepared

what is the problem it is working in other places of the program.

 

[TomKane]

What does the contents of sql_string look like at run time? Does this query run in query analyzer?