Please try this.
Make the command SET IDENTITY_INSERT command as a part
of your stored procedure if you are using one.

If you are using an SQL instead of an adCmdStoredProc
then ensure your sql statement  looks like this:

sql="set identity_insert on" (or "off" depending on
what and you want)

sql = sql & "select xxxxxx"
Then the usual,
recordset_object= open sql, connection_object

Pl. Note: I have answered only part of yr question.

Regards
Srivathsan