Hi Folks,
I'm trying use a USERCONNECTION in VB 6 to access my SQL database. I'm not using Stored procedure, I just write the SQL code into the "User Defined SQL" part of the userconnection.

The problem is that I'm trying to insert a new record into a table (EventCause) that has 3 fields (CauseID,Faultid,FaultCause), but I keep getting an error from ODBC :-
"Attempting to insert explicit value for indetity column in table "EventCause" when IDENTITY_INSERT is set to OFF"

What does this mean??? How can I set the identity to ON (if thats the case) from my "User-Defined SQL"

User-Defined SQL
----------------

Insert Into Eventcause(CauseID,FaultID,FaultCause) VALUES (?,?,?)

N.B. The '?' are being passed from the calling statement as parameters

Thanks,
Craig.