I am trying to use disconnected ADO recordsets. I need to be able to create a recordset with no connection to database. I found many examples of how to do this in VB, but I am using VC++. According to VB example I have to do the following:
create recordset variable
call Append to add fields to recordset
call Open with no parameters
call AddNew to add new rows

I have a problem with calling Open in VC++. It looks like I have to specify a valid, non-empty connection string. Otherwise, Open gives me an exception. If I try to call AddNew without calling Open, it also gives me an exception.

Thank you very much for your help.