Sunday, March 25, 2012
Crystal Server logon error - Urgent.
Can anybody please help me or point me in the right direction here.
The ongoing problem is that I have uploaded my reports to the crystal server at work. Everytime I try to view a report, it tells me I have a logon error as follows, "The database logon information for this report is either incomplete or incorrect." I have tried to make a new report with a new sql database connection on the server at work - I still get the same error message.
The ODBC settings are exactly the same as my own server at home. I have the same username and password as well. I can view the reports at home without any problems. But can't view them from the work server.
If I view the reports through a JDBC connection I can view the reports on the server at work. But if I change the connection to ODBC, no report can be viewed. I can view the same reports on my home server regardless of what type of connection it is, ODBC or JDBC.
For the life of me, I just can't seem to figure out the root of the problem? Please help me.
Best regards
SafIf you don't mind my asking, have you figured out your database logon problem?. We occasionally have the same problem, and still don't know why it happens.|||See if you find solution here
www.businessobjects.com
Thursday, March 22, 2012
Crystal Reports over network
I have received the following error message when tring to load a report which is accessing data over a network from sql server.
The table " could not be found.
Here is the code to try and access a number of reports;
Any help is much appreciated.
Thanks
Private Sub btnRunReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRunReport.Click
Try
MyBase.Cursor = Cursors.WaitCursor
If Me.cboReports.SelectedIndex = 0 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\1.rpt"
ElseIf Me.cboReports.SelectedIndex = 1 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\2.rpt"
ElseIf Me.cboReports.SelectedIndex = 2 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\L3.rpt"
ElseIf Me.cboReports.SelectedIndex = 3 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\4.rpt"
ElseIf Me.cboReports.SelectedIndex = 4 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\5.rpt"
ElseIf Me.cboReports.SelectedIndex = 5 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\6.rpt"
ElseIf Me.cboReports.SelectedIndex = 6 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\7.rpt"
End If
'MsgBox("Please load pre-printed stationary into the printer.")
crvReports.PrintReport()
crvReports.RefreshReport()
MyBase.Cursor = Cursors.Arrow
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
End ClassOpen the report and do verify database and make sure it is pointing to the correct databasesql
Crystal Reports Export error 8.5
I installed all SP & hotfixes for exporting and still no luck. Called tech support and they don't support version 8.5 so they would not help me.
Can somebody please help me! I have just 2 applications left that use crystal reports 8.5 and they are well heavily.
This is the error:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Export'Hi Dough,
Just wondering if you ever found a fix to the crystal report export. I am having the exact same issue with Windows Server 2003 / ASP 3.0 / IIS 6.0.
Thanks,
Troye Stonich|||I may have a solution for you to try.
I found it may be necessary to set the Display Progress Dialog to False. Most likely due to security restrictions on the IIS 6 Win2003 server.
Right before the Session Export line, Enter the following line,
Session("oRpt").DisplayProgressDialog = False
This helped me, doing a simple PDF Export (no viewer). Crystal does not present this dispaly in sample ASP they provide, (9.0 and below). For me it was pretty much a trial and error to resolve this issue.
If the above does not work, try the following 4 lines:
Dim strContentType
strContentType = "application/pdf"
Session("oRpt").DisplayProgressDialog = False
Response.ContentType = strContentType
Hope this helps.
Steve|||You guys are GREAT !
Thank you so mutch, i was getting crazy because of this problem :-)
Crystal Reports error
I have a C# project which contains a web form, which has a button calling a web page containing a crystalreportviewer, which contains a CrystalReport report; when I call this page through Response.Redirect("WebForm2.aspx"); WebForm2 is not opening, instead it is sending me an error: [Null]Reference Exception: Reference to object does not stated as object's instance.]
Somebody know what is reason of this error?
I'll thank you for your help.
A.L.Hello.
At last I found the way to solve it. Something wrong was in it.
I reinstalled Visual Studio .NET.
Regards.
A.L.
:wave:
crystal reports and Sql Server 2k
Sql Server 2000?
I keep getting a "Unable to open Database" error. I've tried opening
with either the .Connect property and the LogOnServer method and get
the same message from either approach.I am using the OCX control.
Does this version work with Ms Sql?
Any thoughts and suggestions would be most appreciated.
Thanks.
-Dave"dschl" <dschl@.earthlink.net> wrote in message
news:1105990335.340202.156830@.z14g2000cwz.googlegr oups.com...
> Has anyone had any luck getting Crystal Reports 8.5 to work with the
> Sql Server 2000?
> I keep getting a "Unable to open Database" error. I've tried opening
> with either the .Connect property and the LogOnServer method and get
> the same message from either approach.I am using the OCX control.
> Does this version work with Ms Sql?
> Any thoughts and suggestions would be most appreciated.
> Thanks.
> -Dave
Unfortunately, it seems you're not the only person to have problems:
http://groups.google.ch/groups?q=sq...ial&sa=N&tab=wg
But it is a supported combination, so if it isn't working, then perhaps
BO/Crystal can help you:
http://support.businessobjects.com/...es/c2009948.asp
Simon|||Taking a wild guess here. I suspect it's nothing to do with SQL.
Crystal uses various DLL's to access various parts of it's reports.
There will be one for database connectivity and one for graphs etc...
Quite a lot if I remember correctly.
I had problems with Crystal 10 and SQL 7 and found the issues were not
documented too well but weren't SQL issues. I had to use
http://www.dependencywalker.com/ to walk through the DLL's to find
which ones were needed.
Worth a quick check before delving into any SQL issues.
Ryan
dschl wrote:
> Has anyone had any luck getting Crystal Reports 8.5 to work with the
> Sql Server 2000?
> I keep getting a "Unable to open Database" error. I've tried opening
> with either the .Connect property and the LogOnServer method and get
> the same message from either approach.I am using the OCX control.
> Does this version work with Ms Sql?
> Any thoughts and suggestions would be most appreciated.
> Thanks.
> -Dave|||Thanks for the feedback. However, I have already done a Google search
and that's how I got here. I have found little information through the
search and nothing specific to this issue.
I also have seen the list of supported platforms, but this doesn't help
with the problem I'm seeing.
A little more detail, just in case someone has solved this one --
- The client platofrm is Win98,
- The client has installed the latest mdac as part of the MsSql install
- VB connects to the MsSql server through ADO, without error and data
flows as expected
- CR8.5 .LogOnServer method succeeds, returning an incremented instance
index.
- CR8.5 .Action=1 is the call that causes the "Unable to open database"
message.
Any other thoughts on this one?
-Dave|||dschl (dschl@.earthlink.net) writes:
> A little more detail, just in case someone has solved this one --
> - The client platofrm is Win98,
> - The client has installed the latest mdac as part of the MsSql install
> - VB connects to the MsSql server through ADO, without error and data
> flows as expected
> - CR8.5 .LogOnServer method succeeds, returning an incremented instance
> index.
> - CR8.5 .Action=1 is the call that causes the "Unable to open database"
> message.
We use Crystal Reports exentensively in our application. We have never had
any problems with Crystal connecting to SQL Server - we never try. The
database Crystal sees is a TTX file. The VB code access SQL Server and
then feeds Crystal a recordset.
I have no idea whether this is workable in your case. Personally, I try
to avoid contact with Crystal as much as possible.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Tuesday, March 20, 2012
Crystal Reports access denied error
I've been stumped trying to resolve the following error when running Crystal Reports on a new server I'm setting up:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
------------------------
Technical Information (for support personnel)
Error Type:
Seagate Crystal Reports ActiveX Designer (0x80043AC6)
Access denied.
/OrbitRpt/Crystal/AlwaysRequiredSteps.asp, line 57
I'm running a Win2K server (service pack 4) with Crystal Reports 8. I've tried setting the security to "Everyone - Full Control" on all folders but I'm still getting the "Access denied" error. Has anyone seen this before? Any info would be greatly appreciated. Thanks!The following changes fixed my problem:
To properly set up your System Environment Variables:
1. Create the directory "C:\Temp" if it is not already created.
2. Right-click on "My Computer" on the server machine, and choose "Properties".
3. Go to the "Environment" tab.
4. Under "User Variables", select "TEMP", and then click "Remove". Repeat for the variable "TMP".
5. Select any variable under "System Variables".
6. Change the value for "Variable" to "TEMP" (no quotes).
7. Change the value for "Value" to "C:\Temp" (no quotes).
8. Click "Set".
9. Change the value for "Variable" to "TMP" (no quotes).
10. Change the value for "Value" to "C:\Temp" (no quotes).
11. Click "Set".
12. Click "OK".
Be sure to give "Read" and "Delete" access to this TEMP folder so that the Crystal Reports web components can read and write to this directory.
Crystal Reports 8 User session expired error
As we are migrating from NT server to Win 2003 server. web applications are moved over from nt as well. I am facing problem with one the web apps which uses crystal reports 8. "User Session expired" error msg is popping out when we try to export the report into any supported format such html, excel, word etc.. The report comes up no issues..however unable to use export option.
I went through the business objects .pdf for user session expired err msg...but nothing helped. i am still stuck with this problem.
can anybody help me here pls.
FYI...It's a ASP/VB web appl using crystal reports 8.0 on Win 2003 machine.
thanks
DRM.Hello,
Further to my earlier msg, after commenting out the default error msg "User Session expired" i got this error msg
"The Report was not Exported. The selected report format may be disabled on the server" actually this is common msg coming up for all export formats...available in crystal 8.0 version.
Therefore, any ideas how to check/verify and Enable/Disable this on server?
ur help on this will be greatly appreciated.
thanks a ton in adv.
Cheers,
muki
Monday, March 19, 2012
Crystal Report Viewer "Error, Not Implemented"
To print it, the user has to push a button on vb which open a vb form called
CrViewer.
Since the source of the CR could be in a different location, im trying to make it load a db from a path that is saved into the db.
Private Sub Form_Load()
Dim lsSql As String
Dim lstr As String
Dim lDateDebut As Date
Dim lDateFin As Date
Dim lcFormulas As String
Dim liListcount As Integer
Dim lsPathBD As String
Dim lvRapportId As Variant
Dim llPeriodePaye As Long
Dim lCrxApplication As CRAXDRT.application
Dim lRapportCrystal As CRAXDRT.Report
Dim lCrxDatabaseField As CRAXDRT.DatabaseFieldDefinition
Dim i As Long
Set lCrxApplication = New CRAXDRT.application
Set lRapportCrystal = lCrxApplication.OpenReport(ObtenirRepertoireRapport() & "RapportAdmRemboursementCumul.rpt", crOpenReportByTempCopy) ' OptenirRepertoirRapport() is a function that return the path to the report directory that is saved in the database.
' Finds the path from the registry...
lsPathBD = GetSetting("GTS", "Demarrage", "RepertoireBD", "")
lRapportCrystal.DiscardSavedData
For i = 1 To lRapportCrystal.Database.Tables.Count
lRapportCrystal.Database.Tables(i).Location = lsPathBD
Next i
frmCRViewer.CRViewer.ReportSource = lRapportCrystal
CRViewer.ViewReport
Set frmCRViewer = Nothing
Set lCrxDatabaseField = Nothing
Set lRapportCrystal = Nothing
Set lCrxApplication = Nothing
End Sub
The problem is encounter when the Crystal Report is opening. it Open but then I get the Error "Erreur, Non Implment" with "Crystal Report Viewer" as title for the errmsg.
Im using Visual Basic 6.0 (SP6)
Windows XP Home, French (SP2)
Crystal Report 10.0.5.1025 Dev. Full, French
Any Help would be Appreciated.the properties of the Database are:
OLE DB (ADO)
Microsoft.Jet.OLEDB.4.0
C:\Projet\Simoneau\DB\DB.mdb
Access
1033
-6
Admin
When using the Crystal Report Tool, no error are popping up but when calling the command
CRViewer.ViewReport The Error pop's up.
I have download a sample from Planet Source
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=59818&lngWId=1
It also work fine using the Access/Excel(DAO) database source but if I change it to Microsoft.Jet.OLEDB.4.0 it keep giving me that same error.
Is there anyway to go around this error msg and display my report using Microsoft.Jet or do i have to use Access/Excel DAO absolutely ?
Crystal Report SQL ?
This is a project handed down, I'm not the one coding the program..
I have run the SQL Statement at the SQL Query and IT WORKS !
Cause i need to add another condition to it and its added into the WHERE clause.
The report which contains 2 subreports uses the SQL statement.
When i run the VB application, no information is shown out like the SQL Query.. No information at all..!
All because after i added the extra line which works fine in query.
The same thing happen when i tried adding the SQL into the main report's query..
I have no idea what is wrong with it. Does it have something to do with the main report ? Because my colleague tried using the subreport as main and she said it works.. She suggest it has something to do with the main report..
FYI: I never change codes in the VB application because the retriving of information is based on the SQL of the Crystal Report.
Help ?Would you mind including the SQL from the working version and the SQL from the non working ?|||Would you mind including the SQL from the working version and the SQL from the non working ?
SELECT
PROPLNHDR."APPL_NO", PROPLNHDR."INMODE", PROPLNHDR."TOTBPRM",
PRODOC."DOC_CODE", PRODOC."LETTER_DATE", PRODOC."RECD_DATE",
PROMED."MED_CODE", PROMED."LETTER_DATE", PROMED."RECD_DATE",
FC_S."FC_NAME", FC_S."RC_CODE",
LKBRANCHCODE."DESCRIPTION1",
LKAGTYPE."CHANNEL",
LKDOC."DOCGROUP"
FROM
{ oj (((("DLFSP"."dbo"."PROPLNHDR" PROPLNHDR inner JOIN "DLFSP"."dbo"."FC_S" FC_S ON PROPLNHDR."FC" = FC_S."FC") left JOIN ("DLFSP"."dbo"."PRODOC" PRODOC inner join "DLFSP"."dbo"."LKDOC" LKDOC ON PRODOC."DOC_CODE" = LKDOC."DOC_CODE") ON PROPLNHDR."APPL_NO" = PRODOC."APPL_NO") left JOIN "DLFSP"."dbo"."PROMED" PROMED ON PROPLNHDR."APPL_NO" = PROMED."APPL_NO") left JOIN "DLFSP"."dbo"."LKBRANCHCODE" LKBRANCHCODE ON FC_S."BR_CODE" = LKBRANCHCODE."BRCODE" AND FC_S."RC_CODE" = LKBRANCHCODE."RC_CODE") inner JOIN "DLFSP"."dbo"."LKAGTYPE" LKAGTYPE ON FC_S."AG_TYPE" = LKAGTYPE."AGTYPE"}
WHERE
LKAGTYPE."CHANNEL" = 'BANC'
ORDER BY
LKBRANCHCODE."DESCRIPTION1" ASC,
PROPLNHDR."APPL_NO" ASC
*** the above is the original code.. but the only thing i added to this line of SQL is to the WHERE clause
--> (PROPLNHDR."ST" IN ('PD', 'CO', 'AP')) AND
** it works in the SQL Query but not at the crystal report.. as in the main report.. This query is placed at the subreport..
Crystal REport run time error 6 over flow
What does that string look like?
Does it have special characters?
Crystal Report Query Engine error
My project is being done in Vb.Net 2003 and SQL Server2000. When I try to access the Crystal Report thru code only I get the query engine error. the Sql Query however works perfectly in Query Analyser.
The Query uses left outer join operation from 4 tables. Is there any way I can overcome my error?
Thanks in advance
JohnsyIt could be useful to know exactly what error message says, to figure out if we're dealing with connection problem, or there is an error in query.
Also, you could try running Profiler to see what happens on SQL Server when you run your report.|||hi johnsy,
i too got the same problem . please tell me the solution if had solved tat problem.
how to create dataset.xsd for 2 tables
Thursday, March 8, 2012
Crystal Report Error
After putting the crystalreportviewer into a form in visual studio .Net, I have choosen the DataBindings properties and type the path of the report source inside. The display in the design window of visual studio can see the report output but when I press F5 to run the debug, the browser came out the following error messge. Does anyone help to solve it?
Thank you.
Server Error in '/WebApplication2' Application.
------------------------
Load report failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Load report failed.
Source Error:
Line 12: <body MS_POSITIONING="GridLayout">
Line 13: <form id="Form1" method="post" runat="server">
Line 14: <CR:CrystalReportViewer id=CrystalReportViewer1 style="Z-INDEX: 101; LEFT: 16px; POSITION: absolute; TOP: 8px" runat="server" Width="936px" Height="1044px" ReportSource='<%# "C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports\Samples\Reports\General Business\World Sales Report.rpt" %>' SelectionFormula="{Customer.h~~Z}>0">
Line 15: </CR:CrystalReportViewer>
Line 16: </form>
Source File: c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx Line: 14
Stack Trace:
[LoadSaveReportException: Load report failed.]
CrystalDecisions.Web.ReportAgent.h()
CrystalDecisions.Web.ReportAgentBase.set_ReportSource(Object value)
CrystalDecisions.Web.ReportAgent.set_ReportSource(Object value)
CrystalDecisions.Web.CrystalReportViewerBase.set_ReportSource(Object value)
ASP.WebForm1_aspx.__DataBindCrystalReportViewer1(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx:14
System.Web.UI.Control.OnDataBinding(EventArgs e)
System.Web.UI.Control.DataBind()
System.Web.UI.Control.DataBind()
System.Web.UI.Control.DataBind()
WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx.vb:26
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032If your application is on Windows Server 2003, then try giving 'Read & Execute' authority to the "Network Service" account on your 'Windows\Temp' folder.
If you are using Windows 2000/Xp, then browse to your Documents and Settings folder. There you will find a folder by the name same as your machine name. Go into that folder and assign 'Read & Execute' authority to the 'ASPNET\Local Settings\Temp' folder.
If this doesnt work then try assigning full authority to the above specified folders.
Remeber that this solution will work if your rpts build action is 'Embedded Resource'. I am not sure about the other build actions.
Hope this helps!
Regards!|||i have the same problem
i allready try to change the security permission but it didn't effect
Crystal Report Error
How do I open the password protected .mdb when there is sub reports in the Crystal Report. I got it to work on reports which contains no subreports. The problem is with the ones thats got subreports. It crashes the calling program and generate the runtime error 20535
unable to open database incorrect session parameters.
Please help me.Hi
How do I open the password protected .mdb when there is sub reports in the Crystal Report. I got it to work on reports which contains no subreports. The problem is with the ones thats got subreports. It crashes the calling program and generate the runtime error 20535
unable to open database incorrect session parameters.
Please help me.
Urgent need please help me.
Crystal report 8.5 error
i am getting some error while installing crystal report 8.5 in windows 2003 server .help me to solve this problem .
i am not getting this error while installing in windows 2000 serverCrystal Reports 8.5 is not supported on Microsoft Windows Server 2003. Refer to kbase c2013125 for more information.
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=622D9A962C9998F6CBE3FA554E2C35E0?cmd=displayKC&docType=kc&externalId=c2009948&sliceId=&dialogID=360384&stateId=1%200%20356275
Crystal Report 8.5 ,VB6.0 -incorrect session parameters
VB6.0
Crystal Report 8.5
problem :
"Unable to connect: incorrect session parameters." Error Message
I generated my crystal report using PEOAuto. and having above error message when
crystalreport.preview
line is executed.
there is no formulaparameters are passed.
report is generated from crystal report properly, but its not work when i generate report from VB 6.0
pl point me where i am doing mistake.I have an example of VB 6 and CR 8.5 in my signature. It may help you.
Wednesday, March 7, 2012
Crystal Help (Quick Please!)
I am experiencing a very strange error and in dire need of immediate help as I have to present these to my clients tomorrow.
So here is the situation:
I have created a report and am working from my computer and connecting the crystal report to a DB on server X and it works fine when running.
I then open this same report up in server X locally and run the same report but this time no data comes up. I checked the SQL query from within the crystal report and ran it against the DB locally on server X and data is returned. So data is obviously there. Why is the actual report not displaying data in the preview when run locally on the server when it obviously has data.Open the report and do verify database
Crystal Error
I'm trying to print a rpt. file ( C.R. 8.5) from a VB.net program
code :
Dim Reporte As New crAlmacen
Dim x As String = Reporte.FilePath()
Dim x1 As String = Reporte.ResourceName
Reporte.SetDatabaseLogon("termi", "termi", "SERVIDOR1", "mestres")
Reporte.Refresh()
' Reporte.PrintOptions.PrinterName = "Lexmark Optra S 2455"
Reporte.PrintToPrinter(1, False, 1, 1)
An unhandled exception of type 'CrystalDecisions.CrystalReports.Engine.InvalidArgumentException' occurred in crystaldecisions.crystalreports.engine.dll
Additional information: Error in File C:\DOCUME~1\ADMINI~1\CONFIG~1\Temp\temp_50488d2a-21be-4a5a-a4df-ad83112d6274.rpt:
Invalid printer specified.
thanks a lotHI ,
I HAVE SOLVED THE PROBLEM
Dim Reporte As New crAlmacen
Dim x As String = Reporte.FilePath()
Dim x1 As String = Reporte.ResourceName
Reporte.SetDatabaseLogon("termi", "termi", "SERVIDOR1", "mestres")
Reporte.Refresh()
NEW CODE LINE
---------------------
Reporte.PrintOptions.PaperSource = CrystalDecisions.[Shared].PaperSource.Auto
---------------------
' Reporte.PrintOptions.PrinterName = "Lexmark Optra S 2455"
Reporte.PrintToPrinter(1, False, 1, 1)
AND NOW GO RIGHT
BEST REGARDS|||Glad that's sorted :D
Crystal Error
The library "PSDODBC.DLL" cannot be found.Have you checked to make sure your ODBC data source is correctly configured or installed?|||yes, I have checked the odbc connection and it's configured correctly.|||What is referencing PSDODBC.DLL so that it gives the error?|||I am getting this error when I go to print the report. It then will ask me to continue to open report for viewing only? Once that goes away it tells me the physical database cannot be found|||Since you have the DLL, have you tried registering it from the command line?
regsvr32 pdsodbc.dll|||when I do a search for this file it does not appear. and no I don't know how to register it.|||Have you searched Google to download it? The code I provided above will register the DLL when you enter it into the command line.
Remember that it will be case-sensitive.|||I found this when I googled..... but I'm still not sure why I'm getting error.
2) Mystery DLL names.
If you have used the Crystal feature "Convert Database Driver..." you will notice a list of DLL files in the pull down list. However, if you were to try to find these drivers on your PC, you would search for a long time. The reason is that the list of driver names hasn't been updated. These are the names of the DLL files used in the original 16bit version of the Crystal. To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.|||Well, have you converted your database driver, as it says there?|||I guess I'm a little confused here...if I go to the drop down menu on the convert database I get a variety of dll options...where I guess I'm confused is this..
To get the equivalent 32 bit file names, replace the first 2 letters "PD" with the "P2". So PDSODBC.dll becomes P2SODBC.dll. This is a file that you will actually find on your PC. These old file names also show up in error messages, so it helps to know how to decode them.
which files do I replace...BTW..I'm fairly new to crystal reports so bare with me :)|||This (http://support.businessobjects.com/communityCS/TechnicalPapers/cr_convert_database_driver.pdf) can explain it much better than I can.|||I had read that before, but my question with that is that on my convert, the default connection if you will is the pdsodbc.dll and all the other options in the drop down are not odbc connections? Am I missing something here??|||To be honest, that is confusing to me as well.|||LOL...good then I'm not the only one...This is a client site that I have these crystal reports on and they are the same as any other clients site and I am really confused on why this would be happening? the other weird thing about the drop down was that the ODBC connection that was listed is the PSDODBC.DLL?? Strange.|||Well, pdsodbc.dll is the 16bit database driver before the conversion. The file p2sodbc.dll is the 32bit driver. After more research, it seems that you just need the driver to be present and the messages will go away. Sounds logical, right?
Other than that, I don't know what else to say. Sorry.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work. Well I'm at a loss here...I guess I'll keep digging around. Thanks for all your help, let me know if you come up with something else.|||Sounds logical, but I even copied the P2 file and renamed it PDSOBDC.DLL to trick it and it didn't work.
Then maybe it isn't looking in that directory for the DLL.|||Good point...how can I find out where it's pointing|||That, I don't know. Google would have a better result than me.
Saturday, February 25, 2012
CryptographicException
CryptographicException "the parameter is incorrect" whilst designing a
report. Interestingly, I removed everything from the report so there is
nothing in the report, including the dataset and I still get this error. I
guess it must be corruption in the RDL. Can anyone suggest where I might
look?
thanksHi,
I get this error very often while designing reports.
When you get this error, Just Save the changes and Close the Project. Open
it again, you will not have the error.
Hope this helps
Ponnurangam
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
>I started getting the error
> CryptographicException "the parameter is incorrect" whilst designing a
> report. Interestingly, I removed everything from the report so there is
> nothing in the report, including the dataset and I still get this error.
> I
> guess it must be corruption in the RDL. Can anyone suggest where I might
> look?
> thanks
>|||I got this problem also. The problem exists even after I reboot my computer.
There are other corruption issues, such as all of a sudden, the report would
stop passing parameter to execute a stored procedure in dataset... Again,
saving, closing, rebooting, and reopening didnt help. I ended up having to
recreate the rdl,
I now establish version control, so that I can revert back to an older,
workable version.
"Ponnurangam" wrote:
> Hi,
> I get this error very often while designing reports.
> When you get this error, Just Save the changes and Close the Project. Open
> it again, you will not have the error.
> Hope this helps
> Ponnurangam
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
> >I started getting the error
> > CryptographicException "the parameter is incorrect" whilst designing a
> > report. Interestingly, I removed everything from the report so there is
> > nothing in the report, including the dataset and I still get this error.
> > I
> > guess it must be corruption in the RDL. Can anyone suggest where I might
> > look?
> >
> > thanks
> >
> >
>
>|||Thanks for your replies,
I found that deleting the data file resolve the problem in my case.
regards
Matt
"LBJOHN" <LBJOHN@.discussions.microsoft.com> wrote in message
news:B7A559E8-576B-43AC-9164-548AC6F145BA@.microsoft.com...
> I got this problem also. The problem exists even after I reboot my
computer.
> There are other corruption issues, such as all of a sudden, the report
would
> stop passing parameter to execute a stored procedure in dataset... Again,
> saving, closing, rebooting, and reopening didnt help. I ended up having
to
> recreate the rdl,
> I now establish version control, so that I can revert back to an older,
> workable version.
> "Ponnurangam" wrote:
> > Hi,
> >
> > I get this error very often while designing reports.
> >
> > When you get this error, Just Save the changes and Close the Project.
Open
> > it again, you will not have the error.
> >
> > Hope this helps
> >
> > Ponnurangam
> >
> > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
> > >I started getting the error
> > > CryptographicException "the parameter is incorrect" whilst designing a
> > > report. Interestingly, I removed everything from the report so there
is
> > > nothing in the report, including the dataset and I still get this
error.
> > > I
> > > guess it must be corruption in the RDL. Can anyone suggest where I
might
> > > look?
> > >
> > > thanks
> > >
> > >
> >
> >
> >
Cryptographic Exception
Cryptographic Exception: The parameter is incorrect.
I'm told to look in the task list for details, but it is empty. I've
previewd this report a dozen times during the design and now it barks. This
is the first time i've opened it today, yesterday it was fine. I'm
referencing a stored procedure in SQL server and can view the data from the
data tab. Not sure what to do.
Any suggestions appreciated.
--
RichardDid you ever find out what this means. I just re-opened a report I worked on
last week. THe report renders but I get the message when trying to export the
results to ANY format.
"Richard Roche" wrote:
> Midway thru a report development I get an error:
> Cryptographic Exception: The parameter is incorrect.
> I'm told to look in the task list for details, but it is empty. I've
> previewd this report a dozen times during the design and now it barks. This
> is the first time i've opened it today, yesterday it was fine. I'm
> referencing a stored procedure in SQL server and can view the data from the
> data tab. Not sure what to do.
> Any suggestions appreciated.
> --
> Richard