I figured out what the problem was I had the property "usecursorschema" in the cursor adapter set to false. I noticed in your sample code that you connect to the SQL data set using ADO is there any advantage of doing it this way instead of using ODBC ?

Thanks Again !