Comments by Rahul 105 (Top 35 by date)

Its having issue in IIS server. Version used is 7.5. The prompt is windows security prompt to enter the credentials of the server user name and password and not crystal report prompting issue.

Its an ExcelQuestion done in asp.net project with c#.

i GOT THE SPACE VALIDATION CHECKING IN EXCEL AND ALSO THE TEXT LIMIT LENGTH IN THE SAME.
=LEN(O3)=LEN(SUBSTITUTE(O3," ",""))(For Space Validation in Excel). Also want to validate the length.

I got the solution. Just set showfisrtpage property true codewise or in properties of Crystal Report Viewer.

Tried as said .But didn't work.(Actually there is one data but no data shown)
SELECT t1.C3EmpRegId, t1.EmpId, t1.CitizenId, t1.CardNo AS OldCardNo, t1.AccountNo AS OldAccountNo,t1.ODUtilizedAmount,t1.ODLimit,t1.ODBalance, t2.CardNo AS NewCardNo, t2.AccountNo AS NewAccountNo
FROM (
SELECT TOP 1 E.C3EmpRegId,E.EmpId,E.CorporateId,E.CitizenId,E.CardNo,E.AccountNo, SA.SA_MaxUtilFees as ODUtilizedAmount,SA.SA_Limit as ODLimit,isnull(SA.SA_Limit, 0) - isnull(SA.SA_MaxUtilFees, 0)as ODBalance,E.SalaryAdvance
FROM Employee E INNER JOIN
SalaryAdvanceMaster SA on
SA.C3EmpRegId=E.C3EmpRegId
WHERE E.C3EmpRegId=16 and E.SalaryAdvance=1 and E.IsDeleted=1 ORDER by E.C3EmpRegId desc)
AS t1 INNER JOIN (
SELECT TOP 1 E.C3EmpRegId,E.EmpId,E.CorporateId,E.CitizenId,E.CardNo,E.AccountNo,SA.SA_MaxUtilFees as ODUtilizedAmount,SA.SA_Limit as ODLimit,isnull(SA.SA_Limit, 0) - isnull(SA.SA_MaxUtilFees, 0)as ODBalance
FROM Employee E
INNER JOIN
SalaryAdvanceMaster SA on
SA.C3EmpRegId=E.C3EmpRegId
WHERE E.C3EmpRegId=16 and E.SalaryAdvance=1 and E.IsDeleted=0 ORDER by E.C3EmpRegId desc
) AS t2 ON t1.EmpId = t2.EmpId
WHERE t1.EmpId='556556y' AND t1.CorporateId='IBM' AND t1.SalaryAdvance=1
ORDER BY t1.C3EmpRegId

Awaiting a reply on the same . We have set the path of each files as below in the web.config. But File Uploading isn't working in the server suddenly of late.
<add key="CHF_ErrorLogPath" value="\C3psps\FileUpload\CHF_BLOCKErrorLog\">
<add key="WORKING_FOLDER_CHF" value="\C3psps\FileUpload\CHF_WorkingFolder\">
<add key="CHFTEXT_BLOCK_FILE_ARCHIVE" value="\C3psps\FileUpload\CHF_TextFileArchive\">
<add key="MASS_CMS_UPDATE_FILE_PATH" value="\C3psps\FileUpload\MassUpdation\">

The issue is after downloading and on opening word file missing file/.css msg seen. Also in pdf format type after downloading and on downloading file type not supported shown in web server. There is acrobat reader ,ms office in my system and still issue persists on doing an asp.net application from web server

I saw many saying to clear the cache header in the above code:
Response.ClearHeaders();
Response.Clear();

Response.Buffer = true;
Response.ContentType = “application/csv”;
Response.AddHeader(“Content-Disposition”, “attachment;filename=report.csv”);
Response.Write(strData);
Response.Flush();
Response.End();

For instance for many employee Ids there is credited amount of 500,200 and debited amount of 100,100 for current month and year inserted in table(odid,amt,mode(C for credit,M for debit,Created Date etc) i want to get grand amount as (500+200)-(100+100)=500 binded to my crystal report and display in report viewer in the back end

Here CPU usage of the the Db server is 100% on running a service. What would be the resolution for the slowness of IIS server? Whether the db needs to be shrinked?

Is it possible to get SPs with exact table name. If use LIKE (rOLES,rOLE_USER ETC RELATED SPS TO THOSE WILL COME)
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT ='tablename'
But no Sp coming in above way.

How to get rid of the temp files creation under Crystal Report or change the directory from C:/WINDOWS/TEMP TO another folder in wwwroot and avoid load report issue without restarting server each day.

How can I redirect the above url Eg: https://www.sslshopper.com/article-how-to-create-a-self-signed-certificate-in-iis-7.html whoch would be after SSL to http://www.sslshopper.com/article-how-to-create-a-self-signed-certificate-in-iis-7.html.
Instead of host name should I provide the external distinct ip address

Its not woking on trying all these. I meant to convert http https for domain server.

Ok.Please provide a detailed link to convert http auto redirect to https inorder to cross check with I did.
I followed this:
http://www.jppinto.com/2010/03/automatically-redirect-http-requests-to-https-on-iis7-using-url-rewrite-2-0/
But the issue remains as http is not getting redirected to https and viceversa with SSL enabled.

Actualy I enabled ssl and not enforced the same. Then did as follows:

if (pageRequest.Scheme == "http" && pageRequest.Host.ToString().Contains("localhost") && requestPath.Contains(".aspx"))

{

Response.Redirect("https://" + pageRequest.Host + pageRequest.PathAndQuery, true);

}
But http not changing to https in local url.

I tried these too:
Redirect HTTP requests to HTTPS on IIS 7 using URL Rewrite 2.0
Hi,

You will need the following items completed in order for this to work correctly :

a) SSL Certificate for site installed in IIS.
b) Site properly installed and configured for SSL (site set up and binding in IIS configured).
c) URL Rewrite 2.0 is installed on the sever.

