Do a response.write of your sql statement to see if it is contructed without any issues. And try running that directly in your DB and see if that produces the same error or runs successully.
- Have the provider generate an SQL query and return all rows from the specified table
= Evaluate as a textual definition
Try adCmdText there. Take a look at this page Recordset.Open method
- Vijay G
Strive for Perfection