I tryed renaming the table and that didnt seem to work. Plus also the C_Date is a nvarchar field, but what I tryed to do was run the query without the field and still got the oledb error code. Also I did run the query in query analyzer and it worked just fine.
Second, I tryed changing the datasource to odbc, but the same error is occuring. Mike --------------------------------- Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
