Thread: S1C00: Only SQL_POSITION/REFRESH is supported for SQLSetPos

    I've just started getting this ODBC error under Windows 95/NT when
trying to modify a record... This is in Visual Basic 5.0.  I haven't had
problems before, and didn't change anything to get this.(I noticed it
when I upgraded 6.5.1, but then downgraded to 6.4.2 thinking that might
be the reason)

--David

secret wrote:
> 
>     I've just started getting this ODBC error under Windows 95/NT when
> trying to modify a record... This is in Visual Basic 5.0.  I haven't had
> problems before, and didn't change anything to get this.(I noticed it
> when I upgraded 6.5.1, but then downgraded to 6.4.2 thinking that might
> be the reason)
> 
> --David

Your application (VB) is trying to use the odbc function SQLSetPos() to
either Update, Delete, or Add a row to a rowset.  Unfortunately, the
driver does not support this advanced feature.

There should be a connect option in vb that deals with how to use the
cursor library.  The cursor library should be capable of translating a
positioned update into a standard one for drivers that don't support
that.

Also, you probably want to turn off the declare/fetch option.

Byron