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


'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




Error :

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

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




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).



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

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