on 09-29-2008 2:57 PM
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.