AutoCAD 2011 and database connection

[smvest]

I am running AutoCAD Map 3D 2011 on a 64-bit using Windows 7.  I try creating a new feature in CAD to add to the map/ database and I keep getting the same error message:

Messages

Feature was not saved in the target feature source.

Message details

- Failed to insert feature

- 1=Failed to executed Fdo command.

- 2=Microsoft SQL Server Native Client 10.0: Invalid input parameters values. Check the status values for detail. (0)

- 3=Underlying DBMS error (-51)

- 4=Stream execute failed.

Failed to save edit set.

Failed to insert feature.

Failed to execute Fdo command.

Microsoft SQL Server Native Client 10.0: Invalid input parameter values. Check the status values for detail. (0).

Underlying DBMS error (-51)

Stream execute failed.

Failed to save edit set.

I am thinking this has something to do with the ObjectID in the database.  It is the only column I believe needs to be generated in the table for it to be checked back in.  Is this correct and how I auto-generate it (it is grayed out and will not let me put a number in manually)?  Any info/help will be much appreciated.

Thank you,

Sue

[jackie.ng]

What version of SQL Server are you using?

Which FDO provider are you using to connect to this database? (ODBC? SQL Server? SQL Server Spatial?)

To find out if your ObjectID is auto-generated, open your connection in the Schema Editor (Map Explorer tab in your Task Pane, select the SQL Server connection then go Schema - Edit Schema). In your Schema Editor locate your ObjectID property and see if Auto Generated is set to true

- Jackie

[smvest]

We have 2008 SQL server and I am using ArcSDE to connect to the database.  I checked to see if the ObjectID property was being Auto Generated and it is.  I create a point by right clicking on the layer.  When I try to check it in I get the error message and it appears the ObjectID is not being Auto Generated.  Is there some other variable that needs to be turned on?

Thanks,

Sue