URL Rewrite has a GUI to allow you to enter rules within IIS 7; in the background all this does is edit the web.config file of the site.

1. In IIS select the website you wish to configure
2. In the “Features View” panel, double click URL Rewrite
3. You will notice there are currently no rules configured for this site. Click “Add Rules…” in the Actions menu to the right of the “Features View” panel
4. Use the default “Blank rule” and press “OK”.

5. When editing a rule there are the “Name” field and 4 configuration pull down boxes.

- Enter “Redirect to HTTPS” in the name field.
- Next we will configure the first configuration pull down box called “Match URL”, on the right side of “Match URL” press the down arrow to expand the box.
Within the “Match URL” configuration box we will set the following settings:

Requested URL: Matches the Pattern
Using: Regular Expressions
Pattern: (.*)

6. We can now edit the next configuration pull down box which is “Conditions”, Press “Add…” to add a new condition to the configuration.
We will configure the condition with the following settings:

Condition Input: {HTTPS}
Check if input string: Matches the Pattern
Pattern: ^OFF$

7. Press “OK”

8. You should see your condition in the list of conditions.

For this setting we do not need to configure the “Server Variables” pull down box. Continue onto the “Action” configuration box and pull down the box by selecting the arrow on the right. We will configure the following settings for the “Action” configuration:

Action Type: Redirect
Redirect URL: https://{HTTP_HOST}/{R:1}
Redirect Type: See Other (303)

9. Press “Apply” then press “Back to Rules”

10. You should now see the rule configured on the main screen of the URL Rewrite module.

11. Test your site, it should now redirect from HTTP to HTTPS.
SSL cert is enabled and with https its fine.
But on changing https to http it isn't redirecting to https.

I have enabled the ssl certificate in client server. I ran this on my local system. So how to see it gets converted.

I am getting google,yahoo etc as https://www.google.co.in/,https://www.yahoo.co.in/.
But redirecting from http to https not working.I mean url comes as http:// even if its redirected for https://

I tried by checking the internal url content and external url content in FOLLOWING way. Will it be fine?? My code as follows:

private void RedirectToCorrectSSLScheme()
{
Uri pageRequest = Request.Url;
string requestPath = pageRequest.GetLeftPart(UriPartial.Path).ToLower();

requestPath = Server.UrlDecode(requestPath);
// PageIsSecure returns if the given page should be secure or not. I
//maintain a list of secure pages or
//secure directory in an XML config.
// bool securePage = GetSecurePages().PageIsSecure(requestPath);
//Instead of localhost we can set the IP Address of Qatar server
if (pageRequest.Scheme == "https" && pageRequest.Host.Contains("localhost") && requestPath.Contains(".aspx"))
{
//Response.Redirect("http://" + pageRequest.Host + pageRequest.PathAndQuery, true);
Response.Redirect(requestPath, true);
}
//Added by Alex to check external url of qatar server
//Instead of localhost we can set the IP Address of Qatar server
if (pageRequest.Scheme == "http" && pageRequest.Host.ToString()!="localhost" && requestPath.Contains(".aspx"))

{
//Response.Redirect("https://" + pageRequest.Host + pageRequest.PathAndQuery, true);

Response.Redirect(requestPath, true);
}
}
void Application_BeginRequest(object sender, EventArgs e)
{
//Function Added by Alex on Jan 29,2014 to clear http/https issue under Qatar Server
RedirectToCorrectSSLScheme();

}

Its displayed on the client machine from the server machine where IIS is set. Its a web application and not a windows application. So installation should be done in IIS naa. I checked with an html page but the server machine isn't accessing the new font.

I have already installed under C/Windows/Fonts/... But IIS isn't taking the font. I tried with a html page in IIS,server machine and i am having the same issue. Should I restart the server?

I directly just added the font of barcode to my local server. But in IIS font is not taken.

I am using asp.net and in the service variuos updations and validations are checked. The issue is only after a while on clicking the button repeatedly the status changes.

In task manager process is running but various methods in service isn't working.

I tried

System.Diagnostics.Process.Start(@"D:\C3sps Project\COMMON\Source\Untested\C3psps\C3PSPS_SOD\bin\Debug\C3PSPS_SOD.exe");
Its in asp.net web interface where on a button click that windows service exe should run.

But the exe isn't running.

Is there a solution for the above?

The abvove is a question

Here there is design problem in some pages too. Also it must be alligned without compatibility view. In one IIS 7 server version its fine but issue with the other same version iis server.Compatibility is already set in web.config.

Do Recheck now on my question