Unable to attatch Crystal Report with ado recordset with oracle

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

Do you have a connection established? For instance,

Code:

---

Dim oConn As New ADODB.Connection

---

I'm assuming you did this:

Code:

---

Dim adoRs As New ADODB.Recordset

---

Then open them up

Code:

---

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

---

Then put your code in.

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

Ratnesh