RB newbie trying design-time ADO report

rbuser

I'm new to both ADO and RB and i need to update legacy reports from BDE to
ADO.
Playing around trying to learn and can't get ADO report working.

I create a new form, drop a TDatabase and set it up, connects fine, drop a
TppReport and double click it to bring up the designer. Go to "Data" tab
then to File|Data Settings... which lets me select a BDE Session and my
database name. Back to File|New.. and select "Query Wizard" and I'm on my
way, everything works as I'd expect.

Now I try the similar steps for ADO: drop TADOConnection, set it up,
connects fine, drop TppReport, double click to open designer, go to "Data"
tab, File|Data Settings..., select ADOSession, then my ADOConnection, click
OK, then back to File|New.. and select "Query Wizard" and get the following
error message: "Multiple-step OLE DB operation generated errors...."

Can anyone tell me what I'm doing wrong?

I'm using RB Pro 6.02 w/Delphi 5

nicocizik

Hi Larry,

Try running our ADO end-user demo located in the \RBuilder\Demos\4. EndUser
Databases\SQL Server 7\2. ADO\... directory and see if you get the same
results. If you do, you may need to update to the latest version of
ReportBuilder and try with that.

--