inserting data into sql server 7 using Ultra dev

[darenmac]

Hi
I keep getting the getting this error message:
'Microsoft ODBC SQL Server driver: Cannot insert explicit value for identity column in table, when IDENTITY_INSERT is set to OFF'.
I have created a table with an 'id' column using the automatic identity increment. I have set the IDENTITY_INSERT value to ON within the SQL Server, for the apprpriate table, however it is not being recognised by the browser. The reason I think it is a Ultra-Dev issue is because I am able to insert into the table when I do not use automated connection process within it: i.e just using textpad...has anyone come across this issue and more to the point solved it.

 

[haslo]

Did you try looking for some kind of SQL statement that sets this IDENTITY_INSERT value in the code UD created?

allow thyself to be the spark that lights the fire
haslo@haslo.ch - www.haslo.ch​

 

[darenmac]

Yes I have looked in the UD code and their is no reference to the SQL statement 'IDENTITY_INSERT'?
But thanks for your prompt reply.