cannot open sql server while displaying crystal report

Hi experts:wave:

I am using Oracle database with crystalreport and visual basic 6.0

oracle-database is on the server computer and I want to display report in the crystal report ver 8.0, report is comprise of data from 3-4 tables of the oracle-database using some where clauses or conditions in sql query.
I have placed requred field from 3-4 tables in the crystal report then records are shown in the report preview.(without any error)
But if I call this same report from visual basic program on the button click by passing required sql query it shows the error (cannot open Sql Server).

I am using following codes:

VB Code:

[B]Private Sub Show_Click() [/B] 
 
cr1.ReportFileName = "C:\form4compare\reports\test1.rpt" 
 
cr1.SQLQuery = "Sql Query"
 
cr1.Action = 1 
 
End Sub

same report is displaying without passing sql query (i.e cr1.SQLQuery = "Sql Query") in the above code .But it is not useful for me becuase I want to filter data from where conditions in query.

so plz help me

One more solution that u do not use sql query and u pass that where clause in selection forumla.