Hi all,
'm using ADODB.Command object for interactig with database in my application.
In the code i'm calling "Execute" method to insert a new row into the database. After writing data into the the database the identity key of that row is being returned. I can see that ID is being returned from database successfully, also in the backend i can see the new row which was inserted.
Immediately after this, i'm setting "ActiveConnection" property to "nothing"
Set objCmd.ActiveConnection = Nothing
The application hangs at this stage. The code after this lines are not executed. Also I checked the "ActiveConnection" value, it is showing a valid connection string.
Any pointers on what might have gone wrong???