With some convincing from Hiroshimator, Im working with the ADO.Recordset interface to whip up a simple database.

Things are going quite well thanks to his help with as vbs example, however, im haveing one problem. For some reason i get an error when calling IUnknown::Release() on the pIAdoRecordset. I know the pIAdoRecordset handle is valid, because it makes a visible database on my harddrive and set as i programmed it to. Here is the debug outputs:
eax = 00000001 (ADO.asm, 117)  (1== Created Instance, 0 == Failed)

eax = 00000000, put_CursorLocation (ADO.asm, 123)
eax = 00000000, put_CursorType (ADO.asm, 126)
eax = 00000000, put_LockType (ADO.asm, 129)
eax = 00000000, put_get_Fields (ADO.asm, 132)
eax = 00000000, put_get_Fields (ADO.asm, 135)
eax = 00000000, Append (ADO.asm, 147)
eax = 00000000 (ADO.asm, 156)
eax = 00000000, AddNew (ADO.asm, 176)
eax = 00000000, Update (ADO.asm, 187)
eax = 00000000, Save (ADO.asm, 203)
eax = 00000000, Close (.\mod\CAdo.asm, 147)
eax = 00000001, IUnknown:Release (.\mod\CAdo.asm, 149)

With exception to the first line (non com call), everything else is. So a 0 == success, and 1 == error.

Can anyone add your thoughts as to why it may be doing this?? Is there another ways to close the ADO.Recordset interface?

Thanks in advance!
Posted on 2003-08-24 19:36:47 by NaN
Nevermind, should have searched the net first :rolleyes:

Return Value
Returns the resulting value of the reference count, which is used for diagnostic/testing purposes only

I will assume then that it is releasing properly...
Posted on 2003-08-24 19:44:02 by NaN

Unless there's a reason you haven't mentioned, doesn't a return of one indicate that you still have a reference to the recordset hanging around somewhere?
Posted on 2003-08-29 23:40:23 by djinn
Yes it does... When i posted i thought it ment error...

But what was happening was from an evening of making mistakes, and GPF's, one instance never closed... ( had a bugger of a time working out SafeArray issues ~ ADO is very finiky with this, it doesn return error, it crashes! )

I now have it under control, and i have yet to see it return 1 since ;)

Posted on 2003-08-30 09:20:01 by NaN
I would really like to see the code to your sample. I am beginning to put together a demo myself using ado and I am having problems accessing all of the com methods available.

Posted on 2003-09-15 17:35:07 by Liamo
Which interfaces / methods are you haveing trouble with... Everything works fine from what i have done (early binding on everything).

I would share the code, but its my OOP class stuff and not finished. I have gotten side tracked learning how to write my own COM classes (I plan to database GUID's and some other stuff).

Posted on 2003-09-15 19:19:57 by NaN
Thanks for the reply NaN
I will try to post my sample next week as i have some tidying to do on the code and work is busy at the moment.

Posted on 2003-09-17 17:15:23 by Liamo