Skip to main content

Posts

Asp Classic Upload File Issue

Recently I have migrated asp classic application from old server to new server . I found file upload is not working in new IIS 7 Server . I found the solution from here "In IIS 7, click your site and expand it then click the ASP icon. Expand the Limits Properties icon, and change the value in the “Maximum Requesting Entity Body Limit” to a value larger than 200000"


 I fixed it by adding limit in applicationhost file C:\Windows\System32\inetsrv\config\applicationHost.config 
looked for asp tag

and update it like this










Recent posts

Conver String Split Comma separated Columns value into row

I have a table that save comma separated values in column

col_Name aa,bb,cc dd
I need output like this
aa bb cc dd
To achieve this I create below view :

CREATE OR REPLACE FORCE VIEW "VU_COMMA_STRING_TO_ROW" ("col_Name") AS
  select "col_Name" from (WITH     cntr     AS
(
     SELECT     LEVEL     AS n
     FROM     dual
     CONNECT BY  LEVEL <= 1 + ( SELECT  MAX ( LENGTH ( REGEXP_REPLACE ( col_Name
                                                                             , '[^,]'
                                 )     )                  )
                       FROM    table_Name
                     )
)
SELECT         REGEXP_SUBSTR ( table_Name.col_Name
                , '[^,]+'          -- Use + here, not *
                , 1
                , cntr.n
                ) AS FINENUMBER
FROM     table_Name
JOIN     cntr     ON     cntr.n     <= LENGTH ( REGEXP_REPLACE (col_Name|| ',', '[^,]'))

);

Hope It will be …

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 …

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…

[Error: ANDROID_HOME is not set and "android" command not in your PATH. You must fulfill at least one of these conditions.] Error: /Users/Naushad/IonicProjects/IonicApp/platforms/android/cordova/build: Command failed with exit code 2 at ChildProcess.whenDone (/usr/local/lib/node_modules/cordova/node_modules/cordova-lib/src/cordova/superspawn.js:135:23) at ChildProcess.emit (events.js:98:17) at maybeClose (child_process.js:766:16) at Process.ChildProcess._handle.onexit (child_process.js:833:5)

sudo ionic build android
[Error: ANDROID_HOME is not set and "android" command not in your PATH. You must fulfill at least one of these conditions.] Error: /Users/Naushad/IonicProjects/IonicApp/platforms/android/cordova/build: Command failed with exit code 2     at ChildProcess.whenDone (/usr/local/lib/node_modules/cordova/node_modules/cordova-lib/src/cordova/superspawn.js:135:23)     at ChildProcess.emit (events.js:98:17)     at maybeClose (child_process.js:766:16)     at Process.ChildProcess._handle.onexit (child_process.js:833:5)
to solve this i use following steps in terminal :
sudo chown -R Naushad /usr/local/lib/node_modules/cordova
still have same error than i do follwing step
export PATH=$PATH:/users/Naushad/android-sdks/tools  then i got below error  :) [Error: Please install Android target: "android-22".
Hint: Open the SDK manager by running: /users/Naushad/android-sdks/tools/android You will require: 1. "SDK Platform" for android-22 2. "Android SDK Plat…