Hi Gobala,

You are in safe hands of Mr. Craig Berntson, Please refer to link for more detail on VFP-Crystal reporting.

with your permission Mr. Craig Berntson :)

http://www.craigberntson.com/Articles/kb010.htm






>Hi Thank you for replying my query.
>
>I am using Crystal reports 9.2, Visual foxpro 6.0 and backend oracle 8.06.
>
>if i use oledb(Microsoft OLE DB provider for ODBC Drivers)
>When using this i am getting the report for the particular datasource.
>If i try to connect at runtime using another datasource name i am getting logon failed error.
>
>I i use any other driver i was unable to connect at runtime. I am getting logon failed error always.
>
>
>oAppl.logonserver("ado.dll", gcDatasource, ,sqluser,sqlpass)
>
>I am using the above code to connect
>
>suggest me which connection in Crystal reports i should use and how to connect at runtime from vfp 6
>
>
>Thank you.