Skip to main content

Problems in Hosting Asp.Net 3.5 Arabic website Oracle DB and Crystal Report in IIS 7 Windows Server 2012 R2 Machine

In this post I want to share my experiences during the environment setup: We have a very old application developed back in 2012 , this application was deployed in windows server 2003 machine ,suddenly machine crash this month and client request us to deploy same application in Windows Server 2012 R2 Machine, in two days I have successfully deployed our application. Below are some issues that I have face, may be it will be helpful for someone or for me in future :) 1) I have installed Oracle 10g client an it runs smoothly , then I deployed Asp.net web application , when I run the app Arabic text was nor showing properly after some hour of R & D I found the solution I have change the systems from control panel > Region and Language >Administrative Tab 2) After this Restart the application and now Arabic character comes properly :) 3)Now Crystal report was not working properly because I forgot to put TNS Name in Oracle Client directory ,after TNS name file reports also work fine 4) But Crystal report is not print out from print button neither it export in PDF I am still looking for the solution :) 5)Another issue some of my request contain arabic characters that was setting values in database as ?????? .The work around was simple 6)I have put NS_LAND in my environment variable AMERICAN_AMERICA.WE8MSWIN1256. and restart my machine . 7)Now request strings are showing correct arabic text . Now every thing is working fine :)

Comments

Popular posts from this blog

Add Image in Navigation Drawer Android Studio Template

I have to add Image in one of my project in slider Menu ,
I have used Android Studio Template Navigation Drawer  for material design .
For adding header on top of the list I have modified few lines in code: below are the simple steps:

Create an Android Studio project and select  Navigation Drawer Activity as shown below
Now your project structure is like this:

Now open activity_main.xml  and add LinearLayout and image view as shown below highlighted lines

<android.support.v4.widget.DrawerLayout xmlns:android="http://schemas.android.com/apk/res/android"xmlns:tools="http://schemas.android.com/tools" android:id="@+id/drawer_layout"android:layout_width="match_parent" android:layout_height="match_parent" tools:context=".MainActivity"> <FrameLayout android:id="@+id/container" android:layout_width="match_parent"
android:layout_height="match_parent" />

<LinearLayoutandroid:layout_width="@d…

Using GIT with Android Studio on windows with terminal or toolbar

Today We are going to learn how we can create a git repository using android studio.
Android Studio Makes it very simple just follow the below steps and your project is on git :
First we setup our PC ::

Download git from :http://git-scm.com/download/win

install it.

for git repository online I am using Bitbucket  , bitbucket allow us to host private repository free you can also use github but your project should be public if you want to use it free.

Here I am going to use bitbucket:
Create repository
After creating repository  you will see screen like this


Now open AndroidStudio Create new project.
after creating the project clcik on VCS on menu strip  and enable git as shown below

Now your project git enabled ;
You can see terminal in andoid studio we can use it for git commands.
Now check terminal and write git status if it  give you below message :
'git' is not recognized as an internal or external command, operable program or batch file.
then you have to follow below steps …

Crystal Reports ToWords() and Propercase() function

I have to convert amount into words like 2150 to two thousand and fifty only .
for achieving this i have used towords() function in crystal report,



i have just create new formula

ToWords({abc.amount},0)+" Only"
 it returns me result but in lower case so i have converted into upperCase  like this
UpperCase(towords({abc.amount},0)) +" Only"
it returns me TWO THOUSAND AND FIFTY ONLY but i need First letter capital of every word
then i used
ProperCase(ToWord({abc.amount},0)+" Only"

ProperCase() give me following result

Two Thousand And Fifty Only

Hope it will help someone :)
HappyCoding :)