#import ADO using progid

[phinoppix]

Hi,
I'm just starting to learn c++ and am having some trouble with ADO. MSDN says I can #import "progid:ADODB.Recordset" if I don't want to use the dll file or libid. But can't make it work.

I have this working (ADO 2.5):

#import "libid:00000205-0000-0010-8000-00AA006D2EA4" rename("EOF", "EndOfFile")

but doing:

#import "progid:ADODB.Connection"

doesn't work.

from output window:

d:\~phinoppix\_app\phinoppixter\mfc_lessons\mfc_02\FrmTestAdo.h(5) : error C3501: there is no typelib registered for ProgID 'ADODB.Connection'
d:\~phinoppix\_app\phinoppixter\mfc_lessons\mfc_02\FrmTestAdo.h(5) : fatal error C1103: fatal error importing progid: 'ADODB.Connection'

Any help?

PS. The #import with libid does not work on my 2nd machine. But am sure ADO is installed.