>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.