mwcorrell
asked on
My application is not finding the Crystal DLLs
Hello Experts,
I am using crystal reports 11.5 in my web application, which is been built in Visual Studio 2003, and I am using DotNetNuke framework. The problem I am having is only in deployment computer. I do not have the problem in my development computer. My development and deployment computers both have windows 2003 server OS.
My development machine has Crystal Reports 11.5 developers edition installed.
I ran the redistribution package that come with Crystal 11.5, which is called CrystalRedist115_x86.msi, in my deployment machine. I noticed that the install created a folder in program files\business objects\common\35\managed and added some dlls.
The error that I am getting is
“DotNetNuke.Services.Excep
When I add all the crystal’s DLLs to the bin folder of my application that error disappears; but I get another error. (I do not have the DLLs in my bin folder on my development machine)
“CrystalDecisions.CrystalR
I really do not know what is causing these errors. Could you pleaseeee help me? I will really appreciate you help
Thanks
Maria
I am using crystal reports 11.5 in my web application, which is been built in Visual Studio 2003, and I am using DotNetNuke framework. The problem I am having is only in deployment computer. I do not have the problem in my development computer. My development and deployment computers both have windows 2003 server OS.
My development machine has Crystal Reports 11.5 developers edition installed.
I ran the redistribution package that come with Crystal 11.5, which is called CrystalRedist115_x86.msi, in my deployment machine. I noticed that the install created a folder in program files\business objects\common\35\managed and added some dlls.
The error that I am getting is
“DotNetNuke.Services.Excep
When I add all the crystal’s DLLs to the bin folder of my application that error disappears; but I get another error. (I do not have the DLLs in my bin folder on my development machine)
“CrystalDecisions.CrystalR
I really do not know what is causing these errors. Could you pleaseeee help me? I will really appreciate you help
Thanks
Maria
ASKER
Hello mlmcc,
I have added 4 variable in the web.config file, which are the following :
<add key="Servername" value="xxx"/>
<add key="Databasename" value="yyy"/>
<add key="Userid" value="zzz"/>
<add key="Password" value="aaaa"/>
This variables are been used in the following sub. (This works great in the development machine and in another application in the deployment machine that is using crystal report 9)
Private Sub CreateReport(ByVal sReport As String, _
ByVal arParams As Array, _
Optional ByVal DoParams As Boolean = True)
Dim oRpt As New ReportDocument
Dim oSubRpt As New ReportDocument
Dim Counter As Integer
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As CrystalDecisions.CrystalRe
Dim crLogOnInfo As TableLogOnInfo
Dim crConnInfo As New ConnectionInfo
Dim crParameterValues As ParameterValues
Dim crParameterDiscreteValue As ParameterDiscreteValue
Dim crParameterRangeValue As ParameterRangeValue
Dim crParameterFieldDefinition
Dim crParameterFieldDefinition
Dim crParameterFieldDefinition
Dim strFile As String
Dim fi As FileInfo
Dim tstr As String
Dim sPath As String
Dim configurationAppSettings _
As System.Configuration.AppSe
New System.Configuration.AppSe
Dim sReportPath As String = GetAbsoluteServerPath(Requ
Dim pos As Integer
tstr = Microsoft.VisualBasic.Form
strmessage = "Problem loading the Report"
oRpt.Load(sReportPath)
'log on to SQL server
'Report code starts here
'Set the database and the tables objects to the main report 'oRpt'
crDatabase = oRpt.Database
crTables = crDatabase.Tables
'Loop through each table and set the connection info
'Pass the connection info to the logon info object and then
' apply the logon info to the main report
For Each crTable In crTables
With crConnInfo
.ServerName = configurationAppSettings.G
.DatabaseName = configurationAppSettings.G
.UserID = configurationAppSettings.G
.Password = configurationAppSettings.G
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo
crTable.ApplyLogOnInfo(crL
If (crTable.TestConnectivity(
If (crTable.Location.IndexOf(
crTable.Location = crTable.Location.Substring
Else
crTable.Location = crTable.Location
End If
End If
Next
'Set the sections collection with report sections
crSections = oRpt.ReportDefinition.Sect
'Loop through each section and find all the report objects
'Loop through all the report objects to find all subreport
' objects, then set the logoninfo to the subreport
For Each crSection In crSections
crReportObjects = crSection.ReportObjects
For Each crReportObject In crReportObjects
If crReportObject.Kind = _
ReportObjectKind.Subreport
'If you find a subreport, typecast the reportobject
' to a subreport object
crSubreportObject = CType(crReportObject, SubreportObject)
'Open the subreport
oSubRpt = _
crSubreportObject.OpenSubr
crSubreportObject.Subrepor
crDatabase = oSubRpt.Database
crTables = crDatabase.Tables
'Loop through each table and set the connection info
'Pess the connection info to the logoninfo
' object then apply the logoninfo to the subreport
For Each crTable In crTables
With crConnInfo
.ServerName = _
configurationAppSettings.G
GetType(System.String))
.DatabaseName = configurationAppSettings.G
.UserID = configurationAppSettings.G
.Password = configurationAppSettings.G
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo
crTable.ApplyLogOnInfo(crL
Next
End If
Next
Next
' Set the parameters
If DoParams Then
'Get the collection of parameters from the report
crParameterFieldDefinition
oRpt.DataDefinition.Parame
For Counter = 0 To UBound(arParams) - 1
crParameterFieldDefinition
crParameterFieldDefinition
'
'Get the current values from the parameter field.
crParameterValues = crParameterFieldDefinition
If Not IsArray(arParams(Counter))
'Test if param passed in matches CR param receiving
Dim test As String
Dim paramcounter As Integer
For paramcounter = 0 To UBound(arParams) - 1
' Response.Write(arParams(pa
test = arParams(paramcounter)
' Grabs param from CR and compares against param
' passed in
If test.StartsWith(LCase(crPa
ParameterFieldName())) Then
test.Substring(test.IndexO
'Set the current values for the parameter field 0
crParameterDiscreteValue = New ParameterDiscreteValue
crParameterDiscreteValue.V
test.Substring(test.IndexO
'Add the first current value for the parameter field
crParameterValues.Add(crPa
Exit For
End If
Next
Else
crParameterRangeValue = New ParameterRangeValue
crParameterRangeValue.Star
crParameterRangeValue.EndV
crParameterValues.Add(crPa
End If
'All current parameter values must be applied for the
'parameter field.
crParameterFieldDefinition
Next
End If
End sub
Thank you
Maria
I have added 4 variable in the web.config file, which are the following :
<add key="Servername" value="xxx"/>
<add key="Databasename" value="yyy"/>
<add key="Userid" value="zzz"/>
<add key="Password" value="aaaa"/>
This variables are been used in the following sub. (This works great in the development machine and in another application in the deployment machine that is using crystal report 9)
Private Sub CreateReport(ByVal sReport As String, _
ByVal arParams As Array, _
Optional ByVal DoParams As Boolean = True)
Dim oRpt As New ReportDocument
Dim oSubRpt As New ReportDocument
Dim Counter As Integer
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As CrystalDecisions.CrystalRe
Dim crLogOnInfo As TableLogOnInfo
Dim crConnInfo As New ConnectionInfo
Dim crParameterValues As ParameterValues
Dim crParameterDiscreteValue As ParameterDiscreteValue
Dim crParameterRangeValue As ParameterRangeValue
Dim crParameterFieldDefinition
Dim crParameterFieldDefinition
Dim crParameterFieldDefinition
Dim strFile As String
Dim fi As FileInfo
Dim tstr As String
Dim sPath As String
Dim configurationAppSettings _
As System.Configuration.AppSe
New System.Configuration.AppSe
Dim sReportPath As String = GetAbsoluteServerPath(Requ
Dim pos As Integer
tstr = Microsoft.VisualBasic.Form
strmessage = "Problem loading the Report"
oRpt.Load(sReportPath)
'log on to SQL server
'Report code starts here
'Set the database and the tables objects to the main report 'oRpt'
crDatabase = oRpt.Database
crTables = crDatabase.Tables
'Loop through each table and set the connection info
'Pass the connection info to the logon info object and then
' apply the logon info to the main report
For Each crTable In crTables
With crConnInfo
.ServerName = configurationAppSettings.G
.DatabaseName = configurationAppSettings.G
.UserID = configurationAppSettings.G
.Password = configurationAppSettings.G
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo
crTable.ApplyLogOnInfo(crL
If (crTable.TestConnectivity(
If (crTable.Location.IndexOf(
crTable.Location = crTable.Location.Substring
Else
crTable.Location = crTable.Location
End If
End If
Next
'Set the sections collection with report sections
crSections = oRpt.ReportDefinition.Sect
'Loop through each section and find all the report objects
'Loop through all the report objects to find all subreport
' objects, then set the logoninfo to the subreport
For Each crSection In crSections
crReportObjects = crSection.ReportObjects
For Each crReportObject In crReportObjects
If crReportObject.Kind = _
ReportObjectKind.Subreport
'If you find a subreport, typecast the reportobject
' to a subreport object
crSubreportObject = CType(crReportObject, SubreportObject)
'Open the subreport
oSubRpt = _
crSubreportObject.OpenSubr
crSubreportObject.Subrepor
crDatabase = oSubRpt.Database
crTables = crDatabase.Tables
'Loop through each table and set the connection info
'Pess the connection info to the logoninfo
' object then apply the logoninfo to the subreport
For Each crTable In crTables
With crConnInfo
.ServerName = _
configurationAppSettings.G
GetType(System.String))
.DatabaseName = configurationAppSettings.G
.UserID = configurationAppSettings.G
.Password = configurationAppSettings.G
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo
crTable.ApplyLogOnInfo(crL
Next
End If
Next
Next
' Set the parameters
If DoParams Then
'Get the collection of parameters from the report
crParameterFieldDefinition
oRpt.DataDefinition.Parame
For Counter = 0 To UBound(arParams) - 1
crParameterFieldDefinition
crParameterFieldDefinition
'
'Get the current values from the parameter field.
crParameterValues = crParameterFieldDefinition
If Not IsArray(arParams(Counter))
'Test if param passed in matches CR param receiving
Dim test As String
Dim paramcounter As Integer
For paramcounter = 0 To UBound(arParams) - 1
' Response.Write(arParams(pa
test = arParams(paramcounter)
' Grabs param from CR and compares against param
' passed in
If test.StartsWith(LCase(crPa
ParameterFieldName())) Then
test.Substring(test.IndexO
'Set the current values for the parameter field 0
crParameterDiscreteValue = New ParameterDiscreteValue
crParameterDiscreteValue.V
test.Substring(test.IndexO
'Add the first current value for the parameter field
crParameterValues.Add(crPa
Exit For
End If
Next
Else
crParameterRangeValue = New ParameterRangeValue
crParameterRangeValue.Star
crParameterRangeValue.EndV
crParameterValues.Add(crPa
End If
'All current parameter values must be applied for the
'parameter field.
crParameterFieldDefinition
Next
End If
End sub
Thank you
Maria
Nothing jumps out. Are you using the correct user/password? DOes the user have database permissions?
mlmcc
mlmcc
ASKER
Yes, everything looks good.
I think the main question is why do I have to put the DLLs in the bin folder? My other applications do not need the dll in the bin folder.
Maria
I think the main question is why do I have to put the DLLs in the bin folder? My other applications do not need the dll in the bin folder.
Maria
I don't think they have to be in the bin folder but then I don't use the .Net version. They do need to be registered.
mlmcc
mlmcc
Put the .dlls in the bin folder and see if in fact that is the issue....
MikeV
MikeV
ASKER
When I placed the DLLs in the bin folder the following error disapears
"System.IO.FileNotFoundExc
But I get the
"Unable to connect: incorrect log on parameters. ---> CrystalDecisions.CrystalRe
Thanks for the help
Maria
Do you know which line is getting the error?
mlmcc
mlmcc
ASKER
For the first error no: Here is the complete error message:
Message: DotNetNuke.Services.Except
For the second error YES:
Is in the oRpt.Export() line of the following piece of code
ExportFileName = exportpath & MyBase.UserInfo.Username.T
oRpt.ExportOptions.ExportD
oRpt.ExportOptions.ExportF
oDest.DiskFileName = ExportFileName
oRpt.ExportOptions.Destina
oRpt.Export()
Dim strPortalAlias As String
Dim urlstring As String
strPortalAlias = GetPortalDomainName(Portal
Response.RedirectLocation = "target=_blank"
Response.Redirect("http://" & strPortalAlias & "/export/" & MyBase.UserInfo.Username.T
Thanks
Maria
Message: DotNetNuke.Services.Except
For the second error YES:
Is in the oRpt.Export() line of the following piece of code
ExportFileName = exportpath & MyBase.UserInfo.Username.T
oRpt.ExportOptions.ExportD
oRpt.ExportOptions.ExportF
oDest.DiskFileName = ExportFileName
oRpt.ExportOptions.Destina
oRpt.Export()
Dim strPortalAlias As String
Dim urlstring As String
strPortalAlias = GetPortalDomainName(Portal
Response.RedirectLocation = "target=_blank"
Response.Redirect("http://" & strPortalAlias & "/export/" & MyBase.UserInfo.Username.T
Thanks
Maria
ASKER
This is the complete error message for the second error
Message: DotNetNuke.Services.Except
Message: DotNetNuke.Services.Except
Verify you have the correct information in the config file and that it is being read correctly.
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Everyone,
Thank you for all your comments.
I am still having the same problem. I have tried everything, including hardcodign the logon parameters, but nothing new. I am still getting the error:
DotNetNuke.Services.Except
Any Other suggestion, pleaseeee.
Maria
Thank you for all your comments.
I am still having the same problem. I have tried everything, including hardcodign the logon parameters, but nothing new. I am still getting the error:
DotNetNuke.Services.Except
Any Other suggestion, pleaseeee.
Maria
mlmcc