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.