cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports 2008 - on Vista error (Oracle db)

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Ismael, a few suggestions;

1) Remeber that Oracle is case sensitive, so ensure that is in order.

2) Have a look at the following threads and see if they help:

https://forums.sdn.sap.com/click.jspa?searchID=17494545&messageID=6325240

https://forums.sdn.sap.com/click.jspa?searchID=17494545&messageID=5919267

https://forums.sdn.sap.com/click.jspa?searchID=17494765&messageID=6023461

3) As a test, comment out the logon code, let the report prompt and fill in the logon parameters when prompted. Does that work?

4) You do not mention if this is a web or a win app. If this is a web app, try a simple win app. If the win app works, you are looking at permissions issue

5) Ensure that you have SP 0 for CR 2008 applied. SP 0 is here:

https://smpdl.sap-ag.de/~sapidp/012002523100007528552008E/cr2008_sp0.zip

6) When you say he report works inthe designer, is this designer on the same Vista box as where you get the runtime error?

Ludek

Former Member
0 Kudos

Ludek

Is a win app.

The reports works in the designer, XP..

Regards

Ismael

former_member183750
Active Contributor
0 Kudos

Did any of the links I provided help? What was the results you got from those links?

Ludek

Answers (0)