Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cry.Reports 08,VB.NET on Oracle - Failed to retrieve data from the database

CrystalDecisions.CrystalReports.Engine.ReportDocument

I have a Crystal Report (2008) that i launch from a VB.NET

I have problem when i try to change CrystalDecisions.Shared.ConnectionInfo .

when i'm using Oracle connection (the report worked fine on SQL).

Getting this error when launch the report.

Error message :

Crystal Report Windowes Forms Viewer:

{bold} {bold}

The report is developed using crystal version 2008.

The code i am using to run the Crystal Report (similar worked fine on SQL) is as follows:

CrystalDecisions.Shared.ConnectionInfo

Oracle Provider : 
          dbAttributes = New CrystalDecisions.Shared.DbConnectionAttributes
          dbAttributes.Collection.Set(u201DServeru201D, u201COracleServiceNameu201C)
          dbAttributes.Collection.Set(u201DTrusted_Connectionu201D, False)
          u2019setup the connection
          crConnectionInfo = New CrystalDecisions.Shared.ConnectionInfo
          crConnectionInfo.LogonProperties.Clear()
          crConnectionInfo.Attributes.Collection.Clear()
          crConnectionInfo.DatabaseName = u201Cu201D
          crConnectionInfo.ServerName = u201COracleServiceNameu201C
          crConnectionInfo.UserID = u201CReportsUserNameu201C
          crConnectionInfo.Password = u201CReportsPasswordu201D
          crConnectionInfo.Attributes.Collection.Set(u201DDatabase DLLu201D, u201Ccrdb_oracle.dllu201D)
          crConnectionInfo.Attributes.Collection.Set(u201DQE_DatabaseNameu201D, u201Cu201D)
          crConnectionInfo.Attributes.Collection.Set(u201DQE_DatabaseTypeu201D, u201COracle Serveru201D)
          crConnectionInfo.Attributes.Collection.Set(u201DQE_LogonPropertiesu201D, dbAttributes)
          crConnectionInfo.Attributes.Collection.Set(u201DQE_ServerDescriptionu201D, config.ServerName)
          crConnectionInfo.Attributes.Collection.Set(u201DQE_SQLDBu201D, True)
          crConnectionInfo.Attributes.Collection.Set(u201DSSO Enabledu201D, False)
          crConnectionInfo.LogonProperties = dbAttributes.Collection  

Is better use :

(Dataset DLL, "crdb_ado.dll"), ¿?

("Provider", "MSDAORA"), ¿?

("QE_DatabaseType", "OLE DB (ADO)"))¿?

Regards

Ismael

Former Member
replied

Hi,

Please post this query to the NET Development - Crystal Reports forum:

[;

That forum is monitored by qualified technicians and you will get a faster response there.

Thank you for your understanding,

Shweta

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question