Crystal 11 RDC Oracle 9 Connection

[TheEntertainer]

Dear All,

I apologise if this question has been asked and answered elsewhere on this forum, I've tried to look but can't find anything that explains it (simply enough anyway!).

After diming the appropriate objects :
Sub luck()
Dim application As CRAXDRT.application

Dim report As CRAXDRT.report
Dim export As CRAXDRT.ExportOptions
Dim ConnectionInfo As CRAXDRT.ConnectionProperties
Set application = CreateObject("CrystalRuntime.application.11")
Set report = application.OpenReport("H:\Report.rpt")

I used to connect to earlier versions of the Crystal RDC with (I think):

report.Database.Tables(1).SetLogOnInfo "Server", "", "User", "dPasswd"

But this dosn't seem to work with Crystal 11. It errors with the message

Run-Time Error '-2147189155' (80047e5d)':
Failed to open connection

if I do:
MsgBox report.SQLQueryString
MsgBox report.RecordSelectionFormula
I can get the recordselectionformula for the report, but I can't get anything for thre SQLQueryString as I'm not connected to the database.

Can someone just explain what the connection string should be for Crystal 11 RDC access to Oracle 9 database

If I've missed anything out then I apologise.

Thanks

 

[Durango122]

hi
Oracle Native Driver

The Oracle native driver for CR XI requires the Oracle 9.2 or higher client, and the Oracle 8.17 or higher server. Before migrating reports based on the Oracle Native driver, make sure you have Oracle 9.2 or higher installed to continue using the native connection. If you do not have Oracle 9.2 or higher you can try switching to an ODBC connection to continue using an older version of the Oracle client.



Durango122

 

[TheEntertainer]

Hi Durango122,

Sorry for not getting back to you earlier but I've had some other things to sort out. Anyway I do have 9.2 client installed, so I'm not sure, what the problem is?

What I need to figure out is what is the property in RDC, which you set to connect to the database and what is the syntax for doing so.

Thanks