Unable to attatch Crystal Report with ado recordset with oracle

[Ratnesh Namdeo]

Hi all!
I am using CR8, and VB 6 with Oracle 8i client/server architect.
I have some problem with crystal report viewer.

i have written code like this;

'''connection is open and recordset is also open

rptMyReprt.Databse.setdatasource= adoRS
frmreportview.crview.reportsource=rptMyReport

'these above lines run correctly, after that on given line error occoured

frmreportview.crview.ViewReport

'''this code gives error "Server has not yet been Opened"


because this code is written for oracle client side i am not able to connect CR viewer with ORACLE server.
Please help!

Ratnesh

[transio]

Do you have a connection established? For instance,

Dim oConn As New ADODB.Connection

I'm assuming you did this:

Dim adoRs As New ADODB.Recordset

Then open them up

oConn.Open "Connection String"
adoRs.Open "SELECT column FROM table", oConn

Then put your code in.

[Ratnesh Namdeo]

Thanks Steve,
I have already opened then connection and Recordset as you have sugested but it didnt work.
It Gives same error.

Ratnesh