Insert Error

[Raghavendra Kulkarni]

I get the below error when our application tries to run a stored procedure
that is trying to insert a record in a table.

"com.sybase.jdbc2.jdbc.SybSQLException: Explicit value specified for
identity field in table 'mpstb_print_test' when IDENTITY_INSERT is set to
OFF."

Would appreciate anyone throwing light on the possible cause for such an
error.

Thanks in advance.

Raghu

[Gad Krosner]

I think it tells you not to specify a value for your IDENTITY column, because
Sybase generates a value for it automatically.

[Cliff Youse]

logged in as sa try:

use master
go
sp_dboption datbasename, "auto identity", true
go
use databasename
go
checkpoint
go

where databasename = the name of the database

"Raghavendra Kulkarni" <ra...@antispam.com> wrote in message
news:wpH20so...@forums.sybase.com...