Saturday, November 10, 2012

How to run oracle sql scripts from command prompt

Thought it seems to.be fundamental, some times on time when it needs things may not be re-collected immediately. For any one's quick reference....

Here we go,

For example :
The DB script which you want to run consider it's name is 'run.sql' and it is in C:\ drive @ Scripts folder.
So go to command prompt ->  and be in the folder where script is available.
It will be like
 
c:\scripts\sqlplus SchemaName/dataSourceName @ run.sql

Hope it helps some one.


Thanks,
Ravi

a program can't display a message on your desktop


Recently on my laptop (windows vista) i am getting one warning pop up message every time
like 'a program can't display a message on your desktop ' , I did search and applied below solution.
It seems to be working fine. I have not got same kind message later time. I just felt update here for some one's quick reference.

start -> run -> services.msc -> search for service name 'Interactive Services Detection' .
So here either stop or disabled the service.

Hope it helps some one.


Thanks,
Ravi






Thursday, November 17, 2011

Interesting point about JavaScript array sorting

Hi All,
Would like to share one point on java script
array sorting, recently one of my team members had one issue during this we realized this one. So it made me to pen this article.

Sorting arrays in JavaScript is done via the method array.sort(). While calling sort() by itself simply sorts the array in alphabetical order.

For example :

//Sort alphabetically and ascending:
var myarray=["CC", "BB", "AA"]
myarray.sort() //Array now becomes ["AA", "BB", "CC"]

Notice that the order is ascending. To make it descending instead, the simplest way is to enlist the help of another Array method in combination, array.reverse():

//Sort alphabetically and descending:
var myarray=["CC", "AA", "BB"]
myarray.sort()
myarray.reverse() //Array now becomes ["CC", "BB", "AA"]

Now, before you start feeling comfortable, consider what happens if we call array.sort() on an array consisting of numbers: ????


var myarray=[7, 40, 300]
myarray.sort() //Array now becomes [300,40,7]

Although 7 is numerically smaller than 40 or 300, lexicographically, it is larger, so 7 appears at the very right of the sorted array. Remember, by default array.sort() sorts its elements in lexicographical order.

And there you have it with array.sort() in terms of its basic usage. But there's a lot more to this method than meets the eye. Array.sort() accepts an optional parameter in the form of a function reference that pretty much lets you sort an array based on any custom criteria, such as sort an array numerically or shuffle it (randomize the order of its elements).
Passing in a function reference into array.sort()
As touched on already, array.sort() accepts an optional parameter in the form of a function reference (lets call it sortfunction). The format of this function looks like this:

array.sort(sortfunction)

function sortfunction(a, b){
//Compare "a" and "b" in some fashion, and return -1, 0, or 1
}

When such a function is passed into array.sort(), the array elements are sorted based on the relationship between each pair of elements "a" and "b" and the function's return value. The three possible return numbers are: <0 (less than 0), 0, or >0 (greater than 0):

    Less than 0: Sort "a" to be a lower index than "b"
     Zero: "a" and "b" should be considered equal, and no sorting performed.
     Greater than 0: Sort "b" to be a lower index than "a".

To sort an array numerically and ascending for example, the body of your function would look like this:

function sortfunction(a, b){
return (a - b) //causes an array to be sorted numerically and ascending
}

More on this below.
Sorting an array in numerical order

To sort an array in numerical order, simply pass a custom sortfunction into array.sort() that returns the difference between "a" and "b", the two parameters indirectly/ automatically fed into the function:

//Sort numerically and ascending:
var myarray=[25, 8, 7, 41]
myarray.sort(function(a,b){return a - b}) //Array now becomes [7, 8, 25, 41]

This works the way it does because whenever "a" is less than "b", a negative value is returned, which results in the smaller elements always appearing to the left of the larger ones, in other words, ascending.

Sort an array numerically but descending isn't much different, and just requires reversing the two operands "a" and "b":

//Sort numerically and descending:
var myarray=[25, 8, 7, 41]
myarray.sort(function(a,b){return b - a}) //Array now becomes [41, 25, 8, 71]

