I have connected to SQL Server 6.5 through ADO Data Control ( VB 6.0 ) using a DSN.

I have declared the ADO connection object Dim con As New ADODB.Connection
& the recordset ( rs ) As New ADODB.Recordset

When I try to add a new record through VB I get a
Run-time error '3251'

"The operation requested by the application is not supported by the provider."

at - > rs.addnew.

Please let me know why.
I would appreciate any help.

Thanks,
Vidya.