Hi Craig,

The Part that I am trying to do away with on Page 218 is the
oCommand.CommandText = "Select * from Customers where Country = 'France'"
That is the part(s) that are defined in the Crystal Report...

I just want to take a OLEDB Crystal Report, Pass the Login Credentials
and run it...

So in ODBC I just cruise through the Tables and do a quick little:

oDBT = ocDBT.ITEM(1)

FOR jnx = 1 TO ocDBT.COUNT
oDBT.SetLogOnInfo("Acaps_Reports",'report','report')
ENDFOR

But in OleDb it doesnt seem I can do this... ??

Thanks!
Bob




>Look at the example on page 218 in my book.
>
>Essentially, there is no difference to Crystal when connecting via ODBC or OLE DB/ADO.
>
>Are you getting error messages?
>
>
>>Hi Craig,
>>
>>Thank you for the samples and I the Book you wrote is awesome as well...
>>
>>The samples on the web site / book show that I have to
>>Create a Recordset and then Pass it...
>>
>>But all this information is in the .RPT Report...
>>Do I have to do this all 2X??
>>
>>Thanks!
>>Bob
>>