Skip to Content

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

Crystal Reports 2008 - on Vista error (Oracle db)

I have problem when i try launch one report on Vista,

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

- Using : Visual basic .net(Framework: 2.0 )

- Windows Vista SP1

- Crystal Reports 2008

- CrystalDecisions.CrystalReports.Engine.ReportDocument

- CrystalDecisions.Shared.ConnectionInfo

Code:(details)

'Oracle provider

dbAttributes.Collection.Set("Server", "ORCL")

dbAttributes.Collection.Set("Trusted_Connection", False)

con.ServerName = odbConfig.DataSource

con.DatabaseName = ""

con.UserID = odbConfig.UserId

con.Password = odbConfig.Password

con.Attributes.Collection.Set("Database DLL", "crdb_oracle.dll")

con.Attributes.Collection.Set("QE_DatabaseName", "")

con.Attributes.Collection.Set("QE_DatabaseType", "Servidor de Oracle")

con.Attributes.Collection.Set("QE_ServerDescription", "ORCL") con.Attributes.Collection.Set("QE_SQLDB", True)

con.Attributes.Collection.Set("SSO Enabled", False)

con.Attributes.Collection.Set("QE_LogonProperties", dbAttributes)

..crTableLogOnInfo.ConnectionInfo = con

crTable.ApplyLogOnInfo(crTableLogOnInfo)..

.

After..CRViewer.Show()

Error :

(Crystal error) : "Failed to retrieve data from the database"

Details : [Código de proveedor de base de datos: 942.

-

-


RAS

Using usar Report App Server, i have problems too,

using Oracle connection.

- Using : Visual basic .net(Framework : 2.0 )

- Windows Vista SP1

- Crystal Reports 2008

- CrystalDecisions.ReportAppServer.DataDefModel.ConnectionInfo

- CrystalDecisions.ReportAppServer.DataDefModel.PropertyBag

- CrystalDecisions.ReportAppServer.DataDefModel.Controllers

Code :

.. boAttributesPropertyBag("QE_DatabaseType") =

"Oracle Server"..

..boLogonPropertyBag.Add("Provider", "MSDAORA")

boLogonPropertyBag.Add("Server", odbConfig.DataSource) 'Service name

boLogonPropertyBag.Add("Trusted_Connection", False)...

Error on : ..boDatabaseController.SetTableLocation(boTable, boTableNew)..

Error details (RAS) :Failed to retrieve data from the database. xxxxxxx.rpt: StackTrace: CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(u2026.

I haven`t problem when i launch the report from Crystal Reports designer.(on Oracle, the same server and DB).

Regards

Ismael

Edited by: Ismael Ramirez Rodriguez on Oct 14, 2008 5:20 PM

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