Hi,
I am using CrystalReport from MS Visual Studio .Net. The report was created by the designer. It accesses a MySQL DB by the MyODBC 2.5 driver. Everything works fine on my development machine. I call the form which implements the crystalreportview and the report is displayed. Hoever, if I create an installation and run it on the deployment machine, a dialog is displayed requesting for server name, database, user name and password. Whatever I type in the login fails ("login fails. please retry"). I tried the MyODBC DSN and the MySQL user - without success.
Was anyone facing the same problem? I don't know how to proceed, it is really a strange issue, because the application runs on my development machine...
Thanks in advance.
gbrOkay. Please ignore my posting. I found out that different user accounts were created...
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Sunday, February 19, 2012
Database Logon problem Crystal Report
I am using following code in form load.
it works fine on one PC but when i run the same application on other pc with different version of Windows Xp it is asking for database logon for report.
I did tried using my provided login info using code but it is executing front end query as well as query in the report.
Any Suggestions will be appreciated.
Thanks in advance
ConnStr = "PROVIDER=MSDAORA.1;PERSIST SECURITY INFO=FALSE;USER ID=scott;PASSWORD=tiger;DATA SOURCE=orcl"
conObj = New OleDbConnection(ConnStr)
strsql = "select * from emp"
cmdObj.Connection = conObj
cmdObj.CommandText = strsql
daObj.SelectCommand = cmdObj
daObj.Fill(dsObj, "test")
rptDoc.Load("\\server\reports\abc.rpt")
srcCr = rptDoc
srcCr.SetDataSource(dsObj)
CRV.ReportSource = rptDoc
CRV.Show()i used CR viewer of CR XI ,it solved the problem. other system had cr viewer 9.5
it works fine on one PC but when i run the same application on other pc with different version of Windows Xp it is asking for database logon for report.
I did tried using my provided login info using code but it is executing front end query as well as query in the report.
Any Suggestions will be appreciated.
Thanks in advance
ConnStr = "PROVIDER=MSDAORA.1;PERSIST SECURITY INFO=FALSE;USER ID=scott;PASSWORD=tiger;DATA SOURCE=orcl"
conObj = New OleDbConnection(ConnStr)
strsql = "select * from emp"
cmdObj.Connection = conObj
cmdObj.CommandText = strsql
daObj.SelectCommand = cmdObj
daObj.Fill(dsObj, "test")
rptDoc.Load("\\server\reports\abc.rpt")
srcCr = rptDoc
srcCr.SetDataSource(dsObj)
CRV.ReportSource = rptDoc
CRV.Show()i used CR viewer of CR XI ,it solved the problem. other system had cr viewer 9.5
Friday, February 17, 2012
Database Logon Failed SSRS
Hi All,
My Report Server works find but after apply SQL Server 2005 Service Pack2. I can't connect to ReportServer Database. When Trying to connect from SQL Server Management Studio i get following Page.
TITLE: Connect to Server
Cannot connect to VISTA.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3054.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR![[:#]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uyLA3jsmC58bR_7-DZSDIifeoeTmMILNaS08AZBziRRJ-ABXGztEtzZO_0uwuZwkn0vCryev4HIBv02m4zni7iGNFa1_AFFUB7p6sPU_auJsCCmwHqZIK3e8W1apNFwTSuZNysIKv60wM15h2AVP2ar8BVZs6wmw=s0-d)
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul>
<li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
Colud anyone help me to resolve this issue please?
Thank you very much.
Regards,
Balwant Patel
Try using the Reporting Services Configuration Utility (Database tab) to generate a database script and apply this script manually to your ReportServer database.|||Did you just put on SP2? I had the same error very shortly after I put either SP2 or a hotfix (can't remember which), and it was fixed after a complete system restart and hasn't returned.
|||Make sure that the Service Accoutn the Reporting Server is running under has appropiate permissions to access the Report Server Database.Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
Hi Teo,
Thank you very much for your response... I tried with Database script but it doesn't work.
Regards,
Balwant Patel.
|||Hi gnieboer,
Thank you very much for response...I also restarted my system after apply SQL Server 2005 SP2 but I can't get rid of the problem.
Regards,
Balwant Patel
|||Hi Suessmeyer,
I check permission on Report Server Database...It is fine
Regards,
Balwant Patel
|||Which account has been granted access to the Report Server database, the ReportService Account (Windows Service) or the ASP_Net Worker process ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi suessmeyer,
I m using Windows Service Account
Regards,
Balwant Patel
|||Make sure that the the ASPNET account is a member of the SQLServer2005ReportingServicesWebServiceUser$<computername> $MSSQLSERVER Windows group and NT Authority\System is a member of the SQLServer2005ReportServerUser$<computername>$MSSQLSERVER group.|||Hi Teo,
Yes, ASPNET Account & Authority\System are members of above groups...
I dont know what's the problem with it...
Regards,
Balwant Patel.
database log file size
I want to ask what are the impacts if I limit the file size to certain MBs and will it report (File is full) or overwrite old data when the file reachs the assigned size?
you have to configure an alert (several MB) before log gets full.
when the log gets full no change in the database shall be committed.
|||
but is it true that SQL Server will be faster if the allocated size for the log file was larger?
|||
Jassim,
Perhaps you are referring to an auto grow capability of data and log files. By default database files are created with auto grow option. Each time a file reaches it's full capacity it gets resized, by the specified amount (either fixed size or percentage). This operation has some negative impact on the database performance, so in general it should be avoided. The autogrow functionality is primarly useful in systems that are not closely monitored by an adminstrator, for example embedded applications.
So if you set the initial log size to be bigger, you avoid growing the log file on demand. You can monitor for the auto grow of log and data files using SQL Profiler by selecting Log File Auto Grow and Data File Auto Grow events.
Hope that helps.
Regards,
database log file size
I want to ask what are the impacts if I limit the file size to certain MBs and will it report (File is full) or overwrite old data when the file reachs the assigned size?
you have to configure an alert (several MB) before log gets full.
when the log gets full no change in the database shall be committed.
|||
but is it true that SQL Server will be faster if the allocated size for the log file was larger?
|||
Jassim,
Perhaps you are referring to an auto grow capability of data and log files. By default database files are created with auto grow option. Each time a file reaches it's full capacity it gets resized, by the specified amount (either fixed size or percentage). This operation has some negative impact on the database performance, so in general it should be avoided. The autogrow functionality is primarly useful in systems that are not closely monitored by an adminstrator, for example embedded applications.
So if you set the initial log size to be bigger, you avoid growing the log file on demand. You can monitor for the auto grow of log and data files using SQL Profiler by selecting Log File Auto Grow and Data File Auto Grow events.
Hope that helps.
Regards,
Database location in crystal report
Hello
i am totally new to crystal reports
Do we need to change database location of crystal report after installation at client side
If this is case then if there are 1000 reports, database location has to be changed for each report?
any there some shortcut to do this programmatically or any other wayHi,
use a DataSethttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf
or a ReportIni like this:
Private Sub ReportInit(ByVal blRefreshLocation As Boolean)
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crReportDocument As ReportDocument
Dim crSubreportDocument As ReportDocument
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crTableLogOnInfo As TableLogOnInfo
Dim crConnectioninfo As ConnectionInfo
Dim myArrayList As ArrayList = New ArrayList
'declare an instance of the report and the connectionInfo object
crReportDocument = New ReportDocument
crConnectioninfo = New ConnectionInfo
crReportDocument.Load(mstrReportName)
'pass the necessary parameters to the connectionInfo object
With crConnectioninfo
.ServerName = mstrDBServerName
.DatabaseName = mstrDataBaseName
End With
'set up the database and tables objects to refer to the current report
crDatabase = crReportDocument.Database
crTables = crDatabase.Tables
'loop through all the tables and pass in the connection info
For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
'set the crSections object to the current report's sections
crSections = crReportDocument.ReportDefinition.Sections
'loop through all the sections to find all the report objects
For Each crSection In crSections
crReportObjects = crSection.ReportObjects
'loop through all the report objects to find all the subreports
For Each crReportObject In crReportObjects
If crReportObject.Kind = ReportObjectKind.SubreportObject Then
'you will need to typecast the reportobject to a
subreport
'object once you find it
crSubreportObject = CType(crReportObject, SubreportObject)
'open the subreport object
crSubreportDocument =
crSubreportObject.OpenSubreport(crSubreportObject.SubreportName)
'set the database and tables objects to work with the
subreport
crDatabase = crSubreportDocument.Database
crTables = crDatabase.Tables
'loop through all the tables in the subreport and
'set up the connection info and apply it to the tables
For Each crTable In crTables
With crConnectioninfo
.ServerName = mstrDBServerName
End With
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
End If
Next
Next
crystalReportViewer.ReportSource = crReportDocument
End Sub|||You need to make database connection suggested above or Try to use DSN name
i am totally new to crystal reports
Do we need to change database location of crystal report after installation at client side
If this is case then if there are 1000 reports, database location has to be changed for each report?
any there some shortcut to do this programmatically or any other wayHi,
use a DataSethttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf
or a ReportIni like this:
Private Sub ReportInit(ByVal blRefreshLocation As Boolean)
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crReportDocument As ReportDocument
Dim crSubreportDocument As ReportDocument
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crTableLogOnInfo As TableLogOnInfo
Dim crConnectioninfo As ConnectionInfo
Dim myArrayList As ArrayList = New ArrayList
'declare an instance of the report and the connectionInfo object
crReportDocument = New ReportDocument
crConnectioninfo = New ConnectionInfo
crReportDocument.Load(mstrReportName)
'pass the necessary parameters to the connectionInfo object
With crConnectioninfo
.ServerName = mstrDBServerName
.DatabaseName = mstrDataBaseName
End With
'set up the database and tables objects to refer to the current report
crDatabase = crReportDocument.Database
crTables = crDatabase.Tables
'loop through all the tables and pass in the connection info
For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
'set the crSections object to the current report's sections
crSections = crReportDocument.ReportDefinition.Sections
'loop through all the sections to find all the report objects
For Each crSection In crSections
crReportObjects = crSection.ReportObjects
'loop through all the report objects to find all the subreports
For Each crReportObject In crReportObjects
If crReportObject.Kind = ReportObjectKind.SubreportObject Then
'you will need to typecast the reportobject to a
subreport
'object once you find it
crSubreportObject = CType(crReportObject, SubreportObject)
'open the subreport object
crSubreportDocument =
crSubreportObject.OpenSubreport(crSubreportObject.SubreportName)
'set the database and tables objects to work with the
subreport
crDatabase = crSubreportDocument.Database
crTables = crDatabase.Tables
'loop through all the tables in the subreport and
'set up the connection info and apply it to the tables
For Each crTable In crTables
With crConnectioninfo
.ServerName = mstrDBServerName
End With
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
End If
Next
Next
crystalReportViewer.ReportSource = crReportDocument
End Sub|||You need to make database connection suggested above or Try to use DSN name
Subscribe to:
Posts (Atom)