"Server has not yet been opened" error message

[Creepers]

Using VB6/CRView ocx and Crystal Reports 8.5. Pulling data from Oracle. On my development machine the following code works. However on my test machine I receive the following error:
Error No: -2147192184
Error Desc: Server has not yet been opened

MsgBox "Line 1"

Dim CrystalApp As New CRAXDRT.Application
MsgBox "Line 2"
Dim CrystalRpt As New CRAXDRT.Report
MsgBox "Line 3"

Set CrystalApp = CreateObject("CrystalRunTime.Application&quot
MsgBox "Line 4"
CrystalApp.LogOnServer "p2sodbc.dll","DMART01",,"DW_USER","DW_USER"
MsgBox "Line 5"

Set CrystalRpt = CrystalApp.OpenReport(Me.ReportDirectory & Me.ReportName)
MsgBox "Line 6"
Me.CRViewer.ReportSource = CrystalRpt
MsgBox "Line 7"
CrystalRpt.RecordSelectionFormula = Me.WhereClause
MsgBox "Line 8"
Me.CRViewer.ViewReport
MsgBox "Line 9"
Me.CRViewer.Zoom 78
MsgBox "Line 10"

The code between Line 4 and Line 5 is where the error occurs. Please advise...
Thanks
Creepers

 

[Reebo99]

IS the ODBC setup on the test machine? Juan
Scotland (currently)

 

[Creepers]

Yes

 

[Reebo99]

The oracle client is installed and the service name has been setup?

Sorry if this sounds like a basic question, I not meaning to sound condescending but the only problems I've had connecting to Oracle have been outside Crystal Reports.

You could also try using the native connection, P2loar7.dll or P2sora7.dll, which should connect in the same way but provide faster connection. Juan
Scotland (currently)

 

[Reebo99]

The oracle client is installed and the service name has been setup?
Does the test machine have P2sodbc.dll on it? I think this is only installed with Crystal Reports, I might be wrong on that though.

Sorry if these sound like a basic questions, I not meaning to sound condescending but the only problems I've had connecting to Oracle have been outside Crystal Reports.

You could also try using the native connection, P2loar7.dll or P2sora7.dll, which should connect in the same way but provide faster connection. Using this stops you from adding different database types to a single report, i.e. only oracle data sources

Juan
Scotland (currently)

 

[Reebo99]

The oracle client is installed and the service name has been setup?
Does the test machine have P2sodbc.dll on it? I think this is only installed with Crystal Reports, I might be wrong on that though.

Sorry if these sound like a basic questions, I not meaning to sound condescending but the only problems I've had connecting to Oracle have been outside Crystal Reports.

You could also try using the native connection, P2lora7.dll or P2sora7.dll, which should connect in the same way but provide faster connection. Using this stops you from adding different database types to a single report, i.e. only oracle data sources

Juan
Scotland (currently)

 

[Reebo99]

Sorry for the multiple responses. Our connection is absolutely pants! Juan
Scotland (currently)

 

[Creepers]

Yes, the oracle client is installed and the service name has been setup. The machine does have PD2odbc.dll.

I do not have PDloar7.dll, however I do have P2sora7.dll. I used the P2sora7.dll and received the same error (not trapped by my handler, but by the ocx) between Line 9 and Line 10.

 

[Reebo99]

Creepers,

I've had a search around and found this url :

http://support.crystaldecisions.com/library/kbase/articles/c2006666.asp

It should give you a little bit more info. I'm not sure it will solve you're particular error though.

Enjoy! Juan
Scotland (currently)

 

[Reebo99]

also if you go to

http://www.crystaldecisions.com

and search for
cr_server_not_yet_been_opened.pdf

this might help a bit more.
Juan
Scotland (currently)

 

[Creepers]

Reebo99...Thanks for your time. I will research the two urls you supplied.