Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Customize my work (adding issue attributes) error

web-app

I get the following error when I try to add a column to my work (When pressing save)

'SCOPE_IDENTITY' is not a recognized function name.

 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader() at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) at NHibernate.Persister.EntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlString sql, Object obj, ISessionImplementor session)

what am I doing wrong?
est
· 1 		est
Friday, April 7, 2006, 12:38:07 PM
Replies (2)
helpful
0
not helpful

Which version of SQL server are you using?

If it's 7 then change the web.config file to reflect that:

<add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect" />
Mark Wing
· 9108 		Mark Wing
Friday, April 7, 2006, 12:48:29 PM
helpful
0
not helpful

Thank you now it works
est
· 1 		est
Wednesday, April 12, 2006, 9:53:51 AM