Thats it.

Hope it will useful to many.

Note: Content is refereed from javascriptkit site.

 

Thanks,
Ravi




How to make default page for a site in IIS 7.0

Hi All
Though it seems simple, just wanted to share how to make a default page for IIS 7.0
Generally many applications may display login page as default, in some cases some other pages. So let see how can we do this in IIS 7.0

1) Run -> inetmgr  (It opens IIS settings)
2) Go to your site (application which is hosted / application / folder) on selection of your site,
    you can see options to view the settings at bottom side with 'Features View' and  'Content View'  select the 
    'Features View', here we go, under IIS section we have an option of  'Default Document' , it will allow us to 
     add us the page name which you want to display. And also it allows us to add many pages also and lists all pages which are added. So top one page is the default page which will display when you access the site.
And also it provides couple of actions to move up and down the already added default pages based on our requirement.  Just select the page you can see the 'Actions' window which has the options will allow us to do.


Thanks,
Ravi

Wednesday, October 26, 2011

Looking to add Free Analog Web Clock to web sites

Looking to add free clocks to web sites ??
Here you go, 
This is for your quick reference , It seems to be a good link where you can get the several types
of clocks with JS code available. All you need to do is select the region , model , if any customization needed, select it generate the javascript code and use this code in your html pages if at all you are looking to display clocks..
Have a glance this link..




Thanks,
Ravi



Monday, October 24, 2011

404.2 The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server

All,
Recently we faced one error (404.2 The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server) while accessing an application on 2008 R server (IIS 7.0). Our application is in .net framework 4.0. 
When I had seen about this error initially what ISAPI and CGI, i could not recall immediately. 
So just to give brief on this,
ISAPI : Internet Server Application Programming Interface.           
CGI    : Common Gateway Interface.

To avoid this problem, below steps were taken place. Let see it may helpful for you.
a) Go to inetmgr, (IIS)
b) Clicked on the server.
c) Double click “ISAPI and CGI Restrictions”
e) Right click of ASP.NET v4.0 (which is available from framework64 bit) -> and made it allowed.  
 f) iisreset (run  -> iisreset  )

After performing above steps, I could able to access my application with out issues.
Hope it may helpful .



Thanks,
Ravi

BadImageFormatException in 64 bit windows

All, 
Recently we were trying to move some of our dot net applications from one production server which is in 2003 R2 platform with 32 bit system to 2008 R2 platform with 64 bit system.

We just moved the application .net components / binaries to new server (which is nothing but 2008 R2 + 64 bit system) and as this application's back end is Oracle data base . We installed the Oracle 11g client (64 bit) and created the application pool and necessary virtual directory and pointed to application at IIS level. When we ran the application we are getting errors as 'BadImageFormatException ..etc' related. After couple of hours of analysis and google search, we realized it could be because of bit versions conflicts, as application binaries in 32 bit format, application containing oracle client dll of 32 bit and target system is 64 bit and newly installed oracle client is 64 bit.  

And we wanted to have total application in 64 bit format only, so below steps we have performed and able to load the application successfully.

a) Open the application , deleted the reference to existed oracle client dll.
b)  Refereed to newly installed oracle client dll which is of 64 bit version (this dll can be get it from GAC).
c) Now we have built the application in 64 bit mode. (This setting can be seen from visual studio, right click of project -> Project Properites -> Build Tab -> General Section -> here you go, option to choose the plat form, Platfrom target: selected to x64)
d) And after building the application, we published the project. It has given us fresh binaries of 64 bit compatible.

So we moved this binaries to new test server : Here we did as
(system is 2008 R2, 64 bit, IIS 7.0)
a) created application pool, selected associated framework with classic mode.
b) Created virtual directory, pointed to application pool which is created in above step.
c) mapped the application binaries which newly created.
d) did the iisreset (run -> cmd -> iisreset )

Thats it, We access the application with out issues.  Hope it may works for you ...


Thanks,
Ravi
'Whether article is small or big, nothing wrong in sharing, definitely every post may helpful to some one some where.....'