|
something tells me it has to do with text Encodings.
Char '' is ASCII another value than in other ISO-languages.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Dear All,
Sorry for the repeat post, but i want the solution for this problem.
I have created a web application which includes crystal report for reports. Now the problem is that my reports were not working on the webserver.
The Application works Perfectly on my local machine in IIS and in .net environment but if i upload the same application on the web server it shows the error.
<per>
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
What could be the solution
Thanks and Regards
Yogesh Agarwal
|
|
|
|
|
yogesh_kumar_agarwal wrote: What could be the solution
Enable error reporting and see the error message. Once you fix it, disable the error reporting.
|
|
|
|
|
Hi, Thanks for the reply, I set the mode to off then i get the follwoing error message. Which is my actual problem that crystal report is not working on server.
Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 73: </customErrors>
Line 74: -->
Line 75: <httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers></system.web>
Line 76: <system.webServer><handlers><add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode"/></handlers><validation validateIntegratedModeConfiguration="false"/></system.webServer></configuration>
Source File: f:\inetpub\vhosts\aiivt.com\subdomains\market\httpdocs\web.config Line: 75
Yogesh
|
|
|
|
|
Copy the following files to the BIN folder of your application.
crystaldecisions.crystalreports.engine.dll.
crystaldecisions.reportsource.dll
crystaldecisions.shared.dll
crystaldecisions.web.dll
|
|
|
|
|
Hi, Thanks for the reply. Now the following error comes into the picture.
Parser Error Message: Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 31: <add assembly="CrystalDecisions.Shared, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 32: <add assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 33: <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 34: <add assembly="CrystalDecisions.Enterprise.Framework, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 35: <add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation>
Source File: f:\inetpub\vhosts\aiivt.com\subdomains\market\httpdocs\web.config Line: 33
Previousally i tried the same i got the same error message. and i upload the same code on to different server then i got the message for
"Required Permission not Acquired"
Thanks
Yogesh
|
|
|
|
|
Make sure the versions specified in your config file exist in the server. This error may come when versions are not matching.
|
|
|
|
|
i hosted my website on a shared hosting server. Now how could i check the same. My vendor ask that we are not providing the CR support on the server.
But i made some google R&D and found that there is no requirment to install the crystal report separately on the server the support is included with in the .net framework which is available on my server bcoz application without CR is working good on my server.
So plz suggest what could i do to run CR on my server.
Regards
Yogesh Agarwal
|
|
|
|
|
I use nodaddy, oops, i mean godaddy (shared hosting), and i couldnt use CR, i asked them, and they said they had no support for CR, i guess they disable it in shared hostings, because they want you to pay more $$$ for a dediated server
Alexei Rodriguez
|
|
|
|
|
ha ha ha ha.....
Thanks for the reply buddy, i think you are right bcoz,
One of my friend gave me the details for his dedicated server, and i just install the CR redistributable runtime on that server and my reports start working there.
So i came to the results that the server must have atleast the redist. package to run CR. But now the another doubt is,
the redist is available free of cost from Business Object's website and from Microsoft also. So Is there is some license is required if we install that on our server
Yogesh
|
|
|
|
|
Use of prepared statement for displaying data in gridview
|
|
|
|
|
Prepared???
Alexei Rodriguez
|
|
|
|
|
Prepared statements are JAVA's method for writing parametrized SQL, right? In .NET, you call it as parameterized queries. You write it like
string query = SELECT * FROM SomeTable WHERE SomeId = @id;
......
yourCommand.Parameters.AddWithValue("@id",someid); For more information, read SQL Injection Attacks and Some Tips on How to Prevent Them[^]
|
|
|
|
|
Are you talking about JDBC.
If so look into this...
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html[^]
If you are talking about ASP.NET
it will be similar, just you need to replace the ? marks with appropriate names.
Thus instead of
PreparedStatement updateSales = con.prepareStatement(
"UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ? ");
updateSales.setInt(1, 75);
updateSales.setString(2, "Colombian");
updateSales.executeUpdate():
We write
SqlCommand cmd = new SqlCommand("UPDATE COFFEES SET SALES = @psales WHERE COF_NAME LIKE @pconfname",connection);
cmd.Parameters.add("@psales",SqlDbType.Int);
cmd.Parameters("@psales").Value = 75;
cmd.parameters.add("@pconfname",SqlDbType.Varchar);
cmd.Parameters.add("@pconfname").Value = "Colombian";
cmd.ExecuteNonQuery();
Hope you get this.
|
|
|
|
|
I have been more of a C# desktop programmer. This is a pretty fundamental ASP.NET question.
I realize that all post-backs to a ASP.NET page cause the page to be reloaded. Therefore:
1. Any variables I create global to the page class will be re-initialized with each post-back. Is that correct?
2. Does that mean that nothing really persists from post-back to post-back?
3. What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?
Thanks,
Mark
|
|
|
|
|
1 - yes
2 - yes, unless it's static, or stored in the session, the application or viewstate.
3 - Probably. That's at least in part b/c you're writing bad code, putting your database on your form, instead of in a data layer. .NET does do connection pooling, however.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
MarkMokris wrote: 1. Any variables I create global to the page class will be re-initialized with each post-back. Is that correct?
Yes.
MarkMokris wrote: 2. Does that mean that nothing really persists from post-back to post-back?
Yes and that depends on how you are maintaining the data during postback.
MarkMokris wrote: What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?
Yes. You have to very much clear about asp.net page lifecycle and PostBack Property.
|
|
|
|
|
Abhijit Jana wrote:
MarkMokris wrote:
What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?
Yes. You have to very much clear about asp.net page lifecycle and PostBack Property.
I tought that:
The sql statement wont be executed on every postback, just the first time. On postbacks caused by other controls, the gridview will be regenerated from its view state
If the gridview causes a postback, something like sorting or paging, or you call databind, then it will re execute the sql statement again
Alexei Rodriguez
|
|
|
|
|
Alexei,
AlexeiXX3 wrote: The sql statement wont be executed on every postback, just the first time. On postbacks caused by other controls, the gridview will be regenerated from its view state
It depends on how you set DataSource to the GridView . If it is set in the markup, like the below
<asp:GridView ID="grd" runat="server" DataSourceID="sql_ds_id">
.....
</asp:GridView> GridView will be regenerated on each postback. You can workaround this by removing the DataSourceID="sql_ds_id" from markup and binding from code when required. Then it will be loaded from ViewState each time. Other way is to enable caching on SqlDataSource .
|
|
|
|
|
N a v a n e e t h wrote: GridView will be regenerated on each postback.
It will be regenerated, but not by executing the sql statement again, it will be regenerated from the viewstate. You can use the sql profiler, or just put a breakpoint in the selecting event of the sqldatasource
I have the following code, and it only executes the SQL statement the first time the page is requested but not on postbacks caused a test button on the same page
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="Name" HeaderText="Name"
SortExpression="Name" />
</Columns>
</asp:GridView>
SqlDataSource1 doesnt have caching enabled
Alexei Rodriguez
|
|
|
|
|
MarkMokris wrote: Any variables I create global to the page class will be re-initialized with each post-back. Is that correct?
Yes
MarkMokris wrote: Does that mean that nothing really persists from post-back to post-back?
As Christian said, static variables will be persisted as static variables are destroyed only when the application domain which hosts ends. ASP.NET provides many other persistent mechanisms. Beginners Introduction to State Management Techniques in ASP.NET[^] will get you started.
MarkMokris wrote: What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?
Yes if caching is not enabled on SqlDataSource . Using SqlDataSource other than academic purpose is not recommended. It forces you to write SQL inside your markup. There are better ways to get data and do binding.
|
|
|
|
|
[Asp.Net 2.0 + C#.Net]
i have 2 textbox controls
assume
TextBox1 is 150
then in
TextBox2 one hundred and fifty
i need to display
suppose
TextBox1 is 19999
then in
TextBox2 Nineteen thousand nine hundred ninety nine
i need to display
how to do,help me out....
|
|
|
|
|
katarukoti wrote: i have 2 textbox controls
assume
TextBox1 is 150
then in
TextBox2 one hundred and fifty
i need to display
suppose
TextBox1 is 19999
then in
TextBox2 Nineteen thousand nine hundred ninety nine
i need to display
Is this your homework ?
|
|
|
|
|
|
hello everyone...
anybody who can help me how to use a third party OCX in my ASPX... said OCX is a UI and was developed in VB6.
I want to use in in my ASPX(C#) page. I tried to add it as a compnent but it doesn't work.... I need it badly for my new project.... Thanx in advance....
xxx
|
|
|
|