>>You are using .net correct?
>>Are you using the sql anywhere data provider?
>
>I am using the ODBC provider. Are you recommanding I switch to the SQL Anywhere data provider?
>
>>Also, if you are using the sql anywhere for wince or Ultralight, there are some slight syntax differences.
>
>So, I am better to define specific code for generating the parameters. In the DataProvider class, I have a nBackend and nSQLMode properties. nBackend denotes the type of database. nSQLMode denotes the type of connection. The class is generic. But, on three methods, I have some specific custom to generate the proper parameterized code so to fit the backend.

I am not very good with .net but I would look at the net data provider. Seems to me it would be much closer to Sql server then using the odbc provider. Seems to me if you where going to use the ODBC provider then you should use the ?parametervar similar to using ODBC with VFP.